https://bugs.freedesktop.org/show_bug.cgi?id=47299
Bug #: 47299
Summary: CALC: Escalating when re-calculating a huge number of
crosslinked cell functions (EDITING, FILEOPEN,
FILESAVE)
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Release
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: klauspeter.schm...@gmx.de
Created attachment 58421
--> https://bugs.freedesktop.org/attachment.cgi?id=58421
Zip archive with 4 files for the decribed testing scenario
In the case a CALC document consists of a huge number of cells which contain
sheetwise cross-linked cell functions, LibO's runtime seems to escalate and
leads to extremely slow performance and/or freezing/blocking of the GUI for
many seconds or minutes.
The effect concerns LOADING DOC, RECALCULATING on cell change event and SAVING
DOC.
It looks in such a way, as if at any time ALL cells are computed instead of
recalculating/refreshing only the changed and depending cells.
It also slightly remembers old BUG 40650, but directly 43804 and 47106.
The given example will IMHO reproduce the effects.
Test conditions of the following benchmark data:
OS: Windows Xp Pro SP3
CPU: Intel Core i5-2410M 2.30 GHz
RAM: 3 GB
COMPARED APPLICATIONS: OpenOffice 3.3.0, Excel97 and LibO.
Effects reproduced with LibO 3.4.3, 3.4.5, 3.5.0RC3,
LOdev3.5.2RC-nightlyBuild20120312 on WindowsXpSP3
AND LibO 3.5.0RC3 on Windows7Pro-64bit
Test:
Step 1: download zip and extract files
Step 2: try File 1 with OpenOffice
Step 3: extract File 2, and try xls with Excel97 or OpenOffice
Step 4: open File 1 with LibO
Step 5: change to sheet "Ansicht" and edit cell Y9 with Value 50 as displayed
in screenshots Files 3 and 4
Benchmarks:
LibO 3.5.0/ods
OPEN 376 s = 6 min 16 s
CALCULATE 30 s
SAVE 257 s = 4 min 17 s
(OPEN with 355 s remaining at progress bar message "Adapt row
height"/"Zeilenhöhe anpassen")
Excel97/xls:
OPEN 5 s
CALCULATE <1 s
SAVE 3 s
OOo 3.3.0/ods
OPEN 37 s
CALCULATE 5 s
SAVE 17 s
(OPEN with 25 s remaining at progress bar message "Adapt row
height"/"Zeilenhöhe anpassen")
Attachment: test-escalation-at-cross-linked-cell-functions.zip
contains
File 1: linked_tabs-many_formulas.ods
A simple stock management document, migrated from xls to ods, using many
cross-linked table formulas e.g.
english:
a) =IF($A9="";"";VLOOKUP(CA9;$Plan.BI$1:BL$1001;COLUMN(D6);0))
b)=IF(SUMIF($CQ9:$CU9;AA$2;$CL9:$CP9)=0;0;SUMIF($CQ9:$CU9;AA$2;$CL9:$CP9))
c) =IF(A9="";"";IF(SUM(CW9-$Plan.$J$2)<-1000;" no Arr !!";CW9-$Plan.$J$2))
german:
a) =WENN($A9="";"";SVERWEIS(CA9;$Plan.BI$1:BL$1001;SPALTE(D6);0))
b)
=WENN(SUMMEWENN($CQ9:$CU9;AA$2;$CL9:$CP9)=0;0;SUMMEWENN($CQ9:$CU9;AA$2;$CL9:$CP9))
c) =WENN(A9="";"";WENN(SUMME(CW9-$Plan.$J$2)<-1000;" no Arr
!!";CW9-$Plan.$J$2))
File 2: linked_tabs-many_formulas-export.xls
is a conversion from ods to xls
File 3: before_edit_cell_Y9.jpg
screenshot "before" doing the test
File 4: after_edit_cell_Y9_to_value_50.jpg
screenshot "after" having done the test
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
