https://bugs.documentfoundation.org/show_bug.cgi?id=157525

            Bug ID: 157525
           Summary: Deleting columns, it will appear as if no conditional
                    formatting styles were applied
           Product: LibreOffice
           Version: 7.5.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to