https://bugs.freedesktop.org/show_bug.cgi?id=70644
Priority: medium
Bug ID: 70644
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Other: Formula gets lowercased and invalidates
non-existing sheet name
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: ad...@lukas-prokop.at
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 87851
--> https://bugs.freedesktop.org/attachment.cgi?id=87851&action=edit
Lowercased sheet name in reference
Problem description:
Based on the following description:
https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document
(Section: To Reference a Cell in the Same Document)
If another sheet is referenced in a formula and this sheet does not exist
yet, the sheet name gets lowercased. This invalidates references to resources
that will be attached later on. This is IMHO an unexpected, annoying behavior.
Steps to reproduce:
1. Open a new, empty spreadsheet.
2. enter the following formula in cell A1 of Sheet1: "=Sheet2.A1"
3. *Create a new sheet "Sheet 2"*. Set the cursor in cell A1 there and enter
text or a number.
4. If you switch back to Sheet1, you will *not* see the same content in cell A1
there, but a "#NAME?" referencing error. This is due to the formula which got
lowercased to "=sheet2.a1". Where "a1" is a valid reference to "A1", "sheet2"
is not a valid reference to "Sheet2".
5. If you change the formula to "=Sheet2.a1", the reference will work again.
Current behavior:
Reference error due to lowercase operation.
Expected behavior:
Working reference once the referenced sheet gets introduced.
Possible/proposed solutions:
* Do not apply lowercase operation.
* "Sheet2" equates technically to "sheet2".
* Or at least adjust the documentation that the sheet has to exist beforehand
and sheet names should only consist of lowercase letters.
Operating System: Linux (Other)
Version: 4.0.2.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
