Issue 103837 - Incompatibity with Excel importing spreadsheet in Microsoft XML format
Summary: Incompatibity with Excel importing spreadsheet in Microsoft XML format
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0-dev
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-27 15:09 UTC by gmules
Modified: 2013-12-06 11:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Microsoft spreadsheet in MS XML format (188.61 KB, text/plain)
2009-07-27 15:11 UTC, gmules 		no flags Details
Excel 2010 vs. Calc 4.1 (660.86 KB, image/jpeg)
2013-12-06 11:23 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description gmules 2009-07-27 15:09:09 UTC 
Failure to load cell with contents (Excel 2003 SP3)

     SUM(error_1)

where error_1 is named defined as

     =tmpstars.ppower_load!$L$7:$L$152

This causes a spreadsheet to break when loaded from Excel 2003 SP3 into OO Calc
3.0.1.  This happens only when the spreadsheet is loaded in Microsoft XML export
format (.XML) -- there are no problems with the same spreadsheet saved from
Excel in .XLS and then loaded into Calc.  

Thus the problem seems to be with loading Excel .XML files into OO Calc.

An actual spreadsheet is available illustrating the problem.

Glen
glenmules --at-- optonline.net
Comment 1 gmules 2009-07-27 15:11:49 UTC 
Created attachment 63799 [details]
Microsoft spreadsheet in MS XML format
Comment 2 Edwin Sharp 2013-12-06 11:23:15 UTC 
Created attachment 82049 [details]
Excel 2010 vs. Calc 4.1
Comment 3 Edwin Sharp 2013-12-06 11:24:37 UTC 
See attachment.

AOO410m1(Build:9750)  -  Rev. 1543812
Rev.1543812
Win 7