[Solved] Modifying a style

Discuss the spreadsheet application

[Solved] Modifying a style

Postby jimbokea » Thu May 09, 2019 3:26 am

Hi There - If you right click on a cell style in styles & Formatting a pop-up comes up that says New, Modify, Delete. If you select 'modify' nothing happens.
Please advise - Cheers Jim
Last edited by robleyd on Fri May 10, 2019 3:02 am, edited 2 times in total.
Reason: Add green tick
OPenOffice 4.1.1 on Windows 7
jimbokea
 
Posts: 170
Joined: Fri Jul 15, 2011 1:10 am

Re: modifying a style

Postby Zizi64 » Thu May 09, 2019 6:51 am

Maybe the sheet is protected. You can not modify the styles that are applied on a protected sheet.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: modifying a style

Postby jimbokea » Thu May 09, 2019 7:30 am

No - sheet is not protected
OPenOffice 4.1.1 on Windows 7
jimbokea
 
Posts: 170
Joined: Fri Jul 15, 2011 1:10 am

Re: Modifying a style

Postby Zizi64 » Thu May 09, 2019 10:55 am

No - sheet is not protected

...an what about another sheets? Maybe the style was applied on an another protected sheet...

Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Modifying a style

Postby jimbokea » Fri May 10, 2019 2:14 am

Well it seems you have to unprotect every sheet in the file for the modify to work - even sheets that don't have the style on them ( were part of conditional formatting)
Thanks - Jim
OPenOffice 4.1.1 on Windows 7
jimbokea
 
Posts: 170
Joined: Fri Jul 15, 2011 1:10 am

Re: [Solved] Modifying a style

Postby Zizi64 » Fri May 10, 2019 6:40 am

Well it seems you have to unprotect every sheet in the file for the modify to work - even sheets that don't have the style on them ( were part of conditional formatting)


Even the Conditional Formatting feature uses the cell styles when you configure it. That means the style is applied (conditionally).
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 19 guests