https://bugs.freedesktop.org/show_bug.cgi?id=88436
Bug ID: 88436
Summary: CALC: R1C1 formula broken by worksheets names starting
with number
Product: LibreOffice
Version: 4.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 112263
--> https://bugs.freedesktop.org/attachment.cgi?id=112263&action=edit
Files
LO Calc version: 4.3.5.2
Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5
Problem can be easily reproduced:
1. open the spreadsheet named BugRepro.ods on attachment.
2. see cells on "Sheet1", they are very simple having only numbers - see
LO_01-Sheet1.jpg
3. create a new sheet named "2015" referring to cells on "Sheet1" -
LO_02-2015-1.jpg and LO_02-2015-2.jpg
4. chance formula syntax from standard "Calc A1" to "Excel R1C1" -
LO_03-formula-config.jpg
5. force a change (sum zero) on "2015" cells to see no problem -
LO_04-change-1.jpg and LO_04-change-2.jpg
6. now, rename "Sheet1" to "2014" - LO_05-rename.jpg
7. force a new change (sum zero again) on "2015" cells. Only second cell is
broken - LO_06-partial-bug-1.jpg and LO_06-partial-bug-2.jpg
8. curiously, problem is fixed on second cell changing the order on sum. It
appears we have parsing problems on formulas with parenthesis close to
worksheet names started by numbers - LO_06-partial-bug-3.jpg
9. but we want to really break it, so please reload the file without saving -
LO_07-reload.jpg
10. now, rename "Sheet1" to "1Sheet" - LO_08-rename.jpg
11. cells on "2015" are now seen as LO_09-2015-1.jpg and LO_09-2015-2.jpg
12. force a new change (summing zero) on first cell and this time result is
also broken. Hit "No" on warning - LO_10-bug-1.jpg and LO_10-bug-2.jpg
13. changing order is useless this time - LO_10-bug-3.jpg
14. hit "Undo" to revert last change and try a workaround: place apostrophes on
worksheet name reference inside formula - LO_10-bug-4.jpg
15. formula is now working for a short while. Note apostrophes are gone again
after parser interpretation - LO_10-bug-5.jpg
16. unfortunately, a new change (summing zero) breaks it again -
LO_10-bug-6.jpg
None of those problems were seen on A1 notation.
Fell free to ask more information, if needed.
Walfred
--
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
