[Libreoffice-bugs] [Bug 107850] New: 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

            Bug ID: 107850
           Summary: editing, fileopen, filesave; A wrong sheet reference
                    breaks the cell content
           Product: LibreOffice
           Version: 5.2.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dumblob at gmail.com

1. Create a new Calc document.
2. Write into cell A1: "Sheet1.A5 + Sheet1.$A$6".
3. Write into A5: "2".
4. Write into A6: "3".
5. Save document as "test00.ods".
6. Close all running LO instances and open Calc and then the file "test00.ods".
7. Change content of cell A1 to: "Sheet1X.A5 + Sheet1.$A$6" and press Enter.
#REF! appears instead of the number "5".
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).
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).

Few months ago I was working with a simple .ods spreadsheet referencing other
sheets from the same document and after writing one reference incorrectly
(similar to above), it changed itself to a weird reference to a file (but this
reference was incorrect and not functional). Back then I didn't have time to
report bugs in this Bugzilla and right now I can't reliably reproduce it, so
I'm just mentioning it for the person who'll dive into the referencing code to
check if there is not any visible bug with sheet references changing to file
references.

-- 
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/20170514/79064dc5/attachment.html>