Calc opens Excel password-protected files without a password prompt

We have password-protected Excel files that LibreOffice will open (in read-only) without a password prompt. When you hit the Edit File button, it removes the read-only status, but the file still cannot be edited. Is there a way for LibreOffice to honor the password protection so random users cannot view files they aren’t supposed to?

We have a mix of LibreOffice versions, most are 3.5-3.6.

Thanks for your help!

What is the program used to save the password-protected file?

You can very reliably protect your workbooks, if you keep them in their native format of LibreOffice (ODF). So reliably protect it that will not be able to open them, if you forget the password.

Timon,

When I hit Edit File button, I get the following message in a pop-up: “Readonly content cannot be changed. No modifications will be accepted.” I don’t get any opportunity to type in a password.

mariosv: the files were originally created in Excel.

JohnSUN: we are in a typical office env where we started off in MS Office, and are now supplementing with LO. Using native ODF format is not an option because the MS Off installs (mix of 2007 and 2010 versions) may have issues reading ODF fully plus no one wants to convert all those file formats.

“because the MS Off installs…” “may have issues reading ODF…” “no one wants…” Excuse me, but do you really think that is it troubles of LibO?!!

LO strives for full backward compatibility with MSO. I’m trying to find a solution that works in our environment not start a debate on whose problem it is.

Yes, I don’t want start debate too.Your question was about “random users cannot view files they aren’t supposed to”.LO is one of many programs that ignores password protection of XLS-files. Therefore, your problem has no solution: if you teach LO ask for the password, the attacker could use another

I’ve come across an Excel document whose password prompt does work in LO so I know it should work. I need to figure out why some are working and some aren’t. It may be the ones that don’t work were originally made in Office 2003, which we no longer have any machines with.

Even MSO have not full compatibility through their versions. And please this is not a for free support service. People here are pleased to help between users. Take a look if you can disable read-only through Menu/File/Properties/Security.

Is it really xls file format or it is xlsx? If xlsx, then try to save as… xls and then try again to hit Edit File button. Something changed?

After you hit “Edit File button” are you prompted to enter password for edit mode?

MS Office 2010 password-protected files seem to work great with LibreOffice, so we’re going to recreate the problem documents in MSO 2010. It appears the problem files were created in MS Office versions earlier than 2010.

mariosv, I’m totally confused by your comment “And please this is not a for free support service.” To me help=support. Doesn’t matter now as it is not relevant to the answer.

edit: I cannot accept my own answer as the best answer because I don’t have the requisite point total. Hopefully I do not keep getting reminder emails to Accept the Best Answer when I cannot do so.

second edit: I keep getting emails from this site asking me to accept the best answer, but my own answer is the best answer and I cannot select my own answer because I don’t have enough “points” according to the site. Can someone stop this madness? I don’t need to keep getting nag emails from this site for something that is beyond my control.