[Libreoffice-bugs] [Bug 130118] enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: error in calculating sums

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement
                 CC|                            |newbie-02 at gmx.de
            Summary|error in calculating sums   |enhancement request: better
                   |                            |handling of outdated cached
                   |                            |values | notabug: file was
                   |                            |saved with outdated values
                   |                            || was: error in calculating
                   |                            |sums
            Version|6.3.3.2 release             |4.1.6.2 release

--- Comment #11 from b. <newbie-02 at gmx.de> ---
> c#3: Bug also affects cells: I13, I14 in file 'Tabella retribuzione.ods'
also affected: D8, D13, D14 and indirect I9:I12 and second level indirect some
more, (a small carelessness not to inform the user about outdated values leads
to an avalanche of hard to spot subsequent errors)

> c#8: I don't understand why cell N8 isn't calculated correctly on opening the file.
N8 is ok, I8 is 'off', 

> affected versions: 
checked back to 4.1.6.2, identical behaviour, , 

quite sure C8, C13 and C14 have been changed with autocalculate off, C15 and
cols J:N added or individually recalculated lateron, thus 'notabug', changing
headline, 

leaving as enhancement request to: 

- flag 'save this' active after changes by manual hard recalc, 

(@Eike in c#10: 'We probably should do that at least after a manual hard
recalc.') 

- find a way to warn user when dealing with outdated cached values

-- 
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/20200509/43205fec/attachment.htm>