Difference between revisions of "Calc/Performance/The Zaske case"
From Apache OpenOffice Wiki
< Calc | Performance
(The Zaske Case) |
|||
(One intermediate revision by one other user not shown) | |||
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..