Issue 123680 - OpenOffice does not import Excel's table format/styles
Summary: OpenOffice does not import Excel's table format/styles
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-11-13 18:45 UTC by webassistant5.tft+openoffice
Modified: 2013-11-15 08:15 UTC (History)
5 users (show)

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

Photo of the problem (645.11 KB, image/jpeg)
2013-11-13 18:45 UTC, webassistant5.tft+openoffice
no flags Details
XLS with formatting (23.50 KB, application/
2013-11-13 18:47 UTC, webassistant5.tft+openoffice
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description webassistant5.tft+openoffice 2013-11-13 18:45:12 UTC
Created attachment 81912 [details]
Photo of the problem

Sometimes people will send a color coded document in .XLS; however when they are imported into OOCalc they loose the coloring and it is not possible to see the original coloring. This is quite problematic in some cases.

Attached is a photo referencing the problem.
Comment 1 webassistant5.tft+openoffice 2013-11-13 18:47:31 UTC
Created attachment 81913 [details]
XLS with formatting

Here is the .XLS in the photos also added for reference. It can be properly viewed in Excel 2010.
Comment 2 Jenny Kieffaber 2013-11-14 02:25:29 UTC
I was able to replicate this bug on a MAC OS X, version 4.0.1.  I used the attachment 81913 [details].  Further testing shows cell colors do transfer from OO to Excel.
Comment 3 Edwin Sharp 2013-11-14 13:21:37 UTC
Confirmed with
Excel 2010
AOO410m1(Build:9750)  -  Rev. 1537113
Win 7
Comment 4 torishrieken 2013-11-14 19:16:13 UTC
Zach Randolph 11/14/13:
Confirmed with 
Excel 2013
OO 4.0.1
Win 7 Ultimate
Comment 5 jimmore295 2013-11-15 01:40:33 UTC
I replicated this issue using a simple sheet created in Excel 2007 and opened in Open Office Calc 4.0.1.  On a Win 7 machine
Comment 6 Oliver Brinzing 2013-11-15 08:15:58 UTC