https://bugs.documentfoundation.org/show_bug.cgi?id=147853
Bug ID: 147853
Summary: FORMATTING: Conditional formatting is inconsistent
when inserting new first row
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: documentfoundat...@peterfab.com
Created attachment 178735
--> https://bugs.documentfoundation.org/attachment.cgi?id=178735&action=edit
Document used for testing
Description:
If a new row is inserted above the first row of a spreadsheet, and cells in
that row have conditional formatting, the conditional formatting is applied to
the new top row. However, this is not reflected in the ranges shown in "Format
> Conditional > Manage..."; additionally, when saving and reopening, the new
top row is no longer conditionally formatted.
Reproduction steps:
1. Open the attached document bug_test.ods, or create a new document with
conditional formatting applied to cells in the top row.
2. Right-click on the row number of Row 1 and select "Insert Rows Above".
3. Edit the value of the new cell to observe that it is conditionally
formatted.
4. Navigate to the menu Format > Conditional > Manage... and observe that the
new cell is not included in the conditional formatting range.
5. Save, close, and reopen the document.
6. Observe that the cell in the new top row is no longer conditionally
formatting.
Expected behavior:
Either of the following (not sure which is intended).
1. Cells in the new first row do not inherit conditional formatting from the
previous first row.
2. Cells in the new first row inherit conditional formatting from the previous
first row, and this is correctly saved and shown in the Manage Conditional
Formatting dialog.
Version information:
Version: 7.2.5.2.0+ / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 6; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.2.5-4
Calc: threaded
Package information:
Operating system: Arch Linux x64
Package source: https://archlinux.org/packages/extra/x86_64/libreoffice-still/
Package version: 7.2.5-4
Also reproduced with the following version:
Version information:
Version: 7.3.0.3 / LibreOffice Community
Build ID: 30(Build:3)
CPU threads: 6; OS: Linux 5.16; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.3.0-5
Calc: threaded
Package information:
Operating system: Arch Linux x64
Package source: https://archlinux.org/packages/extra/x86_64/libreoffice-fresh/
Package version: 7.3.0-5
--
You are receiving this mail because:
You are the assignee for the bug.
