| Summary: | CALC: R1C1 formula broken by worksheets names started by number | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Walfred <walfred> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | qubit |
| Version: | 4.3.5.2 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | Files | ||
step 3 says "create a new sheet" - no need to create, it's already created. So, just check it out. Comment on attachment 112263 [details]
Files
fix mimetype
TESTING with LO 4.4.0.2 + Ubuntu 14.04 (In reply to Walfred from comment #0) > 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. Open sheet named "2015" (note that it refers 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 CONFIRMED > 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 CONFIRMED Okay, I've seen enough to confirm this as a bug: Status -> NEW (Devs can decide whether all of these issues are related, or if there are multiple bugs here) OS -> All |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 112263 [details] 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