https://bugs.documentfoundation.org/show_bug.cgi?id=162938
Bug ID: 162938
Summary: Import of Excel spreadsheet with conditional
formatting is not presenting the same in Calc
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When we import a spreadsheet from Excel that contains conditional formatting
with icon sets, it's not showing the arrows in Calc.
This only started happening with (release version) 24.8.0.3. Unfortunately, I
didn't keep track of the exact previous version where it was working, but we
update very regularly from the general release versions, and noticed it as soon
as 24.8.0 came out.
We've found the issue on both Mac (Sonoma on intel) and Ubuntu (22.04 on
x86_64).
I'll attach an example spreadsheet and screenshots.
Steps to Reproduce:
1. Create and Excel spreadsheet using conditional formatting with icon sets,
where red is < 0, yellow is = 0 and green is > 0
2. Open the Excel spreadsheet in Calc
3. The arrows are not being displayed consistently with the rule set up in
Excel
Actual Results:
Green up-arrow shown where value in cell = 0
Red down-arrow shown where value in cell is minimum in the set
Expected Results:
Green up-arrow when value in cell > 0
Yellow side-arrow when value in cell = 0
Red down-arrow when value in cell < 0
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Displayed the results consistent with the Excel presentation
--
You are receiving this mail because:
You are the assignee for the bug.
