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
Openoffice Calc set password
Re: Openoffice Calc set password
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
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
-
- Posts: 40
- Joined: Tue Jan 08, 2008 10:35 am
Re: Openoffice Calc set password
That is NOT a solution...
work: OpenOffice 2.4 - Windows XP
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista
- kingfisher
- Volunteer
- Posts: 2123
- Joined: Tue Nov 20, 2007 10:53 am
Re: Openoffice Calc set password
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.
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
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Openoffice Calc set password
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?marcosramos wrote:That is NOT a solution...
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Openoffice Calc set password
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 40
- Joined: Tue Jan 08, 2008 10:35 am
Re: Openoffice Calc set password
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)
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
desktop: OpenOffice 2.3.1 - Windows XP
laptop: Openoffice 2.3.1 - Vista