https://bugs.documentfoundation.org/show_bug.cgi?id=106734

            Bug ID: 106734
           Summary: Incorrect colors imported from XLS with conditional
                    formatting (XLSX is okay)
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 132111
  --> https://bugs.documentfoundation.org/attachment.cgi?id=132111&action=edit
XLS sample

The attached XLS contains conditionally formatted cells with the predefined
color schemes in Excel 2013. (Light Red Fill with Dark Red Text etc.)

A lot of those colors are imported incorrectly, especially Dark Red, which is
imported as purple. The rest are only slightly different. The same colors look
okay when imported from XLSX.

Color codes from Excel (text and background):
A2: 156 / 0 / 6         255 / 199 / 206
B2: 156 / 101 / 0       255 / 235 / 156
C2: 0 / 97 / 0          198 / 239 / 206
D2: Automatic           255 / 199 / 206
E2: 156 / 0 / 6         No fill
F2: Automatic           No fill         border 156 / 0 / 6

Color codes/names from Calc (text and background):
A2: #800080             Pink 10
B2: #993300             Yellow
C2: Green 5             Green 10
D2: Black               Pink 10
E2: #800080             No fill
F2: Black               No fill         border #800080

Reproduced with v5.3.1.2 & v3.3.0 / Windows 7.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to