Red Hat Bugzilla – Bug 991704
Libreoffice Calc isn't recalculating values after version upgrade
Last modified: 2015-02-17 11:33:12 EST
Created attachment 782391 [details]
Sample spreadsheet with calculation error
Description of problem:
The attached spreadsheet has calculation errors in it.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Open the attached spreadsheet.
2. Reply "No" to the question about updating links to other files.
3. Look at cell B418 on the page labelled "bills".
The cell shows 2,7 (in my locale, anyway)
The cell should show 2,0 (the difference between the cells above it). The only way I've discovered to make this cell get recalculated it to update it without actually changing it. That is, press F2, delete the "7" at the end of the formula, type "7" and press enter.
This spreadsheet was previously updated (last month) using LibreOffice Calc 3.6 in Fedora 18.
(In reply to Fred New from comment #0)
> only way I've discovered to make this cell get recalculated it to update it
> without actually changing it. That is, press F2, delete the "7" at the end
> of the formula, type "7" and press enter.
Shift+Ctrl+F9 does a hard recalc of the entire document.
> Additional info:
> This spreadsheet was previously updated (last month) using LibreOffice Calc
> 3.6 in Fedora 18.
Unfortunately you attached a version of the file that was saved using 188.8.131.52 where the wrong value 2.7 is already stored in the file. Loading it displays the cached value instead of recalculating, unless you disabled that under Tools->Options->Calc->Formula "Recalculation on file load". The primary question is, how was the value 2.7 originally calculated so that it ended up in the document?
The file is a copy of one created last month which was a copy of the one created the month before, etc. (all the way back to when it was an Excel 97 worksheet). I changed some data on the "work" sheet and expected the formulas to get recalculated on the "bills" sheet, like it usually does. Does that answer your question? I could upload last month's copy if that would assist in any way.
Thanks for Ctrl+Shift+F9 - I looking for that. All I could find was Tools->Cell Contents->Recalculate F9. (I tried using F1 for help, but was hampered by the fact that LibreOffice now doesn't like to display all text, like toolbar menu text, row numbers, column letters, and text on the left (index) side of the help window. Text display momentarily if I run my mouse over it, but this is an entirely different bug that I'm building up the courage to report.)
If I'm just supposed to know about Ctrl+Shift+9, then I guess we could close this bug. But I'm curious about why everything didn't update as usual.
I ran across this bug again..
(In reply to Fred New from comment #2)
> The file is a copy of one created last month which was a copy of the one
> created the month before, etc. (all the way back to when it was an Excel 97
Do you happen to have a copy of that file saved before you used LibreOffice 184.108.40.206, together with the referred external document and instructions how you updated the document?
Created attachment 885075 [details]
Created attachment 885076 [details]
This file gives the ku2013-xx.ods spreadsheets something to read data from, even if it doesn't match the values it would have had that month.
This message is a notice that Fedora 19 is now at end of life. Fedora
has stopped maintaining and issuing updates for Fedora 19. It is
Fedora's policy to close all bug reports from releases that are no
longer maintained. Approximately 4 (four) weeks from now this bug will
be closed as EOL if it remains open with a Fedora 'version' of '19'.
Package Maintainer: If you wish for this bug to remain open because you
plan to fix it in a currently maintained version, simply change the 'version'
to a later Fedora version.
Thank you for reporting this issue and we are sorry that we were not
able to fix it before Fedora 19 is end of life. If you would still like
to see this bug fixed and are able to reproduce it against a later version
of Fedora, you are encouraged change the 'version' to a later Fedora
version prior this bug is closed as described in the policy above.
Although we aim to fix as many bugs as possible during every release's
lifetime, sometimes those efforts are overtaken by events. Often a
more recent Fedora release includes newer upstream software that fixes
bugs or makes them obsolete.
Fedora 19 changed to end-of-life (EOL) status on 2015-01-06. Fedora 19 is
no longer maintained, which means that it will not receive any further
security or bug fix updates. As a result we are closing this bug.
If you can reproduce this bug against a currently maintained version of
Fedora please feel free to reopen this bug against that version. If you
are unable to reopen this bug, please file a new report against the
current release. If you experience problems, please add a comment to this
Thank you for reporting this bug and we are sorry it could not be fixed.