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
*** This bug has been marked as a duplicate of bug 163193 ***
Hi Miguel, I think this is not a duplicated of bug 163193 since this issue is happening in master/25.8. On the contrary bug 163193 looks like a duplicated of bug 160252
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/a67ab7ea6f090ee90871bfb97243b9cd66b44af4 tdf#167019 Conditional formatting is not handled properly It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/a33c5a4298b6292871f818fc57275840c519af6c tdf#167019 Conditional formatting is not handled properly It will be available in 25.8.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e8a5459003797f35929dd88b957c864643fcdd92 tdf#167019: sc_uicalc: Add test It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.