[Libreoffice-bugs] [Bug 130698] enhancement request: better handling of outdated cached values | notabug: file was saved with outdated values | was: sum error when opening an xlsx in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |DUPLICATE
            Version|6.0.7.3 release             |4.1.6.2 release
            Summary|sum error when opening an   |enhancement request: better
                   |xlsx in Calc                |handling of outdated cached
                   |                            |values | notabug: file was
                   |                            |saved with outdated values
                   |                            || was: sum error when
                   |                            |opening an xlsx in Calc
                 CC|                            |newbie-02 at gmx.de

--- Comment #7 from b. <newbie-02 at gmx.de> ---
i think in the history of the table data was added or updated while
'autocalculate' was off, the following work to identify the the error (row
31++) did not trigger a recalculation of row 30 ... 

funnily hard recalc can't heal the deviation in cols V:Y ... the formulas in
row 30 start from row 6 instead of row 5, 

> checked in MS Excel, does not have same problem

probably recalculate on load active in excel? 

> integrity test when one opens a spreadsheet which was not created by Calc

won't be save, same problem can easily be constructed in calc, 

> version: checked back until 4.1.6.2, 

automatic 'recalc' always stays in the balancing act trying to avoid errors
(with) or delays (without), 

thus: 

enhancement request to inform users when dealing with outdated cached values
...

*** This bug has been marked as a duplicate of bug 130118 ***

-- 
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/b5edc052/attachment.htm>