https://bugs.freedesktop.org/show_bug.cgi?id=74512
Priority: high
Bug ID: 74512
CC: [email protected]
Assignee: [email protected]
Summary: Formula error if apostrophe in a sheet name
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.2.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 93370
--> https://bugs.freedesktop.org/attachment.cgi?id=93370&action=edit
BugQuote.ods (sheet name with an apostrophe)
Hello
Formula error if apostrophe in a sheet name
Reproduced on :
- windows 7/64, XP with 4.2.0.4
- Ubuntu 12.04 (QA-fr) 4.2.0.4 Build ID:
05dceb5d363845f2cf968344d7adab8dcfb2ba71
Steps to reproduce
1. File> New> Spreadsheet
2. Insert> Sheet> Name: give a name with apostrophe
("test d'apostrophe" in the attached example)
3. In Sheet1.A1 type the formula:
='test d''apostrophe'.A1
Note: need to "double" the apostrophe. In the line above you must type 2 ' and
not 1 " between "d" and "a"
Expected result: the 2 ' must be kept
Actual result : one is kept
='test d'apostrophe'.A1
Consequently, the formula no longer work at the next change (replace A1 by B1
for example), or simply when reloading the document
4. Save, close, reopen the spreadsheet: the formula no longer recognizes the
sheet name and displays #NAME ?
Note: the bug is the same if you do not type the formula but if you use the
mouse to go search the cell.
5. In Sheet1.B1 type =
6. With the mouse click on the "test d'apostrophe" tab, click on A1
in this sheet and then press Enter.
Return on Sheet1 the formula is:
='test d'apostrophe'.A1
Expected result ( as in previous versions ):
='test d''apostrophe'.A1
I set the status to "new" because the bug has been reproduced
Also reproduce with Version: 4.2.0.3
Build ID: c63c03decdf780d8fb80823950665b782ec9ecd0
Was OK with 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72
Markus, I add you to CC list because it could be related to bug 71549 ?
Regards
Pierre-Yves
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
