Apache OpenOffice (AOO) Bugzilla – Issue 47568
Calc edit slow, UI freezes for number of seconds
Last modified: 2013-02-24 21:21:57 UTC
openoffice.org1.9.93 or 2.0beta under Scientific Linux (RHEL3 clone) Importing a complex spreadsheet from 1.1, performance is very slow when trying to edit. (spreadsheet contains many sheets, with financial calculations on per-date basis, and other sheets with charts, mainly stacked charts and line charts referring to other sheets). After modifying a single cell, OOo thinks about it for a few seconds (doesn't refresh screen, etc. for about 20seconds for the above spreadsheet), then comes back to life. Keystrokes made in the intervening time are kept and inserted. Reducing the number of charts (by deleting the sheets containing them) reduces greatly this dead-time. This is not a good solution, though! No such problem with 1.1.3.
Hi, seems to be Chart related as you told us. o I changed the component. Could you please attach a document showing this behaviour ? Thanks Frank
Created attachment 25145 [details] Test case spreadsheet file (much reduced)
Attached a greatly simplified version of the original file, which has the same behaviour but freezing for less time. Behaviour can be seen by editing a few random cells in the first sheet.
FYI: On WindowsXP_SP2 with OOo1.9.91 on a Pentium M 1.3Ghz the document works fine for me. Maybe it's really OS-dependent.
Problems in calculation.
The charts are updated, and it's the handling of the metafiles for the chart replacement graphics that takes so long (Region::ImplPolyPolyRegionToBandRegionFunc, called by MetaClipRegionAction::Write).
@mav: Please take over, as discussed. I cannot practically change the region code, it has a comparably amount of bugs to SfxItemSet, and its bugs are relied on equally widespread throughout the office. Great speedups would be achieved, if serializing/deserializing of metafiles could be avoided. Another (though not very viable) option would be to change the metafile format incompatibly, by not writing out a banded region. That will cause display artifacts with older OOo versions.
Too much issues for 2.0.1
Still an issue with Openoffice.org 2.0 (some files block more than a minute after each edit). This is a killer, and makes it impossible for me to upgrade from ooo 1.1.2.
regression from OOo 1.X
Works acceptably on Openoffice.org 2.3
This issue is a duplicate of issue 83708 (which has a more easy to reproduce example doc attached). The issue is fixed already with integration of CWS chart15 in version ooh680_m2. You can download a developer version here to check if you like: http://download.openoffice.org/680/index.html?intcmp=1235 *** This issue has been marked as a duplicate of 83708 ***
closed as duplicate