Bug 122108 - FILEOPEN XLSX, Conditional formatting missing its pattern when opened in LO
Summary: FILEOPEN XLSX, Conditional formatting missing its pattern when opened in LO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on: 31205
Blocks: XLSX-Conditional-Formatting
  Show dependency tree / graph
 
Reported: 2018-12-14 13:04 UTC by NISZ LibreOffice Team
Modified: 2021-04-10 13:14 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
The original spreadsheet. (17.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 13:05 UTC, NISZ LibreOffice Team 		Details
Screenshot of the original document side by side in Excel and Calc. (379.94 KB, image/png)
2018-12-14 13:05 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 13:04:42 UTC 
Description:
Conditional formatting with a pattern when opened in LO is missing its pattern/recolors the background when opened in LO.

Steps to Reproduce:
    1. Create a new xlsx in Excel.
    2. Create a conditional formatting rule with a background and pattern.
    3. Save it and open it in LO.
    4. Notice the differences.

Actual Results:
Depending on the pattern its either the background gets recolored or the pattern goes missing.

Expected Results:
The pattern and the background should stay the same.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2018-12-14 13:05:11 UTC 
Created attachment 147552 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 13:05:29 UTC 
Created attachment 147553 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Durgapriyanka 2018-12-14 19:53:21 UTC 
Thank you for reporting the bug.I can confirm that the pattern background changes to a color background instead of remaining the same in

Version: 6.3.0.0.alpha0+
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 4 Xisco Faulí 2018-12-18 13:49:23 UTC 
Also reproduced in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.15; Render: default; 

and

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

root cause is cells background doesn't support patterns...
Comment 5 Buovjaga 2019-01-24 18:27:27 UTC 
Thought about duping, but maybe depends on 31205 is enough.