https://bugs.documentfoundation.org/show_bug.cgi?id=130698
b. <newbie...@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...@gmx.de
--- Comment #7 from b. <newbie...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs