https://bugs.documentfoundation.org/show_bug.cgi?id=107850
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|bibisectRequest, dataLoss, |
|regression |
Status|NEW |RESOLVED
Resolution|--- |NOTABUG
--- Comment #5 from Eike Rathke <[email protected]> ---
(In reply to dumblob from comment #0)
> 7. Change content of cell A1 to: "Sheet1X.A5 + Sheet1.$A$6" and press Enter.
> #REF! appears instead of the number "5".
It has to because a sheet named Sheet1X does not exist.
> 8. Click on the cell A1 and look at the content - "Sheet1X.A5" changed to
> "#REF!.A5". This is the first bug (the correct behavior would be to leave
> the cell content as it was).
That's debatable. If the reference string was left as it was entered wrongly,
in a longer formula expression you wouldn't even see which part of the
expression was wrong.
> 9. Save the document (again to "test00.ods").
> 10. Close all running LO instances and open Calc and then the file
> "test00.ods".
> 11. Click on the cell A1 and look at the content - "#REF!.A5" changed to
> "#REF!". This is the second bug (the correct behavior would be to leave the
> cell content as it was).
It has to be #REF! because the ODF OpenFormula specification specifies that an
invalid reference is to be written as #REF!. Earlier versions wrote the more
detailed but wrong #REF!.A5 string, that has been fixed which seems to be
viewed as regression. It is not.
--
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
