Difference between revisions of "Calc/Performance/The Zaske case"
From Apache OpenOffice Wiki
< Calc | Performance
m (Calc/Performance/Zaske moved to Calc/Performance/The Zaske case: visualize in DPLs that it is _the_ Zaske case) |
|||
Line 15: | Line 15: | ||
identical ranges. | identical ranges. | ||
− | Fixed as | + | Fixed as <S>{{Bug|95967}}</s> CLOSED FIXED in |
[http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalcperf03 CWS calcperf03]. | [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalcperf03 CWS calcperf03]. | ||
Now Calc does it in 1.2s too.. | Now Calc does it in 1.2s too.. |
Latest revision as of 11:07, 10 September 2022
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..