Issue 82312 - Excel 2003 XML export can lose formatting
Summary: Excel 2003 XML export can lose formatting
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-10-05 15:19 UTC by tom_seddon
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

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

Attachments
Spreadsheet that demonstrates the problem. (7.64 KB, application/octet-stream)
2007-10-08 10:35 UTC, tom_seddon 		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 tom_seddon 2007-10-05 15:21:03 UTC 
When exporting files in Excel XML format, formatting can be lost. To see this:

1. Download http://www.tomseddon.plus.com/files/xmlexportbug.ods .

2. Load the file you downloaded into Openoffice 2.3.

3. File, Save As, select "Microsoft Excel 2003 XML" format, type in a filename,
press Return.

4. Wait for it to save.

5. Quit OpenOffice.

6. Start OpenOffice.

7. Load the Excel XML file you just saved.

Note that the formatting is not the same as it was, as a number of non-empty
cells have lost their background colour. (And the empty cells too, which is not
ideal, but I assume that is by design.)
Comment 1 tom_seddon 2007-10-08 10:35:32 UTC 
Created attachment 48750 [details]
Spreadsheet that demonstrates the problem.
Comment 2 frank 2007-10-08 15:22:53 UTC 
Hi Swante,

a double to Issue 68011 ? If so, we have to set this one as double and reopen 68011.

Please have a look and proceed as needed.

Frank
Comment 3 tom_seddon 2007-10-09 10:27:10 UTC 
It may be related to bug 68011 as having added more worksheets to the
spreadsheet I now have a number of coloured columns, despite not having added
any extra colour, and in particular never (I'm pretty sure) having added any
colour to a column.

The colour is still vanishing from certain non-empty cells. (There's no
discernible pattern but it looks to be broadly the same set of cells as was the
case before.)
Comment 4 svante.schubert 2008-05-30 14:56:48 UTC 
I am sorry, I am no longer working on this format.
Changed target to Office later.
Is anybody able to take this over? And/or provide a patch for this problem?

Thanks in advance,
Svante