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 treegraph
 
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

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.