Bug 80400 - FILEOPEN: LO do not respect formatting of empty cells while importing from Excel 2003 XML
Summary: FILEOPEN: LO do not respect formatting of empty cells while importing from E...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.4.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-06-23 13:31 UTC by Daniil Bubnov
Modified: 2014-06-24 12:48 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Sample XML that shows formatting lost in LO 4.2.4.2 (2.00 KB, text/xml)
2014-06-24 11:52 UTC, Daniil Bubnov 		Details
View All

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.