[Solved] Unchanged password not accepted

Discuss the spreadsheet application

[Solved] Unchanged password not accepted

Postby Guzziman » Fri Jan 22, 2016 5:01 pm

running aoo v4.1.2 on mac osx el capitan v10.11.2

i attempted to open a password protected spreadsheet file but was met with the message "password is incorrect. the file cannot be opened." I use this file just about every day. The password has not been changed. Any ideas?
Last edited by Guzziman on Sat Jan 23, 2016 4:14 pm, edited 1 time in total.
OpenOffice v4.1.2
Operating System:Mac OSX El Capitan v10.11.2
Guzziman
 
Posts: 3
Joined: Fri Jan 22, 2016 4:26 pm

Re: unchanged password not accepted

Postby FJCC » Fri Jan 22, 2016 7:56 pm

This appears to be related to a bug: https://bz.apache.org/ooo/show_bug.cgi?id=125431. I have skimmed through the many messages on bugzilla but didn't see a clear description of how to repair the problem. I will ask on the dev mailing list for a recommendation.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7190
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Unchanged password not accepted

Postby MrProgrammer » Sat Jan 23, 2016 4:25 am

Guzziman wrote:Any ideas?
Try LibreOffice, at least until a patch becomes available for Open Office, perhaps in release 4.1.3. The release notes and the bug report will say whether the bug is fixed.

if you prefer to stay with your current software, see if the problem remains when you use your Mac's guest account ( → System Preferences → Accounts → Guest Account → Allow guests to log in). The bug report suggests that it could be due to a setting in the Firefox & Thunderbird profiles, so starting Open Office in the guest account (and not starting Firefox or Thunderbird there) might allow you to open the file with your password. If that works, you will want to save a copy of the document with password protection removed. Keep in mind that all of Guest's files are deleted when you sign off, so you'll need to save or copy it elsewhere, perhaps in your primary account's Drop Box (see Finder → Help → type Drop Box in the search field).

Then use other methods to protect the data until a patch becomes available. If it were me, i'd save the document in an encrypted read/write disk image. Read about that in Finder → Help → type Disk Image in the search field → Show all help topics. Of course you should test that you can open the encrypted disk image before deleting the unprotected document since it would be unwise to assume that it will be possible to open the image without the correct password.

You could also protect the data by saving the unprotected document on a removable external disk drive, perhaps a USB drive, taking care to follow correct protocol for device removal. Then keep the external drive in a locked cabinet. If the data is valuable, you should use two (or more) external disk drives to help ensure that it is not lost.

For more ideas, see Search found many matches: +password, which would have gotten you some immediate answers without waiting for a reply from us.
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3739
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Unchanged password not accepted

Postby Guzziman » Sat Jan 23, 2016 5:24 am

Thanks for the suggestions and for taking the time to look into this. I'll be following up on your ideas and will post results when they are available.
OpenOffice v4.1.2
Operating System:Mac OSX El Capitan v10.11.2
Guzziman
 
Posts: 3
Joined: Fri Jan 22, 2016 4:26 pm

Re: Unchanged password not accepted

Postby Guzziman » Sat Jan 23, 2016 4:13 pm

Was able to work around the problem by using the guest account to create a copy of the file without a password and saving it offline. Looking into using LibreOffice. Thanks for your help.
OpenOffice v4.1.2
Operating System:Mac OSX El Capitan v10.11.2
Guzziman
 
Posts: 3
Joined: Fri Jan 22, 2016 4:26 pm

Re: Unchanged password not accepted - CLOSED

Postby RoryOF » Sat Jan 23, 2016 4:36 pm

I understand that using the Guest account will open the file in many cases. Also that it is important not to use Mozilla/ (Firefox) or Thunderbird on the guest account before trying to open the file. As Guest account files are erased when the guest account is exited, it is also important to Save the file in unpassworded form to external media before exiting the guest account. Observe USB removal protocols.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29043
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Unchanged password not accepted

Postby dgstarwalker » Wed Feb 01, 2017 8:24 pm

Just out of curiosity, I tried opening the same password protected files which are stored on two different external hard drives--none would open.

Leads me to think it's something with open office being corrupted, not the files.
NeoOffice 2.2.3 with MacOS 10.4
dgstarwalker
 
Posts: 4
Joined: Tue Jan 17, 2017 5:04 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 41 guests