https://bugs.documentfoundation.org/show_bug.cgi?id=161076
Bug ID: 161076 Summary: Deleting row in one sheet moves background highlight in referenced sheet Product: LibreOffice Version: 24.2.3.2 release Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: pavel.zahrad...@centrum.cz Steps to reproduce: 1. Create new spreadsheet 2. Select entire row (for example row 2 in Sheet1) and set background color of the row (for example yellow) 3. Add new sheet (Sheet2) 4. In Sheet2 enter formula reference to Sheet1, for example set A1=Sheet1.A1 5. Now select entire row 1 in Sheet2 and delete this row (i.e. cell A1 containing the reference will also be deleted) 6. Switch to Sheet1 and see result - yellow background is left only for A2 and for columns starting with B it has moved to row 1, while it is expected that row 2 keeps yellow background... -- You are receiving this mail because: You are the assignee for the bug.