Issue 99098 - Calc: Import Excel 2003 XML: Grid Line Color
Summary: Calc: Import Excel 2003 XML: Grid Line Color
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: DEV300m39
Hardware: PC (x86_64) Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-02-11 00:37 UTC by danielbw
Modified: 2013-01-29 21:50 UTC (History)
2 users (show)

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

Attachments
test document with custom grid line color (3.09 KB, text/xml)
2009-02-11 15:54 UTC, kyoshida 		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 danielbw 2009-02-11 00:37:17 UTC 
I am using the vanilla build of OpenOffice.org DEV300_m39

    When opening an Excel 2003 xml file with a non-default grid line color, calc
does not import the color correctly.

    In the xsl file:
filter/source/xslt/import/spreadsheetml/spreadsheetml2000.xsl, GridlineColor
uses the hex2decimal template. This template appears to change a color's RGB
value to it's decimal value equivalent.  I can only import colors up to a
decimal value of 65535, or #00FFFF. That color happens to be CYAN. Any color
with a decimal value higher than this does not work.

    When I run the xslt manually using xsltproc, the values are handled correctly.

    When I reconfigured my build environment with --with-system-saxon
--with-system-libxslt the color imports with no problems at all.  Something is
wrong with the xslt processor provided by OpenOffice.org.

    I am not sure if this work-around will work on other platforms such as
Windows, MAC, OpenSolaris, etc. which is why I made this bug report.

Thank you,
Daniel Watson
Comment 1 kyoshida 2009-02-11 15:54:18 UTC 
Created attachment 60097 [details]
test document with custom grid line color
Comment 2 kyoshida 2009-02-11 15:56:06 UTC 
Here is a test document that demonstrates an incorrect importing of grid line
color.  This document is saved in the Excel 2003 XML format.  When opened in
Excel, the grid line is orange, but when opened in Calc, it becomes black.