Openoffice Calc set password

Discuss the spreadsheet application
Post Reply
rire
Posts: 1
Joined: Mon Jan 14, 2008 6:46 am

Openoffice Calc set password

Post by rire »

Hello all,
how can i set the password in open office if i need save the file to xls format ?
i know if i save the file to ods format it able for me to create password.

Thanks
User avatar
probe1
Volunteer
Posts: 277
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand

Re: Openoffice Calc set password

Post by probe1 »

please think it over:
a file in format xls saved with password opens in OOo without asking for it....

recommendation: use a ZIP utility to password protect or encrypt the file
Cheers
Winfried

DateTime2 extension: insert date, time or timestamp, formatted to your needs
marcosramos
Posts: 40
Joined: Tue Jan 08, 2008 10:35 am

Re: Openoffice Calc set password

Post by marcosramos »

That is NOT a solution...
work: OpenOffice 2.4 - Windows XP
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: Openoffice Calc set password

Post by kingfisher »

That's all you can do. OpenOffice developers have reversed engineered the .xls document structure so that you can open .xls documents and even save documents as .xls. They have not been able to duplicate the .xls password setting technique.

M$ Office cannot even open an .ods document. When you are crossing from one structure to another, you cannot expect exact duplication.

BTW, anecdotal evidence is that password setting in OO is hazardous. There has been a significant number of reports of data being lost when an encrypted document becomes corrupted.
Apache OpenOffice 4.1.9 on Linux
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Openoffice Calc set password

Post by Hagar Delest »

marcosramos wrote:That is NOT a solution...
You're right. Because MS Office format is hardly a format to be trusted. Specification are top secret, so how OOo could implement such interoperability?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Openoffice Calc set password

Post by Villeroy »

Some years ago I removed the passwords from dozends of Excel files (XL 97/2000). I loaded a file in a hex-editor and replaced the bytes at a certain position with a certain sequence of other bytes. The password protection was gone. I believe, Calc can open password "protected" xls by simply ignoring those bytes, but there is no way to create the right byte sequence for a given password. Password protected ODF is strongly encrypted. The encryption utilizes a public available algorithm, so other programs can encrypt and decrypt using a given password. Brute force password guessing is the only reasonable method to open a password protected ODF file when the password got lost.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
marcosramos
Posts: 40
Joined: Tue Jan 08, 2008 10:35 am

Re: Openoffice Calc set password

Post by marcosramos »

Of course _IF_ M$ gave the information about how the xls files are build those problems should be solved quickly.
Unfortunately as it seems, password settings in OO are also a risk.

Do you guys know if any of those points will be solved in one of the next OO versions? (2.4;3)
work: OpenOffice 2.4 - Windows XP
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista
Post Reply