We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Unable to edit styles in Calc

asked 2020-08-31 16:21:57 +0200

jcs94782 gravatar image

updated 2021-05-26 21:29:10 +0200

Alex Kemp gravatar image

I need to define some custom styles in calc to be used in conditional formatting

I can successfully create a new style from the selection e.g. Default Cell Style and then edit that new style immediately but then I am subsequently unable to make any changes to my new style.

Going to the style navigator I am offered a Modify option on the Right Click menu but when I click that nothing happens

Am I missing something or is there a bug?

I have just updated to LO version Running on W10

edit retag flag offensive close merge delete


Please upload an ODF type sample file here.

Zizi64 gravatar imageZizi64 ( 2020-08-31 16:47:34 +0200 )edit

Unfortunately the spreadsheet in question contains sensitive data so I am unable to post it.

Since posting I have tested the basic operation on version 6 and 7 and both work with a simple test as expected. It appears therefore that there is something on my main spreadsheet that is causing the issue. It contains 7 Tabs and about 10 conditional formulae all using styles. I am somewhat puzzled as to how I can further diagnose the problem. I am quite experienced with Excel and LO (Excel since 1989) but this is a new problem.to me.

It is quite likely that it has been opened in Excel at time time in the past,if that is relevant.

jcs94782 gravatar imagejcs94782 ( 2020-08-31 17:27:58 +0200 )edit

@jcs94782, Was the file created in LibreOffice?

Schiavinatto gravatar imageSchiavinatto ( 2020-08-31 17:37:26 +0200 )edit

jcs94782, delete all of sensitive data from a COPY of your document. The created and applied styles are relevant only.

Zizi64 gravatar imageZizi64 ( 2020-08-31 17:56:30 +0200 )edit

I did initially create the file in LibreOffice calc but initially wanted it to be capable of being opened in Excel. I certainly have opened it in Excel. Since then I am using a hyperlink to crate an email and the Excel version does not work properly. Excel only passes 255 characters to the email client!

I can strip out all data but I cannot see how to upload it here,

jcs94782 gravatar imagejcs94782 ( 2020-08-31 22:09:26 +0200 )edit

@jcs94782, ,

Edit your question and with the clip icon, use to add the file.

Schiavinatto gravatar imageSchiavinatto ( 2020-08-31 22:22:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-06-28 09:41:34 +0200

baeren gravatar image

Is there any sheet protected?
If any of the sheets in your spreadsheet is protected, modifying styles is prohibited without any notice.

edit flag offensive delete link more


That is almost certainly the reason. Yes there are several protected sheets within the spreadsheet.

I am unable to test as I have since handed over the spreadsheet to another club member and no longer maintain it. I believe he is using Excel rather than LibreOffice. The spreadsheet contains club membership data and anonymising it would have been time consuming.

Thanks for providing this answer.

jcs94782 gravatar imagejcs94782 ( 2021-06-28 13:02:11 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-08-31 16:21:57 +0200

Seen: 125 times

Last updated: Jun 28