Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | XLS import: Read theming information written by Excel 2007 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | ramanal <tramanal> | ||||||||||
Component: | formatting | Assignee: | AOO issues mailing list <issues> | ||||||||||
Status: | CONFIRMED --- | QA Contact: | |||||||||||
Severity: | Normal | ||||||||||||
Priority: | P3 | CC: | frank, issues | ||||||||||
Version: | OOo 3.3 | ||||||||||||
Target Milestone: | --- | ||||||||||||
Hardware: | PC | ||||||||||||
OS: | All | ||||||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||||||
Developer Difficulty: | --- | ||||||||||||
Attachments: |
|
Certainly not a P1. 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 No reaction from submitter and no faults identifiable so closed worksforme Created attachment 76339 [details]
XLS using color to mark schedule.
resubmitted xl file.
Created attachment 76340 [details]
screenshot when viewed in XL2007
screenshot when viewed in XL2007
Created attachment 76341 [details]
screenshot when viewed in OO 3.3
screenshot when viewed in Openoffice 3.3.
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. 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. Hi Daniel, please have a look. Frank 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. getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used. |
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.