Issue 115255

Summary:

OpenOffice Calc losing data when importing XLS file

Product:

Calc

Reporter:

agent_v_rush <agent_v_rush>

Component:

open-import

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Rob Weir <robweir>

Severity:

Major

Priority:

CC:

issues

Version:

OOo 3.2.1

Keywords:

needmoreinfo

Target Milestone:

---

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

3.4.1

Developer Difficulty:

---

Attachments:

Description	Flags
This file can't be opened in OpenOffice.Calc, but in Microsoft Excel it is opened without problems	none
Merged cell sample that does load correctly in AOO	none
Same file opened in LibreOfficee	none

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.