The Zaske Case
From Apache OpenOffice Wiki
< Calc | Performance
Comparison with Excel 2003/2007 that need 1.2s where Calc needs 24s after changing a cell's value.
References:
- Zaske's blog entry
- The test case file (.zip)
- Video on YouTube (same as on the blog)
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..