Description: The same spreadsheet gives a completely different result when opened in 25.2.4.3 and Steps to Reproduce: 1.Open attached spreadsheet with 25.2.4.3 2.Open attached spreadsheet with 25.8.0.0.beta1 Actual Results: With 25.2.4.3, the conditional formatting works nicely and no cell is flagged as being outside the specified range. With 25.8.0.0.beta1, a large number of cells are flagged as being outisde the specified range. Expected Results: The cells should not be flagged as being outside tyhe range. Reproducible: Always User Profile Reset: Yes Additional Info: 1b25e37a63c5a6f16bdcb365ed3da80ac419e6e4
Created attachment 201285 [details] Blood pressure entries Version 25.8.0.0.beta1 appears to be reading a unique range for all conditionally formatted cells instead of the range actually specified for a cell.
Confirm with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 220ef19df9de6ee7a99173a514402a9e701748d1 CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL threaded fine with Version: 25.2.2.0.0+ (X86_64) / LibreOffice Community Build ID: d3c332aa2d721601b14ecfff3f4f83ab8e9cb5a5 CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL threaded
The issue is that the range of the condition are merged in the first one, without take care that the conditions even with the same type have different parameters.
BTW, it happens only at reading XLSX format, not with ODS.
bibisected with linux-64-25.8 author Noel Grandin commit e2cc1f8a6bd27907800416a5396942a0c7ca56ce tdf#134864 speedup load of pathological conditional formats in XLS Reviewed-on: https://gerrit.libreoffice.org/c/core/+/182356