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
Created attachment 193183 [details] Screen recording of the actions in a calc spread sheet. I am not very familiar with formulas in conditional formatting, so in testing things, I just stumbled across this issue. I will add myself to the CC to see if this issue has any merits >{;^) Thank you for being there. Alex
Please test with newest master daily, or wait for the next LO 24.2.3, which should have this issue solved. *** This bug has been marked as a duplicate of bug 160149 ***
Thank you for all your help and diligence Alex
*** This bug has been marked as a duplicate of bug 160149 ***