If I have two conditional formatting areas in the same column and then save the file as an xlsx. When I open the file, calc treats the area as one area. If I open conditional formatting dialog box, I can see the two areas listed separately, but joined with a comma.
I am specifically working with a color scale (3 entries). My colors are red, white, and green for min, percentile (50), max.
I think this is a recent change. Similar files displayed as expected before a recent upgrade.
Version: 25.8.5.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 32; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:25.8.5-0ubuntu0.22.04.1~lo1
Calc: threaded