Issue 99098

Summary: Calc: Import Excel 2003 XML: Grid Line Color
Product: Calc Reporter: danielbw <daniel.watsonbros>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida
Version: DEV300m39   
Target Milestone: ---   
Hardware: PC (x86_64)   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test document with custom grid line color none

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.