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