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
Thanks for the report Could you please attach the simple spreadsheet demonstrating the autocalculate failing. Issues with autocalculate not working are circulating, but lacking concrete reproducible examples
(In reply to Telesto from comment #1) > Thanks for the report > > Could you please attach the simple spreadsheet demonstrating the > autocalculate failing. Issues with autocalculate not working are > circulating, but lacking concrete reproducible examples Setting to NEEDINFO
Created attachment 180189 [details] simple spreadsheet
Spreadsheet attached
Is anyone looking at this?
I'm not seeing any issue. Which cell should I modify and with what value? Data -> Calculate -> AutoCalculate is turned on? More in general a user profile reset might help https://www.youtube.com/watch?v=SNndGNwR3So Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: c1c8ce3b0f1037bca4d500af2f39363cd9d38db6 CPU threads: 8; OS: Mac OS X 12.3.1; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
(In reply to Telesto from comment #6) > I'm not seeing any issue. Which cell should I modify and with what value? > > Data -> Calculate -> AutoCalculate is turned on? > > More in general a user profile reset might help > https://www.youtube.com/watch?v=SNndGNwR3So venushka: we are waiting for your reply. Set to NEEDINFO. Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
I honestly don't know how to answer this. As I stated in my original post, the auto recalculate does not always work. "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." Maybe it was already fixed in an update?
(In reply to venushka@protonmail.com from comment #8) > I honestly don't know how to answer this. As I stated in my original post, > the auto recalculate does not always work. > > "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." > > Maybe it was already fixed in an update? Ok, let's try again. Do you still reproduce the problem with attachment 180189 [details] using version 7.4? If yes, tell us which cell you modified and which exact column it is that refuses to update.
It works at this time
[Automated Action] NeedInfo-To-Unconfirmed