https://bugs.documentfoundation.org/show_bug.cgi?id=147298
Bug ID: 147298
Summary: Auto Calculate does not work on newly inserted columns
in ods or xls formats
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Create a new spreadsheet. ods or xls. Insert some numbers in a couple of rows
of say column B. Use sum function to add those numbers up. Do same in Column C.
Sums are correct. Now insert a new column between B and C. Again put some
numbers in a couple rows. Sum those numbers. Now change any of the numbers in
new column. Sum does not auto calculate. ctrl-shift-f9 will force sum to be
correct.
Steps to Reproduce:
1. Create new spreadsheet or use any existing spreadsheet. ods or xls
2. Put some numbers in Columns B and C.
3. Use Sum function to total the numbers =sum(B3:B5) =sum(C3:C5)
4. Insert new column between B and C.
5. Put some numbers in rows 3, 4, 5.
6. Sum up those numbers =sum(c3:c5) in col C row 6.
7. Change any of the values in col C row 3, 4 or 5.
8. Sum does not change. F9 calculate or ctrl-shift-f9 will correct number but
must be done each time a value changes in newly inserted column.
Actual Results:
adding up 2+3+4 = 9 but then changing say 2 to 5
will result in 5+3+4 = 9 NOT the 12 as expected
Verified AutoCalculate is turned on under Data..Calculate options.
Expected Results:
Produce the correct sum of the rows in the column of numbers.
Saving and opening spreadsheet seems to correct problem with that inserted
column.
But then newly inserted columns will again have same problem.
Reproducible: Always
User Profile Reset: No
Additional Info:
Windows 11 with all latest patches installed. Intel core i5, 8GB ram, Lenovo
T580
Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
I did a complete uninstall of LibreOffice, then did a full clean reinstall.
Same issue happens every time.
--
You are receiving this mail because:
You are the assignee for the bug.
