Issue 117527 - XLS import: Read theming information written by Excel 2007
Summary: XLS import: Read theming information written by Excel 2007
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.3
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-24 02:29 UTC by ramanal
Modified: 2013-08-07 15:13 UTC (History)
2 users (show)

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

Attachments
spreadsheet marked as yellow and green, but only yellow showed. (16.50 KB, application/vnd.ms-excel)
2011-03-24 02:29 UTC, ramanal 		no flags Details
XLS using color to mark schedule. (37.50 KB, application/vnd.ms-excel)
2011-04-11 03:53 UTC, ramanal 		no flags Details
screenshot when viewed in XL2007 (210.00 KB, image/jpeg)
2011-04-11 03:55 UTC, ramanal 		no flags Details
screenshot when viewed in OO 3.3 (204.83 KB, image/jpeg)
2011-04-11 03:57 UTC, ramanal 		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 ramanal 2011-03-24 02:29:24 UTC 
Created attachment 76180 [details]
spreadsheet marked as yellow and green, but only yellow showed. 

I often received excel file from other party. Sometimes use color as marking.
But this time green color in xls showed as yellow.
Comment 1 ooo 2011-03-24 12:02:40 UTC 
Certainly not a P1.
Comment 2 frank 2011-03-26 17:01:42 UTC 
Opened the file with Excel XP and could not find any green cells.
Therefore Calc works without bug I suppose.
Please specify which cell(s) should be marked green.

Frank
Comment 3 frank 2011-04-09 14:54:58 UTC 
No reaction from submitter and no faults identifiable so closed worksforme
Comment 4 ramanal 2011-04-11 03:53:09 UTC 
Created attachment 76339 [details]
XLS using color  to mark schedule.

resubmitted xl file.
Comment 5 ramanal 2011-04-11 03:55:18 UTC 
Created attachment 76340 [details]
screenshot when viewed in XL2007

screenshot when viewed in XL2007
Comment 6 ramanal 2011-04-11 03:57:26 UTC 
Created attachment 76341 [details]
screenshot when viewed in OO 3.3

screenshot when viewed in Openoffice 3.3.
Comment 7 ramanal 2011-04-11 04:00:21 UTC 
Please, check it again. I resubmit the XL sample with screenshot.

Usually I got email notification for any progress in the report. But this time after Openoffice.org site update, I only receive email notification when you close this report.
Comment 8 ramanal 2011-04-11 04:01:49 UTC 
Please, check it again. I resubmit the XL sample with screenshot.

Usually I got email notification for any progress in the report. But this time after Openoffice.org site update, I only receive email notification when you close this report.
Comment 9 frank 2011-04-11 09:00:03 UTC 
Hi Daniel,

please have a look.

Frank
Comment 10 daniel.rentz 2011-04-11 09:16:49 UTC 
Excel 2007 writes a color palette and additional theming information into the XLS file. The latter is not part of the original XLS file format, and is not interpreted by Excel 97-2003 and OpenOffice.org Calc, therefore these applications show the palette colors ("themes" are a new concept in Excel 2007). Excel 2007 fails to write an appropriate replacement color into the palette for the original green color but puts plain yellow instead.

I will take this issue as an enhancement request.

BTW: If the file is converted to XLSX or XLSB format, Calc will open it correctly.
Comment 11 Oliver-Rainer Wittmann 2012-06-13 12:30:05 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.