Issue 115255 - OpenOffice Calc losing data when importing XLS file
Summary: OpenOffice Calc losing data when importing XLS file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.2.1
Hardware: PC Windows XP
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Rob Weir
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2010-10-26 13:35 UTC by agent_v_rush
Modified: 2013-02-13 20:21 UTC (History)
1 user (show)

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

Attachments
This file can't be opened in OpenOffice.Calc, but in Microsoft Excel it is opened without problems (4.00 KB, application/vnd.ms-excel)
2010-10-26 13:36 UTC, agent_v_rush 		no flags Details
Merged cell sample that does load correctly in AOO (22.50 KB, application/octet-stream)
2013-02-11 13:54 UTC, Rob Weir 		no flags Details
Same file opened in LibreOfficee (38.41 KB, image/png)
2013-02-13 20:21 UTC, agent_v_rush 		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 agent_v_rush 2010-10-26 13:35:02 UTC 
I have XLS-file with merged cell. This file was created by some application. 
OppenOffice.Calc hang when trying to open this XLS-file. In Microsoft Excel it's 
ok. If I re-save this file using Microsoft Excel, it is opened fine in OpenOffice. 
In previous versions (for example 3.1.1) such XLS-files were opened without 
problems.
Comment 1 agent_v_rush 2010-10-26 13:36:59 UTC 
Created attachment 72737 [details]
This file can't be opened in OpenOffice.Calc, but in Microsoft Excel it is opened without problems
Comment 2 Rob Weir 2013-02-10 00:31:10 UTC 
I am able to open this document in Apache OpenOffice 3.4.1.  No hang.  But the sheet appears to be empty.

Is this what I should be seeing?  Or is data missing now?

I need more info to continue with this report.
Comment 3 agent_v_rush 2013-02-11 09:18:19 UTC 
That file has just 4 cells filled with data:
----------------------
| Num Col | "Str Col"|
|--------------------|
|       1 |    Hello!|
|         | Test this|
----------------------

I've tried again, it is perfectly opened on Microsoft Excel 2003.
Comment 4 Rob Weir 2013-02-11 13:54:35 UTC 
Created attachment 80258 [details]
Merged cell sample that does load correctly in AOO

Example file created in MS Office 2010.  Cell A1 and A2 merge, containing string "test".  It opens correctly in AOO 3.4.1.
Comment 5 Rob Weir 2013-02-11 13:57:21 UTC 
OK.  So I can confirm that your test file does not open correctly in AOO 3.4.1.  The data is lost.   

But I also see, via the test file that I attached, that merged cells are supported via import in AOO 3.4.1.  So something is going on here more complicated than just the merged cells.
Comment 6 agent_v_rush 2013-02-13 20:21:14 UTC 
Created attachment 80275 [details]
Same file opened in LibreOfficee

This is how this file should look like. It opens like that in LibreOffice.