Bug 76785 - Format "[Color17]General" saved incorrectly to ods
Summary: Format "[Color17]General" saved incorrectly to ods
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.1.3.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-03-29 20:45 UTC by M Welinder
Modified: 2014-10-30 15:45 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments
color17.xls sample file (5.50 KB, application/vnd.ms-excel)
2014-03-29 20:45 UTC, M Welinder
Details

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.