Unable to open Password Protected .xlsx

Discuss the spreadsheet application
Post Reply
ChaosTheory
Posts: 4
Joined: Tue Oct 12, 2010 2:44 am

Unable to open Password Protected .xlsx

Post by ChaosTheory »

I recently switched to OpenOffice 3.2 on my home computer (along with Ubuntu 10.10) and am unable to open a Excel 2010 (xlsx) file that is password protected. The file was created on a Win7 system and I was able to open it fine before I put the password protection on it.

Now when I try to open it I get a dialog box - "Filter Selection". I have tried a few obvious choices with the following results:

MS Excel 5.0 - Unknown or Unsupported Excel file format
MS Excel 97/2000/XP - Unknown or Unsupported Excel file format
MS Excel 95 - Unknown or Unsupported Excel file format
MS Excel 2007 Binary - General Error. General input/output error
MS Excel 2007 XML - General Error. General input/output error
MS Excel 2003 XML - A blank workbook opens
ODF Spreadsheet - General Error. General input/output error

The only thing I can find when searching for this is that it was supposed to be resolved long ago, what am I missing?

Thanks!
OpenOffice 3.2 on Ubuntu 10.10
ChaosTheory
Posts: 4
Joined: Tue Oct 12, 2010 2:44 am

Re: Unable to open Password Protected .xlsx

Post by ChaosTheory »

Just tried opening it in Excel, opens just fine, password protected.
OpenOffice 3.2 on Ubuntu 10.10
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Unable to open Password Protected .xlsx

Post by Hagar Delest »

Do you still have the possibility to create another file to be uploaded here so that we can check? Beware that OOXML is not really an open format. Better avoid it. Some links in the first sticky of the Beginner section.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Unable to open Password Protected .xlsx

Post by MrProgrammer »

Since this is a "user assistance" forum (no development staff), we can't "fix" anything here, though there are other parts of openoffice.org for reporting bugs. Are there a lot of these password protected XLSX files? If not, open in Excel and then save without the password. Open that in Calc and save in ODS format, adding a password if desired. I realize this is less convenient than if OOo just opened the file, but it would serve as a workaround. (Recent versions of Excel are supposed to be able to open ODS files if the file must be usable from either product.)
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
ChaosTheory
Posts: 4
Joined: Tue Oct 12, 2010 2:44 am

Re: Unable to open Password Protected .xlsx

Post by ChaosTheory »

Hagar de l'Est wrote:Do you still have the possibility to create another file to be uploaded here so that we can check? Beware that OOXML is not really an open format. Better avoid it. Some links in the first sticky of the Beginner section.
Thanks for the info, didn't realize xlsx was an attempt at an open format, but after reading the post you directed me to I will probably just stick with the xls format and that may solve my problem :D As for the creation of another file I would love to do all I can to help anyone else that may not have a choice in the matter, so are you just wanting a copy of the file in question? It is a time sheet, so I will have to delete some of the content if that has any bearing on the situation.

MrProgrammer wrote:Since this is a "user assistance" forum (no development staff), we can't "fix" anything here, though there are other parts of openoffice.org for reporting bugs. Are there a lot of these password protected XLSX files? If not, open in Excel and then save without the password. Open that in Calc and save in ODS format, adding a password if desired. I realize this is less convenient than if OOo just opened the file, but it would serve as a workaround. (Recent versions of Excel are supposed to be able to open ODS files if the file must be usable from either product.)
I was figuring that it was most likely I was doing something wrong, so I wasn't seeking a fix, but user assistance on what I was supposed to be doing :) It is just a single file, so I can do that quite easily. I did sucessfully open an ODF copy of the file (accidentally saved it as ODF without realizing it) and was able to open it in Excel, but it wasn't password protected at that point. I may try starting with saving it as xls to see if that is workable (since the majority of the time access will be from Excel) unless there some advantage to the ODF file format (other than the open source nature of it).

Thanks again guys!
OpenOffice 3.2 on Ubuntu 10.10
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Unable to open Password Protected .xlsx

Post by Hagar Delest »

A copy if the file is fine. Remove any personal data.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
ChaosTheory
Posts: 4
Joined: Tue Oct 12, 2010 2:44 am

Re: Unable to open Password Protected .xlsx

Post by ChaosTheory »

Here is a copy of the password protected file. I deleted all but one sheet and removed all information, password to open it is "OOTest"

Thanks.
Attachments
Time Sheet.xlsx
Password protected Excel file
(79 KiB) Downloaded 1077 times
OpenOffice 3.2 on Ubuntu 10.10
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Unable to open Password Protected .xlsx

Post by Hagar Delest »

No way to open it with 3.2.1 or 3.3-dev (both vanilla versions) under xubuntu 10.10.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Earthsea
Posts: 2
Joined: Mon Apr 25, 2011 11:30 pm

Re: Unable to open Password Protected .xlsx

Post by Earthsea »

For what it's worth I can confirm this problem: OpenOffice 3.2 on Ubuntu 10.10 cannot open a .XLSX file created with Office 2010 on Windows XP Pro.

HTH
Earthsea
Open Office 3.2 on Ubuntu 10.10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Unable to open Password Protected .xlsx

Post by RoryOF »

In general, leaving aside password protection difficulties, it is best to pass files to and from MS Office in .doc and .xls formats, rather than .docx and .xlsx. Password protection adds a further layer of worms on top of the can of worms the .???x formats introduce. If I were worried about others accessing my personal files I would _not_ password. Instead I would work to my own USB hard disk (note: not USB key), which I would carry with me, after observing the correct USB device removal protocol from the host machines.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Earthsea
Posts: 2
Joined: Mon Apr 25, 2011 11:30 pm

Re: Unable to open Password Protected .xlsx

Post by Earthsea »

Dear RoryOF,

Fair enough. I am new to Ubuntu and OO so thanks for the feedback. (I only started using the .???X files because my colleagues started using Office 2007 and 2010).

One question: why do you distinguish between USB disks and flash drives? Your comment intrigues me.

Thanks,
Earthsea
Open Office 3.2 on Ubuntu 10.10
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Unable to open Password Protected .xlsx

Post by RoryOF »

It is now beginning to be realised that the life of USB sticks is limited; in many cases they fail suddenly after a relatively short number of read/write cycles. Google will throw up examples: here is one; there are others
http://ask-leo.com/can_a_usb_thumbdrive_wear_out.html

On this forum there are frequent reports of data-loss on writing to USB sticks; whether this is due to failure of the stick or improper USB removal discipline or a bug in OpenOffice or overloaded interrupt usage on the computer is not clear, but on the forum our recommendation is that one should not work direct to a stick; one should work to the internal HD and then transfer the file to the stick. USB disk drives seem more stable, but it is still _essential_ that one observe the correct removal procedure (and don't rush it! take a few extra seconds to let it finish - this is quicker than rewriting a file from scratch!)
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply