Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tanstaafl
On 2013-07-18 4:52 PM, Dave Liesse dslie...@liessefamily.net wrote: I think what the OP is referring to is that in Excel you can do whatever you want to a protected spreadsheet -- you just can't save the changes. That is actually a completely different issue, but one that I have been meaning

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tom Davies
the document and then track changes?  Regards from Tom :)  From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Friday, 19 July 2013, 11:48 Subject: Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-19 Thread Tom Davies
To: users@global.libreoffice.org Sent: Friday, 19 July 2013, 11:44 Subject: Re: [libreoffice-users] Calc - allow users to format cells on protected sheets On 2013-07-18 8:17 PM, Errol Goetsch er...@xe4.org wrote: PS In this example, the trigger value is transparent when the cell is unlocked

[libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-18 Thread Tanstaafl
Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-18 Thread Dave Liesse
! Regards from Tom:) From: Tanstaafl tansta...@libertytrek.org To: users@global.libreoffice.org Sent: Thursday, 18 July 2013, 15:47 Subject: [libreoffice-users] Calc - allow users to format cells on protected sheets Hello, Microsoft Excel has the ability to allow

Re: [libreoffice-users] Calc - allow users to format cells on protected sheets

2013-07-18 Thread Errol Goetsch
On 2013/07/18 04:47 PM, Tanstaafl wrote: Hello, Microsoft Excel has the ability to allow users to apply formatting changes to protected cells when a sheet is protected. Is there any possible way to do this in Calc? Thanks Yes, using conditional formats. Protecting the cell _and_ the