Bug 157525 - Deleting columns, it will appear as if no conditional formatting styles were applied
Summary: Deleting columns, it will appear as if no conditional formatting styles were ...
Status: RESOLVED DUPLICATE of bug 156689
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-30 06:41 UTC by Saburo
Modified: 2023-10-16 14:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2023-09-30 06:41:45 UTC 
Description:
If you delete a column to the right of the rightmost column in a used range of cells, the styles set in the rightmost column conditional formatting will appear as if they were not applied.

I reported it in 156689, but I thought it was another problem with conditional formatting.

Steps to Reproduce:
1.Enter "99" in cell A1
2.[Format]-[Conditional]-[Condition]
Condition1
[Cell value] [is greater than] [ 90 ]
Apply Style [Accent 1]
Range [ A1 ]
3.Delete column "B"

Actual Results:
If the right side of the fill turns white, if you redraw it by scrolling, moving sheets, print preview, etc., it will behave as if the conditional formatting has been removed.

Expected Results:
Style settings are preserved


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
Sometimes it doesn't happen when you insert a column

Deleting multiple columns may remove styles for columns other than the rightmost column

The background and text decorations will not be restored unless you reopen the file or edit the conditional formatting.

Version: 7.5.7.1 (X86_64) / LibreOffice Community
Build ID: 47eb0cf7efbacdee9b19ae25d6752381ede23126
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: en-GB
Calc: CL threaded
Comment 1 Saburo 2023-10-01 08:15:20 UTC 
Copy A1 cell to A2 before deleting column "B".

Select A1
[Format]-[Conditional]-[Condition...]
A confirmation dialog appears.

But after deleting column "B"
Select A1
[Format]-[Conditional]-[Condition...]
Confirmation dialog does not appear

[Format]-[Conditional]-[Manage]
Conditional Formats list have settings
A1:A2 Cell Value > 90
Comment 2 Stéphane Guillou (stragu) 2023-10-16 14:38:50 UTC 
As Kira mentioned in bug 156689 comment 7, the issue started at the same commit. Let's keep it as a single bug report.

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