Ask Your Question
0

How do I open a password protected XLS in Calc? (I have the password) [closed]

asked 2014-02-27 19:53:57 +0200

JoshuaFox gravatar image

updated 2015-09-10 10:48:22 +0200

Alex Kemp gravatar image

When I open an XLS file (I know the password), I get

Read-Error.
The encryption method used in this document is not supported. Only Microsoft Office 97/2000 compatible password encryption is supported

Is there some other tool (other than MSExcel) that will let me open the XLS and save it in a compatible format?

LO 4.1.2.3 on Ubuntu

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 16:52:03.176045

2 Answers

Sort by » oldest newest most voted
0

answered 2014-02-27 23:01:52 +0200

Pedro gravatar image

Maybe you can try Excel Online or Google Docs... However if the file contents is so sensitive that you bothered to password protect it, maybe uploading it to the "Cloud" is not so wise...

That is why it is better to use a file format (like ODS) that doesn't lock you to a single vendor (and in this case, absurdly to a specific version of the software...)

edit flag offensive delete link more

Comments

Thanks, I guess I can't test those out, then. I don't suppose there's a Ubuntu tool that does this?

JoshuaFox gravatar imageJoshuaFox ( 2014-02-28 09:34:16 +0200 )edit

@JoshuaFox, you can also try Gnumeric. It's a free open source spreadsheet from Gnome and it's available at the Ubuntu Sotware Center.

Pedro gravatar imagePedro ( 2014-02-28 17:01:10 +0200 )edit
0

answered 2014-03-01 13:49:44 +0200

L-user gravatar image

updated 2014-03-01 13:51:47 +0200

It looks like you got this document from your friend using Microsoft Excel. The document was encrypted using encrypted method that LibreOffice does not understand.

There is also free (as money) version of Microsoft Excel Viewer: https://www.microsoft.com/en-us/download/details.aspx?id=10 you can open and print a Excel document. Because you are on Ubuntu that means installing Wine and then inside Wine install this program. So from terminal:
(1) Install wine:

sudo apt-get install wine

(2) Download Excel Viewer from above web page.
(3) Install Microsoft Excel Viewer:

wine path_to_the_file/file_with_exe_extension



If you are exchanging sensitive files with your friends, you could also use encryption of some external program like OpenSSL, see details: https://stackoverflow.com/questions/16056135/how-to-use-openssl-to-crypt-decrypt-files - so creating spreadsheet file with Microsoft Office or LibreOffice and then encrypt document using openssl library.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-27 19:53:57 +0200

Seen: 6,107 times

Last updated: Mar 01 '14