The Zaske Case

From Apache OpenOffice Wiki
< Calc‎ | Performance
Revision as of 11:07, 10 September 2022 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


Comparison with Excel 2003/2007 that need 1.2s where Calc needs 24s after changing a cell's value.

References:

Findings: lots of formulas directly or indirectly referring the input cell, with many listening to identical ranges.

Fix: Introduce the now existing bulk broadcaster that was already used for mass changes also for single cell changes to prevent repetitive broadcasts of identical ranges.

Fixed as Issue 95967 CLOSED FIXED in CWS calcperf03. Now Calc does it in 1.2s too..

Personal tools