Openoffice Calc set password

Discuss the spreadsheet application

Openoffice Calc set password

Postby rire » Mon Jan 14, 2008 6:56 am

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
rire
 
Posts: 1
Joined: Mon Jan 14, 2008 6:46 am

Re: Openoffice Calc set password

Postby probe1 » Mon Jan 14, 2008 7:44 am

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
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs
User avatar
probe1
 
Posts: 237
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand Asia

Re: Openoffice Calc set password

Postby marcosramos » Thu Jan 17, 2008 10:15 am

That is NOT a solution...
work: OpenOffice 2.4 - Windows XP
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista
marcosramos
 
Posts: 40
Joined: Tue Jan 08, 2008 10:35 am

Re: Openoffice Calc set password

Postby kingfisher » Thu Jan 17, 2008 10:53 am

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.
OpenOffice 3.3 on PCLinuxOS. There are 3 kinds of people: those who can count and those who can't.
User avatar
kingfisher
Volunteer
 
Posts: 1860
Joined: Tue Nov 20, 2007 10:53 am

Re: Openoffice Calc set password

Postby Hagar Delest » Thu Jan 17, 2008 10:04 pm

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?
AOO 4.0.1 on Windows 7 and Xubuntu 13.10 (Saucy Salamander)
User avatar
Hagar Delest
Moderator
 
Posts: 25071
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Openoffice Calc set password

Postby Villeroy » Thu Jan 17, 2008 10:34 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17243
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Openoffice Calc set password

Postby marcosramos » Tue Mar 04, 2008 9:12 pm

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
marcosramos
 
Posts: 40
Joined: Tue Jan 08, 2008 10:35 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 28 guests