The following steps were performed: 1. Open Excel spreadsheet in Calc, works 2. Save spreadsheet in ODF format, works 3. Open ODF spreadsheet in Calc, spreadsheet is corrupted. The Excel spreadsheet has multiple tabs and within each tab sheet there are Named variables.The variable names are the same on each sheet. When Calc reads the ODF file back in it gets confused with all the variables with the same name, and renames then from "Cost" to "Cost 1", "Cost 2", etc. This causes all references to be invalid and the spreadsheet unusable.
No one can fix this without sample document. Can you upload it? It is related to all bugs.
How to Report Bugs in LibreOffice http://wiki.documentfoundation.org/BugReport
Created attachment 44607 [details] Original Excel file test. I have attached two files as follows: (1) The original Excel files test case showing the use of the same Named variables on each tab; and (2) The Excel file above loaded in into Calc and then saved as a ODS file. The original Excel file loaded in Calc looks fine, but after you save it and reloaded into Calc the Named variables get corrupted. See the red tabs in the ODS file. However, tab number 10 appears correct for some unknown reason. Hopefully this helps. If you need anything else let me know.
Created attachment 44608 [details] The resulting ODS file after loading the Excel file in Calc and saving as ODS I have attached two files as follows: (1) The original Excel files test case showing the use of the same Named variables on each tab; and (2) The Excel file above loaded in into Calc and then saved as a ODS file. The original Excel file loaded in Calc looks fine, but after you save it and reloaded into Calc the Named variables get corrupted. See the red tabs in the ODS file. However, tab number 10 appears correct for some unknown reason. Hopefully this helps. If you need anything else let me know.
He's provided requested info. Let's clear the NEEDINFO status.
3.4 will properly support sheet-local range names. With that, this will be a non-issue. I just tested it using the master build, and saving to ODS preserves all range names properly, local or global.