https://bugs.documentfoundation.org/show_bug.cgi?id=155881
Bug ID: 155881
Summary: Saving causes consolidate dialog to fill up with
garbage ranges
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I keep my personal finances in LibreOffice Calc file. I have two sheets: 2022
and 2023. When I want to group by categories and costs per row by using
Consolidate, everything works as expected. As soon as I save the file, close it
and then open it again, the Consolidate dialog has got 4 more ranges pointing
to $'2022'.$A$1. As I continue to save and close the file, this dialog gets
filled up with bunch of these ranges and after a while the saving of the file
will take probably 10 seconds. If I try to open the dialog then, it takes
probably a minute to open. Deleting these ranges also takes couple of minutes
while the Calc is not responding at all.
I can provide example file with similar data which I've used to reproduce the
problem.
Thanks for your help!
Steps to Reproduce:
1. Create a file with 5 columns: Date, Text, Text, Text and Currency input
2. Fill the rows with data
3. Create another sheet with the same set of columns and fill some rows with
data
4. Open Consolidate dialog and add a range. Under options check Row labels
5. After saving the file and closing it, open it again
6. Consolidate dialog now has duplicate ranges which haven't been entered by
the user
7. Save, close and open the file couple of more times. Consolidate dialog
should have even more duplicated ranges
Actual Results:
Consolidate dialog has more and more ranges which haven't been entered by user.
After a while, Calc starts to work slowly - saving and consolidating data takes
too long.
Expected Results:
Consolidate dialog should contain only ranges added by the user.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.2.2 (x64) / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: hr-HR (hr_HR); UI: en-GB
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
