Prevent Calc Removing Excel Sheet Security?

Discuss the spreadsheet application
Post Reply
jimf500
Posts: 1
Joined: Sun Oct 10, 2010 5:51 pm

Prevent Calc Removing Excel Sheet Security?

Post by jimf500 »

I have an Excel spread sheet with protected cells that require a password to access. When I open the spread sheet in Calc, it lets me remove all security. Is there a way to protect cells and prevent Calc from allowing the security to be removed?

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases your chances of a reply. (TheGurkha, Moderator)
Open Office 3.2.1 on Windows XP
User avatar
Zizi64
Volunteer
Posts: 11360
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Prevent Calc Removing Excel Sheet Security?

Post by Zizi64 »

If possible, do not save your work .xls format. Use the ISO standard ODF formats.
"ISO / IEC 26300:2006 Open Document Format for Office Applications (OpenDocument) v1.0"
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Post Reply