We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

Delete custom styles in Calc [closed]

asked 2017-03-01 01:48:25 +0200

Pheeble gravatar image

updated 2021-05-23 13:45:07 +0200

Alex Kemp gravatar image

I have created a few custom styles in Calc (LibreOffice in Xubuntu 16.04), but I am unable to delete them.

This seems to be a recurring issue in LibreOffice, but the last reference to it I could find was from years ago.

I can right-click on a custom style in the 'Styles and Formatting' sidebar, and click the 'Delete...' option, but the style is never deleted. In every view type except 'Hierarchical' the style is not removed from the list. In the 'Hierarchical' view, the style is initially removed from the list, but on switching to another view and back to Hierarchical, the style is still displayed in the list.

Is there some obscure trick to this, or is it the same old bug again?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-07 13:47:55.245641

1 Answer

Sort by » oldest newest most voted

answered 2017-03-01 08:02:56 +0200

pierre-yves samyn gravatar image


What you describe happens when (at least) one sheet is protected (Tools > Protect Sheet). In this case it is impossible to delete a style. Would not you be in that case?


edit flag offensive delete link more


Yes, you're right, a sheet was protected. I didn't think that would be a problem because the style I am trying to delete is not being used anywhere in the document. Once I unprotected the sheet I could delete the style. Thanks.

Pheeble gravatar imagePheeble ( 2017-03-02 23:44:59 +0200 )edit

Question Tools

1 follower


Asked: 2017-03-01 01:48:25 +0200

Seen: 758 times

Last updated: Mar 01 '17