https://bugs.freedesktop.org/show_bug.cgi?id=47106
Bug #: 47106
Summary: References, Adapt row hight and AutoCalculate slow
down Calc dramatically
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Release
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: blocker
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
In huge spread sheets that contain complicated formulas that reference several
other sheets, any change made to any cell will result in Calc becoming
unresponsive for several seconds to minutes.
This bug report is not about long loading times of spread sheets, but about
working with the spread sheet after loading.
With AutoCalculate enabled, Calc is slowed down dramatically, even when the
user does not interact with any element that would require re-calculation.
E.g., text input into cell "A1" in sheet "XYZ", followed by conformation with
the enter key, will result in waiting times up to 20 seconds or more, even
though none of the formulas in the spreadsheet reference anything in sheet XYZ.
It looks like Calc re-calculates the whole document whenever a change has been
made to it, without checking if any of these calculations are actually
necessary!
Deactivating AutoCalculate helps a little, but this is very inconvenient due to
Calc not calculating what it should calculate. When a formula is entered into a
cell, Calc will calculate and show the result. But when that cell is copied
down, the new cells will just copy the output of the original cell instead of
calculating the new output. The user has to change every cell manually, e.g. by
adding empty space into the formula, to force re-calculation.
After some time it might even happen that all cells that contain formulas
become blank until re-calculation is forced with "Ctrl+Shift+F9" or
AutoCalculate is re-enabled. This might be an issue with Calc trying to use as
little memory as possible (which would also explain why scrolling through a
document can be slow).
As a summary:
a) Calc should only re-calculate cells when a referenced cells was changed
b) Calc should make use of available memory in todays computers and thereby
speed up handling of large spreadsheets
--
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
