A well used calc spread sheet created in a version prior to 220.127.116.11 returns as display in cell the text of the formula whenever the formula has been edited, and not the value of the formula calculation. Unedited formulas still return values (until edited).
Menu:Tools→Options⇒Options(Popup)⇝LibreOff Calc⇝View:Display:Formula Box is unchecked. Toggling this has no effect, except that text of formulas are displayed for all formulas when the box is checked.
Re-entering formula even using formula wizard has no effect.
The calc sheet has multiple sheets and cross sheet references.
Same bug in 18.104.22.168 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=61316
*** Bug 61316 has been marked as a duplicate of this bug. ***
This bug does not occur in Windows version
Please see attached worksheet in https://bugs.freedesktop.org/show_bug.cgi?id=61316
Please consider increasing severity of this bug. It essentially makes Linux version unusabe.
Created attachment 76564 [details]
WinXP.LO4.Calc not Calculating
This is a screenshot of this bug also happening on Windows XP with LO 22.214.171.124.
*** Bug 63174 has been marked as a duplicate of this bug. ***
*** Bug 63176 has been marked as a duplicate of this bug. ***
This seems to be an aspect of the "Not all user settings imported" problems with 3.6 -> 4.0 updates?
This bug has been resolved (no longer occurs) in the latest version.
So WFM for now
Please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information
*** Bug 65390 has been marked as a duplicate of this bug. ***