[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

--- Comment #2 from dumblob at gmail.com ---
(In reply to Xavier Van Wijmeersch from comment #1)
> first i have a 522 error

Not sure what 522 you're talking about as I don't get anything like that (fully
updated Arch Linux, LibreOffice still 5.2.6.2). Is this new in 5.3.4?

>and than the ref error
> for me its a normal behavior to tel the user something went wrong
> test it with 5.3.4 daily build 2017_05_15 old laptop Dell D620
> slackware current X86

I might have not been clear. The issue is about cell content (which is the
content which gets saved in the .ODS file), but not about visual representation
of the cell. I totally agree, that the cell should show e.g. #REF! instead of
the result of the cell content expression. But it definitely must not under any
circumstances save any other value than the user wrote there!

I lost so much work (i.e. my time) just with this. And believe me, correcting
ultra long expressions full of references, where copying or importing or just
mistyping and pressing Enter completely discards any information which should
have stayed at the place of mistakes is an utterly enraging situation.

-- 
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/20170517/588c0053/attachment.html>