Bug 40650 - FILEOPEN - Hanging on .ods opening while autoadjusting row height in LibO >3.3
Summary: FILEOPEN - Hanging on .ods opening while autoadjusting row height in LibO >3.3
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-06 04:47 UTC by Alexander Holik
Modified: 2011-12-27 08:59 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
LibO scalc row-hight autoadjustment - delayed (279.72 KB, image/jpeg)
2011-09-07 04:59 UTC, Alexander Holik
Details
LibO scalc recognized as non-responding application by Windows (179.10 KB, image/jpeg)
2011-09-07 05:01 UTC, Alexander Holik
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Holik 2011-09-06 04:47:21 UTC
Opening some 3.3 .ods documents either takes disproportionately long while performing automatic adjustment of row heights ("Zeilenhöhen anpassen" in german) or hangs the scalc.bin application altogether. During this step the process is repeatedly using up to a quarter of physical RAM and then either finally displays the sheet or is recognized as non-responding process by windows.
Comment 1 digital ant 2011-09-06 13:55:17 UTC
3.4.3 on OSX 10.6.8, Apple Java 6u26

-Opened a 53K ods spreadsheet with multiple row heights and large amount of formulas.
-Selected all rows, adjusted them to .75"
-Auto-adjusted all rows

The rows were resized immediately with no delay. I know the original bug report post was about windows - I just wanted to test on a Mac.


3.4.3 on Windows XP Pro SP 3 (32bit), Oracle JRE 6u26

Opened same spreadsheet as above, performed same steps, there was no delay.
Comment 2 Markus Mohrhard 2011-09-07 03:14:19 UTC
Are you sure that you are not using 3.4.0 or 3.4.1? We had this problem there but it should be fixed since 3.4.2.
Comment 3 Alexander Holik 2011-09-07 04:59:16 UTC
Created attachment 50955 [details]
LibO scalc row-hight autoadjustment - delayed
Comment 4 Alexander Holik 2011-09-07 05:01:35 UTC
Created attachment 50956 [details]
LibO scalc recognized as non-responding application by Windows
Comment 5 Alexander Holik 2011-09-07 05:02:47 UTC
(In reply to comment #2)
> Are you sure that you are not using 3.4.0 or 3.4.1? We had this problem there
> but it should be fixed since 3.4.2.

as with the data-sheet that I used when I came across the problem, the behavior is identical in all consecutive versions >= 3.4 up to the most recent build 302 of LibO 3.4.3. and different versions of the JRE from 1.6.23 and above (up to 1.7 which is not yet recognized by LibO).
Tested the sheet on four different computers with 32 and 64 bit versions of Win7, but the problem irrespectively remains.
I'm of course willing to provide the .ods concerned upon request, but cannot upload as attachment since it contains sensitive financial data and the data can't be readily modified so as to maintain the bug's "functionality" =].
see two screenshots attached for the case that LibO finally displays the sheet after (1) prolonged processing of the "soffice.bin" process and (2) is shutdown by windows.
Comment 6 Björn Michaelsen 2011-12-23 12:41:15 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 7 Alexander Holik 2011-12-27 08:58:28 UTC
the bug is gone in LOdev 3.5.0beta2!