Bug 35238 - Excel import Calc Save ODF Calc Read Failure
Summary: Excel import Calc Save ODF Calc Read Failure
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.1 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Kohei Yoshida
URL:
Whiteboard: target:3.4
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-11 18:47 UTC by david.baxendale
Modified: 2011-03-21 18:18 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Original Excel file test. (15.50 KB, application/vnd.ms-excel)
2011-03-18 22:47 UTC, david.baxendale
Details
The resulting ODS file after loading the Excel file in Calc and saving as ODS (11.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-03-18 22:48 UTC, david.baxendale
Details

Note You need to log in before you can comment on or make changes to this bug.
Description david.baxendale 2011-03-11 18:47:55 UTC
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.
Comment 1 tester8 2011-03-12 02:30:49 UTC
No one can fix this without sample document. Can you upload it? It is related to all bugs.
Comment 2 tester8 2011-03-12 02:33:41 UTC
How to Report Bugs in LibreOffice
http://wiki.documentfoundation.org/BugReport
Comment 3 david.baxendale 2011-03-18 22:47:36 UTC
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.
Comment 4 david.baxendale 2011-03-18 22:48:36 UTC
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.
Comment 5 Kohei Yoshida 2011-03-21 18:16:40 UTC
He's provided requested info.  Let's clear the NEEDINFO status.
Comment 6 Kohei Yoshida 2011-03-21 18:18:10 UTC
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.