https://bugs.documentfoundation.org/show_bug.cgi?id=159687
Bug ID: 159687
Summary: Cutting rows from specific file with whole column
references in formula is slow
Product: LibreOffice
Version: 5.1.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Keywords: perf
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 108253
Created attachment 192513
--> https://bugs.documentfoundation.org/attachment.cgi?id=192513&action=edit
Example file from Calc
Attached file contains lots of formula referencing whole columns, such as
=SUMPRODUCT(($F:$F=$M2)*($I:$I=N$1))
When a row is deleted, the recalculating takes a long time and Calc becomes
irresponsible for about 40 seconds on my Windows virtual machine.
0. To make this more visible, disable Options - Calc - Calculate - Enable
multi-threaded calculation, restart LO
1. Open attached file
2. On the FEHLER tab right click on any row header, choose Delete row
-> Calc recalculates for a long time
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: aa6d11771d085803cdb811579f47debc30c4d94b
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default
This seems to have started with
https://git.libreoffice.org/core/+/0c8778ce1df92ca3bc2a8dd2f64568fb257e9e39
author Eike Rathke <[email protected]> Fri Jun 26 15:12:46 2015 +0200
committer Eike Rathke <[email protected]> Fri Jun 26 15:19:52 2015 +0200
tdf#44419 allow A:A and 1:1 references also in Calc A1 and ODF syntax
so it's not a real regression, just a downside of a new feature.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
