Bug 50551

Summary: FILEOPEN 165 second delay
Product: LibreOffice Reporter: libreoffice
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: LibreOffice, libreoffice, serval2412
Priority: medium    
Version: 3.5.4 release   
Hardware: x86 (IA32)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: FILEOPEN 165 second delay

Description libreoffice 2012-05-31 11:18:01 UTC
Created attachment 62344 [details]
FILEOPEN 165 second delay

opening the attached spreadsheet hangs the libreoffice process for 165 seconds (long enough to think it crashed).  during that time previously opened libreoffice document windows do not respond to window exposures.  other processes proceed normally.  system is idle.  finally libreoffice comes back alive and all documents including the attached spreadsheet display normally.  once an affected spreadsheet has been opened, no further hang occurs upon opening another affected spreadsheet, until libreoffice exits and is re-invoked.

hopefully this will be repeatable on other systems.  if not, i wonder if libreoffice may have blind dependencies on packages i don't have installed.  but even if so, it would seem odd that an empty spreadsheet retains some blind dependency, and copying all it's data to another spreadsheet does not copy the dependency.

the attached spreadsheet previously had several sheets and lots of data.  one day the delays began.  the first time it happened, i split the sheets out into separate documents.  the sheet i was most interested in happily had no further long wait, for several more months.  when it happened again recently, splitting the sheets into separate documents this time resulted in 2 out of the 3 sheets retaining the long delay.  so i copied the cells instead of the sheets.  thus i was able to rebuild the desired spreadsheet with no further long wait.  and interestingly, the long wait upon opening remained with the original (now attached) spreadsheet even with all content, and macros, removed.
Comment 1 Julien Nabet 2012-06-01 15:11:24 UTC
On pc Debian x86-64 with master and 3.5 branch, both updated today and with a brand new LO profile for each test, I didn't reproduce the pb.

Noticed this with master on console logs :
warn:legacy.osl:23912:1:/home/julien/compile-libreoffice/libo/unotools/source/config/configitem.cxx:516: XHierarchicalNameAccess: Syntax/StringRefAddressSyntax
/org.openoffice.Office.Calc/Formula/Syntax/StringRefAddressSyntax

BTW: what's your LO version ?
Which Linux distrib (+ version) do you use ?
Did you install specific LO extension ?
Did you try with a brand new LO profile ?
Comment 2 Rainer Bielefeld Retired 2013-01-25 06:54:09 UTC
NOT reproducible with "LibO  4.0.0.2 rc   -  GERMAN UI / German Locale  [Build ID: 5991f37846fc3763493029c4958b57282c2597e)]"  {tinderbox: @6, pull time 2013-01-24  07:20(?)} on German WIN7 Home Premium (64bit) with separate /40 User Profile for alphas etc.

Closing Bug due to reporter's inactivity as INVALID due to lacking information.
Comment 3 libreoffice 2013-01-25 16:09:53 UTC
i'm up to 3.5.4.2 now (ubu quantal), and sure enough the problem no longer reproduces.  thank you.
Comment 4 Rainer Bielefeld Retired 2013-01-25 16:18:16 UTC
No details known what might have fixed this one, so WFM