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@lists.freedesktop.org
Reporter: dumb...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
