This is a follow-up of bug 140330 based on https://bugs.documentfoundation.org/show_bug.cgi?id=140330#c4 Steps to reproduce: 1. Open attachment 191945 [details] from bug 140330 2. Delete Row 2 -> Conditional formats breaks -> Cell value != $Sheet1.$B#REF Reproduced in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 6fc537cdf496f3a644ec68d6103de51eb7f5c9cb CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded and Version: 6.0.0.0.alpha1+ Build ID: 6eeac3539ea4cac32d126c5e24141f262eb5a4d9 CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: gtk3; Locale: es-ES (es_ES.UTF-8); Calc: group threaded
And what should be expected?, the same happens in a cell with references to row 2.
(In reply to m_a_riosv from comment #1) > And what should be expected?, the same happens in a cell with references to > row 2. if you do 1. Open attachment 191945 [details] from bug 140330 2. Delete Row 2 3. Undo 4. Redo Then the conditional format is correct -> $Sheet1.$B2
Not for me Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded or Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 83c1df8e524cc74c6d1afcadb3cccba5ef2eb123 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
I can reproduce steps from comment 2 and description. Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 96493091a80fb01c33ea9153b737fdc554de61f0 CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
I can also reproduce it in Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1 CPU threads: 1; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
(In reply to Xisco Faulí from comment #2) > (In reply to m_a_riosv from comment #1) > > And what should be expected?, the same happens in a cell with references to > > row 2. > > if you do > > 1. Open attachment 191945 [details] from bug 140330 > 2. Delete Row 2 > 3. Undo > 4. Redo > > Then the conditional format is correct -> $Sheet1.$B2 Btw, the wrong behaviour on step 4 was recently fixed by 96493091a80fb01c33ea9153b737fdc554de61f0 @Mike, I thought you might be also interested in this issue
(In reply to m_a_riosv from comment #1) > And what should be expected?, the same happens in a cell with references to > row 2. Indeed - if you have a single cell, which references a deleted cell, you expect that its reference is now broken. But please check this bug. There is an *area* conditional formatting. In it, *every cell* references *to its right* (using *relative reference*), not up; and after the deletion, the remaining cell should still reference its right neighbor. The conditional format range should shrink, not become invalid.
(In reply to Mike Kaganski from comment #7) > (In reply to m_a_riosv from comment #1) > > And what should be expected?, the same happens in a cell with references to > > row 2. > > Indeed - if you have a single cell, which references a deleted cell, you > expect that its reference is now broken. > > But please check this bug. There is an *area* conditional formatting. In it, > *every cell* references *to its right* (using *relative reference*), not up; > and after the deletion, the remaining cell should still reference its right > neighbor. The conditional format range should shrink, not become invalid. Understand and agree. It seems like it could be adapted as arrays do, when deleting reference rows from the array formula.