[Solved] New, Modify or Delete not working for Styles

Discuss the spreadsheet application
Locked
User avatar
Bal
Posts: 14
Joined: Wed Dec 25, 2019 6:25 pm

[Solved] New, Modify or Delete not working for Styles

Post by Bal »

Opening the Styles & Formatting with F11 shows me the styles I have set up in Calc. But now, when I try to create a new style, modify a current style or delete a style, I do not get a second window to actually modify the new style, cannot get a window to modify a style if I select Modify and cannot get a confirmation window when trying to delete a file. In short, making any of these choices when right-clicking a style does nothing.

It didn't used to be this way and if someone knows how to restore the default behavior for Styles & Formatting I'd appreciate hearing about it.
Last edited by Bal on Mon Oct 07, 2024 10:13 pm, edited 1 time in total.
OpenOffice 4.1.7 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 5100
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: New, Modify or Delete not working for Styles

Post by MrProgrammer »

Bal wrote: Mon Oct 07, 2024 5:25 pm In short, making any of these choices when right-clicking a style does nothing.
[Solved] Modify Style fails when ANY sheet is protected

If you need any additional assistance attach a spreadsheet demonstrating the difficulty (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the spreadsheet itself). I will not help further unless you attach a spreadsheet document.

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
RoryOF
Moderator
Posts: 34791
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: New, Modify or Delete not working for Styles

Post by RoryOF »

As MrProgrammer says, but a quick test is to start a new Calc file and see if you can new or modify a style in that.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Bal
Posts: 14
Joined: Wed Dec 25, 2019 6:25 pm

Re: New, Modify or Delete not working for Styles

Post by Bal »

It was a protected sheet in the workbook. I didn't imagine it as the cause. Thanks very much for the help. I edited the original post to show as solved.
OpenOffice 4.1.7 on Windows 10
Locked