[Libreoffice-bugs] [Bug 107850] editing, fileopen, filesave; A wrong sheet reference breaks the cell content

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|bibisectRequest, dataLoss,  |
                   |regression                  |
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
(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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170614/61623bda/attachment.html>