Bug 80400

Summary:	FILEOPEN: LO do not respect formatting of empty cells while importing from Excel 2003 XML
Product:	LibreOffice	Reporter:	Daniil Bubnov <garcia>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	dennisroczek
Version:	4.2.4.2 release
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	Sample XML that shows formatting lost in LO 4.2.4.2

Description Daniil Bubnov 2014-06-23 13:31:19 UTC

Description:

When importing Excel 2003 XML, LO Calc drops styling for cells after (to the right of) last cell, containing data in row. 
As i remember, it was so since OpenOffice 2.x.
It seems all fine with columns.

Reproduce:

Start Excel, enter any value for A1, set background color in cell format for [A1:C1], save to Excel 2003 XML. Open it with LO Calc. Only A1 will be colored, other cells will not. If you open it in Excel, colors will be in it's place.

Comment 1 Dennis Roczek 2014-06-23 14:44:28 UTC

I cannot confirm this behavior with LibO 4.2.0.2 Win8.1 64-bit German-GUI (yes outdated) and Excel 2013

Comment 2 ign_christian 2014-06-24 02:35:13 UTC

Hi Daniil, could you please attach sample file ?

Comment 3 Daniil Bubnov 2014-06-24 11:52:14 UTC

Created attachment 101667 [details]
Sample XML that shows formatting lost in LO 4.2.4.2

Formatting of A2:A3 lost in LO 4.2.4.2. In Excel 2003 all fine

Comment 4 Daniil Bubnov 2014-06-24 11:53:17 UTC

I mean formatting of B1:C1 lost

Comment 5 Dennis Roczek 2014-06-24 12:47:46 UTC

CONFIRMED.

I created initial a sheet with A1:A3 (d'oh) and that worked. A1:C1 doesn't work as intended. :-(

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.