Created attachment 119176 [details] Spreadsheet exhibiting problems on Mac OS X 10.11 This is for LibreOffice Calc 5.0.2 running Mac OS X 10.11.0. I created a column with non contiguous data to represent software upgrade prices at variable lengths of months. I created several other columns that would either sum or average the non contiguous data column. After creation, every thing auto calculated as I would expect. I then grabbed and moved a number in the non contiguous column down one column. The calculation columns did not automatically refresh their results. I hit F9, still no refresh. I choose the menu item Tools:Cell Contents:Recalculate, still no refresh. I deleted the data and it did not refresh either automatically or with F9. Re-entering data seemed to be the only way to refresh the formulae. I copied the entire range after the refusing to refresh calculations problem began, and the pasted range further down the sheet. It did not refresh the formulae. Hit F9, still no refresh. Delete and reenter refreshed one column (running total achieved with a SUM(B$11:B19) formula. Initial formula was SUM(b$11:b11) and then filled down to end of range. The running average column did not automatically refresh, refresh or update with F9, or refresh upon a save, close and reopen. Not trusting that a spreadsheet program will refresh results makes it worthless. I am attaching the spreadsheet. The first range contains some updated results from the re-entry of data. The second range was a result of the copy and paste and move the data fiasco. I will test the spreadsheet on my Windows 10 and Linux installs when I return home.
Automatic update of cell values works for me in Version: 5.0.2.2 Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale : fr-FR (fr.UTF-8) on OSX 10.10.5 (I haven't upgraded to 10.11 yet), so this could be a regression with regard to the OS
No repro on OSX 10.11 either, if I change a value in one of the referenced fields, the calculated field values get updated automatically.
Not too much clear for me the steps, but I can't reproduce the issue. Win10x64 Version: 5.0.3.1 (x64) Build ID: fd8cfc22f7f58033351fcb8a83b92acbadb0749e If the issue persist, please verify that keeps happening with the option: Menu/Tools/Options/LibreOffice/OpenCL disable.
Given that two experienced QA members have not reproduced the issue and the reporter said he would test on other machines but has not (in almost a month). I am closing this as WFM. @bacon - please try with a fresh profile to start with: https://wiki.documentfoundation.org/UserProfile If you're still seeing the issue punt this back to UNCONFIRMED and we'll try to work through it. Thanks