https://bugs.documentfoundation.org/show_bug.cgi?id=105024
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|[email protected] |[email protected]
|desktop.org |
Whiteboard| |odf
--- Comment #4 from Eike Rathke <[email protected]> ---
Importing the cell as formula cell is expected behavior. Calc does not have
distinct error cells, so to preserve the error information the error value is
stored as a formula. What goes wrong here is that the detailed Err:502 value
(and others) are not recognized as an error formula, contrary to defined errors
like #DIV/0! or #VALUE! In fact it should not be stored as Err:502 that does
not comply with the ODFF specification, but transformed to a value according to
the syntax definition in "5.12 Constant Errors" at
https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#Constant_Errors
and remapped during import.
Actually the identified commit for the first time preserves the paste special
resulting error formulas when loading a document, see also its commit message,
previously such error formulas were imported as string cells and thus lost
their error property, so formulas like ISERROR(A1) ceased to produce a correct
result if A1 contained a "special pasted" error value and the document was
saved and reloaded.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
