Bug 147538 - Style Deleting Problem
Summary: Style Deleting Problem
Status: RESOLVED DUPLICATE of bug 81467
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Reported: 2022-02-19 17:58 UTC by Warren L. Berardi
Modified: 2023-01-16 16:00 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Warren L. Berardi 2022-02-19 17:58:52 UTC
CALC will allow you to delete a STYLE if it is not used in any formula in any sheet even if it IS used in a conditional format.  The STYLE delete function needs to be corrected so that it also cross-references a STYLE in conditional formats before it will allow you to delete it.  The Find/Change function also needs to be enhanced to search and replace a STYLE in conditional formats as well as formulas.

Steps to Reproduce:
1.Create a STYLE.
2.Create a conditional format that uses the STYLE.
3.DO NOT use the STYLE in any cell formula.
4.Delete the STYLE.

Actual Results:
The STYLE is deleted and the STYLE field in the conditional format is blank

Expected Results:
You should not be able to delete the STYLE.

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Warren L. Berardi 2022-03-07 13:54:04 UTC
This needs to be fixed.
Comment 2 csyu.279 2023-01-09 16:19:36 UTC
Could you attach a visual example?
Comment 3 Buovjaga 2023-01-16 16:00:33 UTC

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