https://bugs.freedesktop.org/show_bug.cgi?id=76785
Priority: medium
Bug ID: 76785
Assignee: [email protected]
Summary: Format "[Color17]General" saved incorrectly to ods
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96603
--> https://bugs.freedesktop.org/attachment.cgi?id=96603&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
