Depends on where you open it. If I double-click an email attachment to open it, I can't make any changes at all (not even column width). Once I save it to my hard drive, it becomes unprotected.

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. Thus, you can do a lot of "what if" analysis but can't mess up someone else's work.

Dave


On 7/18/2013 11:44, Tom Davies wrote:
Hi :)
I think if you open an Excel spreadsheet that is supposedly "protected" in Calc 
then you bypass all the password protections and stuff.

My company's (well the place where i work, it's not really mine as such) 
finance lady was somewhat horrified when i was easily able to fix a problem for 
her despite having no idea what the password was.  I hadn't even realised the 
spreadsheet was supposedly protected!
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 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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to