Bug 76785

Summary: Format "[Color17]General" saved incorrectly to ods
Product: LibreOffice Reporter: M Welinder <terra>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: rb.henschel, serval2412
Version: 4.1.3.2 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: color17.xls sample file

Description M Welinder 2014-03-29 20:45:56 UTC 
Created attachment 96603 [details]
color17.xls sample file

The upcoming xls file has a cell with format [Color17]"marker"General.
When saved to ods this becomes...

<number:number-style style:name="N132">
  <style:text-properties fo:color="#333333"/>
  <number:text>marker</number:text>
  <number:number number:min-integer-digits="1"/>
  <number:text/>
</number:number-style>

That's the wrong colour.  It should be #9999FF.  The other numbered colours
are wrong too.  When Gnumeric (git) reads the above ods sniplet, it generates
[Color56]"marker"General because #333333 is colour 56 in the Excel palette.

References:
http://dmcritchie.mvps.org/excel/colors.htm
http://christian.bloggingon.net/archive/2007/05/23/hintergrundfarben-fuer-excel-in-aspose.aspx

Note, that the correct 56-colour palette has duplicates.  That's stupid,
but it is MS stupidity.
Comment 1 Julien Nabet 2014-03-30 14:44:11 UTC 
On pc Debian x86-64 with master sources updated today, I can reproduce the problem.
Not official but I found this about Excel colors:
http://www.himmera.com/Excel_Tutorial/Excel_color_code_for_VBA_Macros.html

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.