Bug 122104 - FILEOPEN XLSX, Conditional formatting with a gradient background changes to a single color background in LO
Summary: FILEOPEN XLSX, Conditional formatting with a gradient background changes to a...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on: 49177
Blocks: XLSX-Conditional-Formatting Object-Fill-Gradient
  Show dependency treegraph
Reported: 2018-12-14 12:40 UTC by NISZ LibreOffice Team
Modified: 2023-08-24 20:07 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

The original spreadsheet. (17.64 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-12-14 12:40 UTC, NISZ LibreOffice Team
Screenshot of the original document side by side in Excel and Calc. (320.30 KB, image/png)
2018-12-14 12:41 UTC, NISZ LibreOffice Team

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 12:40:19 UTC
When you create a conditional formatting in Excel with a gradient background and open it in LO it changes to a single color background somewhere between the two colors.

Steps to Reproduce:
    1. Create a new xlsx in Excel.
    2. Create a new conditional formatting rule and give it a background with gradient effect between 2 colors.
    3. Write some text that fulfills the condition.
    4. Save it and open it in LO

Actual Results:
The cells that fulfill the condition now have a background color between the 2 colors.

Expected Results:
They should keep their gradient background.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 NISZ LibreOffice Team 2018-12-14 12:40:50 UTC
Created attachment 147544 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 12:41:10 UTC
Created attachment 147545 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Roman Kuznetsov 2018-12-15 10:11:22 UTC
confirm in

Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

and in

ID сборки: 65905a128db06ba48db947242809d14d3f9a93fe
Потоков ЦП: 4; ОС:Windows 6.1; Отрисовка ИП: по умолчанию; 
Локаль: ru-RU (ru_RU); Calc: group threaded

Calc can't make gradient fill for cells therefore it changes gradient fill in cells to solid color
Comment 4 Xisco Faulí 2018-12-18 17:25:03 UTC
Gradient is not yet supported in LibreOffice Calc. See bug 49177
Comment 5 QA Administrators 2021-01-24 04:05:43 UTC Comment hidden (obsolete, spam)
Comment 6 QA Administrators 2023-01-25 03:19:41 UTC Comment hidden (obsolete)
Comment 7 Michaela 2023-08-24 20:07:35 UTC
Still repro with:
Version: (X86_64) / LibreOffice Community
Build ID: e46e663cc350d89e4997095466d675b875eb2e04
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win