https://bugs.documentfoundation.org/show_bug.cgi?id=153506
Bug ID: 153506
Summary: LibreCalc - When copying an existing sheet to a new
sheet LibreCalc does not preserve conditional
formatting on new sheet. Example provided in
description.
Product: LibreOffice
Version: 6.1.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreCalc does not seem to preserve conditional formatting when copying an
existing sheet containing such formatting to a new sheet. When selecting the
Format->Conditional->Manage option the resulting "Manage Conditional
Formatting" screen is quite different for the two sheets. The new sheet,
created as a copy of the original sheet, contains many fewer lines and it
appears that several of the lines have been unexpectedly merged. For example:
Original Sheet contains the following two conditional formatting lines:
-----------------------------------------------------------------------
B18:M18 cell value is > $Budget.$B23
B19:M19 cell value is > $Budget.$B24
In the new sheet created as a copy of the Original sheet the two lines shown
above seem to be replaced with the following line:
-----------------------------------------------------------------------
B18:M19 cell value is > $Budget.$B23
Steps to Reproduce:
1.Create a sheet containing significant amount of conditional formatting
2.Copy sheet to a new sheet
3.Sequentially selected Format->Conditional->Manage... for the original sheet
and the new sheet and compare the resulting list of conditional formatting for
each sheet. First order check is to count the number of lines in the Manage
Conditional Formatting pop-up window for each sheet. In my example, I counted
30 lines of conditional formatting for the original sheet, and only 14 lines of
conditional formatting for the new sheet.
Actual Results:
Example of a single line in the new sheet that was incorrectly created a a
merger of the two lines shown under Expected Results below:
B18:M19 cell value is > $Budget.$B23
Expected Results:
B18:M18 cell value is > $Budget.$B23
B19:M19 cell value is > $Budget.$B24
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u6
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group threaded
--
You are receiving this mail because:
You are the assignee for the bug.
