[Libreoffice-bugs] [Bug 136465] Cell contains incorrect value from formula

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136465

Alan Jones <ajones2001 at googlemail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
     Ever confirmed|0                           |1
         Resolution|WORKSFORME                  |---

--- Comment #31 from Alan Jones <ajones2001 at googlemail.com> ---
Hi, I disagree that pressing F9 or Control Shift F9 do not result in
modification.  These recalculations cause all of the dependencies to update. 
How can a user have any faith in a product if what is on the display when they
close the file is not saved.  

As for the talk of autocalculate on/off.  It is and always has been on. 

So lets recap, in order to see the correct values in a spreadsheet and save the
values that I see.

I have to load the file, press F9 on cells which I think might be displaying
the wrong values (or press control shift F9), add something to a random cell
(which has nothing to do with the main calculations in the spreadsheet) remove
whatever I added and then save the file. 

Alternatively I can turn autocalculate off press control shift F9 turn
autocalculate back on and close the file.

This defense of the undesirable/unexpected/misleading and potentially very
costly behaviour is not conducive to a good product.  I don't believe that we
have even figured out how the inconsistency was introduced in the first place,
which makes this even more significant a finding.

I have just opened this file in StarOffice 8 (as a really old benchmark), the
correct values are always displayed.  Somewhere along the road, LibreOffice has
introduced this undesirable effect.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200906/ca485fcf/attachment-0001.htm>