Summary: | Conditional Format breaks after deleting row | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Xisco Faulí <xiscofauli> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | normal | CC: | aron.budea, miguelangelrv, mikekaganski, raal, xiscofauli |
Priority: | medium | ||
Version: | 4.1.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=140330 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 87351 |
Description
Xisco Faulí
2024-01-17 15:14:05 UTC
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. |