Issue 123680 - OpenOffice does not import Excel's table format/styles
Summary: OpenOffice does not import Excel's table format/styles
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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/vnd.ms-excel)
2013-11-13 18:47 UTC, webassistant5.tft+openoffice 		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 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
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 
.