Recently updated to LibreOffice 25.8, and the conditional formatting doesn’t seem to properly prioritize the conditions. I’ve tried swapping the conditions around, but the colour scale always overwrites specific cell value formats. This wasn’t an issue before updating; I’m just trying to figure out how to fix it, rather than simply reinstall the old version.
Please attach a sample file, reduce the size as much as possible without private information,
and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
No crystal balls here.
Sorry for the late response.
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 8; OS: Windows 10 X86_64 (build 19044); UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded
Sample.ods (28.7 KB)
I recognize a conflict and a duplicate in the conditional formatting sentence in the range [H2:T11]:
- Condition 1 to 4 versus Condition 5;
- Condition 1 = Condition 6.
The issue is reproducible with
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c01e50ce848eb175813c27679d6c52056ea67625
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
No previous version works fine, since color scale was implemented (ver 3.5)
Please report the bug so that it can be confirmed.
Filled out the bug report as suggested.
“No previous version works fine…”
For the sake of thoroughness, I will reiterate what I said in my initial post. These are old spreadsheets which only broke after updating, the previous version I was on (the installer says 6.4.3) did work.
Edit: Thanks for your help regardless.
I have no 6.4.3 version but 6.4.7, and see no difference.
All three screenshots from Windows versions.
Same on Linux with version 24.8.5.2.
1 Like
There was problem with overlapping ranges in 24.2.1.2 queried in an earlier question. There was a bug fix for 24.2 in tdf#160117 that might be relevant to your situation. Your previous installation might have incorrectly allowed your conflicting formats to appear as you saw them.