https://bugs.documentfoundation.org/show_bug.cgi?id=159245
--- Comment #8 from m_a_riosv <miguelange...@libreoffice.org> --- (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. -- You are receiving this mail because: You are the assignee for the bug.