https://bugs.documentfoundation.org/show_bug.cgi?id=149009
Bug ID: 149009
Summary: autocalculate does not always work
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:
I created a super simple spreadsheet; 2 columns with sum formulas after the
first 3 rows, then, in both columns, a sum formula dependent on the first sum
formula the sum formulas in the second column will only recalculate when forced
= F9.
After noticing the issue, I saved and exited LibreOffice hoping it was a
temporary glitch that might be cleared. Upon re-opening the spreadsheet
autocalc seemed to work until I created a few more columns with sum formulas,
the new sum formulas and even some of the original sum formulas required forced
recalculation.
Steps to Reproduce:
1.enter number in cell
2.expect auto calculate to calculate new total
3.no new total
Actual Results:
I created a super simple spreadsheet; 2 columns with sum formulas after the
first 3 rows, then, in both columns, a sum formula dependent on the first sum
formula The sum formulas in the second column will only recalculate when forced
= F9, however, the sum formulas in the first column seem to recalculate
automatically.
After noticing the issue, I saved and exited LibreOffice hoping it was a
temporary glitch that might be cleared. Upon re-opening the spreadsheet
autocalc seemed to work until I created a few more columns with sum formulas,
the new sum formulas and even some of the original sum formulas required forced
recalculation.
Expected Results:
a new total
Reproducible: Sometimes
User Profile Reset: No
Additional Info:
Software should recalculate totals
I'm not a software engineer/programmer, just an end user trying to get a fix.
If a spreadsheet cannot recalculate on it's own, it's nearly useless. Who knows
what kind of problems this would create for an accountant or engineer.
Thankfully, I was working on a simple spreadsheet and could see the error right
away.
Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
