Description: I have an .ods file. In one cell doing a sum the sum is incorrect. When I add a sheet or hit F9 it recalculates it, but is seems not to have recalculated when the value changed. Autocalculate is on in the cell. Steps to Reproduce: 1. Open the file and notice it is 14.0, ie wrong 2. Hit F9 and it fixes itself Actual Results: sum is 14.0 Expected Results: sum is 15.5 Reproducible: Always User Profile Reset: No Additional Info: Version: 6.1.6.3 Build ID: 1:6.1.6-0ubuntu0.18.10.3 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: x11; Locale: en-US (en_US.UTF-8); Calc: group threaded
Created attachment 154559 [details] ods file with the bug bug is in cell B2
I can't repro Version: 6.3.2.2 (x64) Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded Looks like a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=100603 Please can you test with a newer version
repro with: Version: 6.4.0.0.alpha0+ (x64) Build ID: 71ef762f21ada8c25aad2183065478171e985e8c CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded for whatever reason the value "14" was saved to xml: <table:table-cell table:formula="of:=SUM([.C2:.J2])" office:value-type="float" office:value="14" calcext:value-type="float"> <text:p>14.0</text:p> </table:table-cell> please try: - Menu Data/Calculate/Recalculate hard or change: - Menu Tools/Options.../LibreOffice Calc/Formula Recalculation on File load: [Always recalculate]
(In reply to m.a.riosv from comment #2) > I can't repro > Version: 6.3.2.2 (x64) > Build ID: 98b30e735bda24bc04ab42594c85f7fd8be07b9c > CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; > Locale: es-ES (es_ES); UI-Language: en-US > Calc: threaded > > Looks like a duplicate of > https://bugs.documentfoundation.org/show_bug.cgi?id=100603 > > Please can you test with a newer version It is not a duplicate, if I hit f9 it is fixed. However, it is unreasonable to have the user double-check every single cell for recalculation, since it should be and is configured to be automatic. I have updated to Version: 6.2.7.1 Build ID: 1:6.2.7-0ubuntu0.19.04.1 CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: x11; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded and the problem persists.
(In reply to Oliver Brinzing from comment #3) > repro with: > > Version: 6.4.0.0.alpha0+ (x64) > Build ID: 71ef762f21ada8c25aad2183065478171e985e8c > CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; > Locale: de-DE (de_DE); UI-Language: en-US > Calc: threaded > > for whatever reason the value "14" was saved to xml: > > <table:table-cell table:formula="of:=SUM([.C2:.J2])" > office:value-type="float" office:value="14" calcext:value-type="float"> > <text:p>14.0</text:p> > </table:table-cell> > > please try: > > - Menu Data/Calculate/Recalculate hard > > or change: > - Menu Tools/Options.../LibreOffice Calc/Formula > Recalculation on File load: [Always recalculate] Thank you for identifying the issue. As stated in the initial post, doing a hard recalculation solves it, but you cannot expect the user to double check every single cell in a spreadsheet with recalculation. I went to Menu Tools/Options.../LibreOffice Calc/Formula/ Recalculation on File load and set excel 2007 and odf spreadsheet to prompt user. But the file is neither odf nor excel 2007, so I expected nothing to change. Indeed, nothing happens when reloading the file.
[Automated Action] NeedInfo-To-Unconfirmed
Reproduced back to Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) @Eike, what's your opinion on this one ?
@Eike, what's your opinion on this one ?
As mentioned already in comment 3, the wrong value 14 is stored in the file (for whatever reason) so it has to be recalculated once (by F9 on individual formula cells, or Shift+Ctrl+F9 for all, or entering a value in the SUM's range) and saved again. There's nothing we could do else (except recalculating even LibreOffice files during load).
(In reply to Eike Rathke from comment #9) > As mentioned already in comment 3, the wrong value 14 is stored in the file > (for whatever reason) so it has to be recalculated once (by F9 on individual > formula cells, or Shift+Ctrl+F9 for all, or entering a value in the SUM's > range) and saved again. There's nothing we could do else (except > recalculating even LibreOffice files during load). Closing the bug