Password protected XLS file not opening in LibreOffice, but works fine in MS Excel or Numbers

Password protected XLS file not opening in LibreOffice, it promts “The password is incorrect. The file cannot be opened.” Attached sample file exported from Numbers in XLS format with password “000”
testfile.xls (8 KB)

I just tried it in my portable AOO 4.1.13 version…
This error message is appeared instead of a password input window:
PasswordCompatibility

1 Like

Hi @Zizi64 , thanks for checking. After do some search on you error message from AOO 4 and found that LibreOffice can’t open the file encrypted using CryptoAPI encryption method, if xls file used binaryRC4 encryption method, then XLS file opened without any issue. Tried in LibreOffice 7 and AOO 4

Gnumeric tries to open the file but does not accept the password as valid.

Old BIFF binary .xls with “RSA and AES Cryptographic Provider” isn’t supported. Store in OOXML .xlsx instead.

1 Like