Bug 160265 - Undo of deleting conditional formatting with formula effecting multiple sheets deleted some data.
Summary: Undo of deleting conditional formatting with formula effecting multiple sheet...
Status: RESOLVED DUPLICATE of bug 160149
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-18 23:09 UTC by Alex K
Modified: 2024-03-20 08:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Screen recording of the actions in a calc spread sheet. (1.47 MB, video/mp4)
2024-03-18 23:20 UTC, Alex K
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alex K 2024-03-18 23:09:51 UTC
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
Comment 1 Alex K 2024-03-18 23:20:09 UTC
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
Comment 2 ady 2024-03-19 01:02:32 UTC
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 ***
Comment 3 Alex K 2024-03-20 05:28:00 UTC
Thank you for all your help and diligence
Alex
Comment 4 ady 2024-03-20 08:21:42 UTC

*** This bug has been marked as a duplicate of bug 160149 ***