Ask Your Question

How can I remove conditional formatting styles in Calc? [closed]

asked 2016-10-05 14:38:43 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have created several styles which I no longer use. I currently use Arch Linux, with LibreOffice | Version:

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-29 09:29:34.383730

2 Answers

Sort by » oldest newest most voted

answered 2016-10-05 14:54:27 +0100

JohnSUN gravatar image

What about F11, right-click on style name and Delete?

Del Style

edit flag offensive delete link more


Many thanks; this does not work on my version!

beancounter gravatar imagebeancounter ( 2016-10-05 15:02:10 +0100 )edit

What does actually happen if you try to open the 'Stylist'
- with F11
- going > 'Format' > 'Styles' > 'Styles and Formatting' ?
Is your question actually about deleting styles? There are no generic "conditional formatting styles". Any named cell style can be used with CF.
If you delete a style used with CF the respective functionality of the CF concerned will vanish. The CF itself will persist with void style. To avoid old rubbish first rework the CF, then delete unused styles.

Lupp gravatar imageLupp ( 2016-10-05 18:20:10 +0100 )edit

May be sheet or workbook is protected?

JohnSUN gravatar imageJohnSUN ( 2016-10-05 18:50:34 +0100 )edit

answered 2016-10-05 15:00:30 +0100

mark_t gravatar image

From the menu Format, Styles, Styles and Formatting, or press F11.

In the Formatting and Styles toolbarat the right side of the screen, right click on unwanted styles and choose delete.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-10-05 14:38:43 +0100

Seen: 1,613 times

Last updated: Oct 05 '16