Ask Your Question

Can’t delete custom styles calc

asked 2018-01-18 15:15:19 +0200

Rockerdo gravatar image

Libre version calc

I cannot delete any of the custom styles. I did F 11 and right click delete. They are still there.

The style is not used anywhere in the sheet or other sheets.

I even created a different style to test delete and it won’t delete.

I have hundreds of styles built. I just want to clear them as they aren’t working right so I need to start over. Restarting the whole document would be awful and I don’t want to build this massive workbook all over again so I just want to try if I delete the styles and restart those

edit retag flag offensive close merge delete


Suppose your OS is Windows. (What version?)
I cannot actually understand for what reason you thought to need hundreds of styles. I never do.
In what way did they "not work right" (miss to match your expectations)?
Did you have some experience with Calc before starting this "huge project"?

Lupp gravatar imageLupp ( 2018-01-18 16:25:04 +0200 )edit

System is windows 2010 I just spent the last hour building three styles and reapplying them to 200 different dells. I saved the document and came back. Half of them stayed half didn’t Experience with calc no. Experience excel tons. Not all or folks have excel but have Libre instead. We need a version of the workbook to accommodate them. So I spent the weekend rebuilding it in calc

Rockerdo gravatar imageRockerdo ( 2018-01-18 16:51:05 +0200 )edit

There is no "Windows 2010". Are you talking of Windows 10?
I'm working with LibreOffice and its predecessors, mainly in Calc, for about 20 years now, and never had problems of the kind you describe. I would really want to have at hand a file of yours showing the issue, to do some "research". What is your smallest file of the kind? Best the XLS or XLSX, too, to redo the conversion.
Did you try with a reset user profile meanwhile?

Lupp gravatar imageLupp ( 2018-01-18 17:20:36 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-18 16:20:24 +0200

Lupp gravatar image

updated 2018-01-18 17:22:12 +0200

If this is a document loaded from a file in the native .ods format, the document is not read-only, the style is a named cell style, no alert or dialogue was opened when you tried to delete it, then I can only suspect either the file is corrupted in a strange way or your user profile is. Try the steps described here to get a new user profile.

By the way: You should also be able to delete a named style by simply selecting it and then pressing 'Del' (no context menu needed).

edit flag offensive delete link more


Thank you. I’m going with something is wickedly corrupted. Since this didn’t solve it. I’m resigned that I’m starting again. At least the thousands of formulas I can copy over. I just won’t bring over any conditional formats. Thank goodness for paint once I get them built so I can transfer them to the other thousand cells!

Rockerdo gravatar imageRockerdo ( 2018-01-18 17:23:56 +0200 )edit

Sorry. Simply don't understand.
Can someone with a better English than mine help me?

Lupp gravatar imageLupp ( 2018-01-18 18:20:34 +0200 )edit

I have been encountering the same problem today in Calc running on Debian. Following a suggestion from another forum I discovered that if any of the sheets are protected, the style editor does not work. Unprotecting all sheets fixed the problem. Would have been nice if there had been some appropriate error message though...

frikdt gravatar imagefrikdt ( 2018-02-10 13:41:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-18 15:15:19 +0200

Seen: 216 times

Last updated: Jan 18 '18