To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=67412
Issue #|67412
Summary|slow adjusting of row height when loading ods spreadsh
|eet
Component|Spreadsheet
Version|OOo 2.0.3
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|cphilipp
------- Additional comments from [EMAIL PROTECTED] Sat Jul 15 11:39:48 -0700
2006 -------
Hi,
I have a huge ods spreadsheet, about 300000 cells in 23 tables, with a lot of
database like operations on it (counting & pattern matching, DBMIN, DBMAX). The
overall size of the document is about 3 MB.
Naturally loading is slow.
On my Athlon X2 4200+ dual core with 2 MB RAM loading takes about 2:20 min.
The steps done during loading according to the messages shown in the status bar:
Loading: 0:14 min
Calculating: 0:25 min
Adjusting Row height: 1:40 min ("Zeilenhöhe anpassen" in my german version)
I have changed most rows to use standard row height, which improved the loading
time a bit. (Figures above have been taken after this optimization)
As the progress bar for "adjusting row height" was running often, I assume, this
step has been done for each table.
To improve the loading time I would like to make the following proposal on
adjusting the row height:
- check whether this is really necessary to be done during loading, before the
user can work with the spreadsheet.
- It might be necessary for the table selected, as mouse events must be handled
by the correct cell, so if the user can click to a cell, it should be after the
rendering of cells.
- For all other tables this step can either be done in the background or when
the user changes to a table not rendered yet. (rendering the cells is pure
layout, it will not have influence on cell content, right?)
hint:
The spreadsheet was converted from StarOffice 5.2 calc format, where the size
was about 40 MB (!, things improve!). If the conversion is part of the problem,
maybe also the import function for this format should be improved.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
