| Summary: | FILEOPEN XLSX, Conditional formatting missing its pattern when opened in LO | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | enhancement | CC: | ilmari.lauhakangas, kelemeng, nemeth, xiscofauli |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | 4.1 all versions | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=141607 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | 31205 | ||
| Bug Blocks: | 113782 | ||
| Attachments: |
The original spreadsheet.
Screenshot of the original document side by side in Excel and Calc. |
||
Created attachment 147552 [details]
The original spreadsheet.
Created attachment 147553 [details]
Screenshot of the original document side by side in Excel and Calc.
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 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... Thought about duping, but maybe depends on 31205 is enough. |
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: