[Libreoffice-bugs] [Bug 132986] Redefined #REF! values recovers the last value and fórmula, however it's never updated anymore EDITING the referenced cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86 (IA32)                  |All
                 OS|Windows (All)               |All
            Version|7.0.0.0.alpha1+             |4.2 all versions

--- Comment #5 from b. <newbie-02 at gmx.de> ---
affects linux too, 

up to ver. 4.1.6.2 different behaviour, #REF error kept after re-insert of row, 

next tested ver. is 5.0.0.1 - buggy as of now, re-insert: decoupled from
autocalculate, 

all ver: undo: correct behaviour, 

assume break between 4.1 and 4.2 - implementation of shared formulae ... 

hard recalc <ctrl-shift-F9> is a tool to check for fails of the program, not! a
functionality for daily use, if your car won't start, sometimes a hammer tap on
the starter helps, that's somehow a 'fix', but you are warned that theere is a
problem by the fact that it doesn't move as expected, spreadsheets are
different, if you have miscalculations you firstly need to realize that this is
the case! ... sometimes you are lucky and see it, in all other cases i
recommend a recalculation with pencil and paper ... thus either you see a
mistake, or you calculate with pencil and paper ... or you routinely press
ctrl-shift-F9 and forget that in the critical moment of the most important
sheet of your life ... this is kind of like playing the lottery, please stop
recommending such things as fixes ...

-- 
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/20200613/1a9b29c1/attachment.htm>