https://bugs.documentfoundation.org/show_bug.cgi?id=160265
Bug ID: 160265
Summary: Undo of deleting conditional formatting with formula
effecting multiple sheets deleted some data.
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: alex...@gmail.com
Description:
Undo of deleting conditional formatting with formula effecting multiple sheets
results in deletion of some data on the source sheet.
Steps to Reproduce:
1.Created 2 sheets, first sheet A1 text and A2 a value of [50]
2.Sheet 2: A1 text and A2 [=$Sheet1.A2] and B1 text and B2 Value [55] and E1
text and E2 [=$Sheet1.A2+B2] with Conditional Formatting option "Condition 1"
[Formula is] [$Sheet1.$A$2+$Sheet2.$B$2] and "Apply Style:" [Accent]. At this
time the value of E2 is automatically bold [105]
3.Delete, the Conditional formatting for E2.
Actual Results:
1. E2 is no longer is bold and value is [105],
2. If I wish to undo the last action, the contents of A1 and A2 in sheet 1 are
deleted and the value of E2 is automatically bold [55]
Expected Results:
Undoing last action, (deleting the conditional formatting for E2 in sheet2)
should not delete the content of sheet one.
FYI: If values were all on the same sheet, E2 [=A2+B2] and the same formula in
the conditional formatting for E2 [=A2+B2]. The undo would simply undo the
deletion of the conditional formatting.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.4
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
