OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

OO incorrectly claims .xls file is password protected
Goto page 1, 2  Next
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
mtunnell
Newbie
Newbie


Joined: 28 Jul 2003
Posts: 2

PostPosted: Mon Jul 28, 2003 2:39 pm    Post subject: OO incorrectly claims .xls file is password protected Reply with quote

I've recently begun having trouble opening certain spreadsheets created in Microsoft Excel. Open Office pops the following message box:
Error loading document.
file:// (it shows the path to the file)
Read-Error.
This file is password-protected.

However, the file is not password protected. Excel opens it just fine.

Any ideas?

Mark
Back to top
View user's profile Send private message Send e-mail
itmauritius
General User
General User


Joined: 27 Jul 2003
Posts: 8

PostPosted: Sat Aug 02, 2003 12:34 pm    Post subject: Reply with quote

Try clicking OK without entering any password. Your file might be damaged since my Impress presentation also had a password prob though I never placed a pswd on it
Back to top
View user's profile Send private message
DDJack59
General User
General User


Joined: 03 Aug 2003
Posts: 16
Location: Mt Airy, MD USA

PostPosted: Sun Aug 03, 2003 4:56 am    Post subject: Reply with quote

OpenOffice Calc will think that the whole file is password protected if the Excel user has 'protected' any part of the sheet, even if it is one single cell.

Regards,
--Doug
Back to top
View user's profile Send private message
The Liquidator
Super User
Super User


Joined: 27 Feb 2003
Posts: 1368
Location: Manchester, UK

PostPosted: Sun Aug 03, 2003 1:50 pm    Post subject: Reply with quote

If there are graphics in the spreadsheet that have been "locked" the password message you have referred to will also be seen and the file won't open.
Back to top
View user's profile Send private message
mtunnell
Newbie
Newbie


Joined: 28 Jul 2003
Posts: 2

PostPosted: Mon Aug 04, 2003 9:26 am    Post subject: OO opens password locked sheets, but not workbooks Reply with quote

Actually, you can lock sheets with Excel and OO will open the document fine. You can then unprotect the sheet even if it was password protected from Excel! However, if you protect the workbood in Excel, OO can't open it.

Mark
Back to top
View user's profile Send private message Send e-mail
Guest






PostPosted: Tue Oct 07, 2003 11:04 pm    Post subject: Re: OO incorrectly claims .xls file is password protected Reply with quote

mtunnell wrote:
I've recently begun having trouble opening certain spreadsheets created in Microsoft Excel. Open Office pops the following message box:
Error loading document.
file:// (it shows the path to the file)
Read-Error.
This file is password-protected.

However, the file is not password protected. Excel opens it just fine.

Any ideas?

Mark
Back to top
The Liquidator
Super User
Super User


Joined: 27 Feb 2003
Posts: 1368
Location: Manchester, UK

PostPosted: Wed Oct 08, 2003 12:17 am    Post subject: Reply with quote

If any part of the spreadsheet is "locked" it will be reported as password- protected. Typically this will apply to things like graphics. Are there any parts of the spreadsheet to which this applies?
Back to top
View user's profile Send private message
Guest






PostPosted: Mon Nov 03, 2003 11:54 am    Post subject: Re: OO opens password locked sheets, but not workbooks Reply with quote

mtunnell wrote:
Actually, you can lock sheets with Excel and OO will open the document fine. You can then unprotect the sheet even if it was password protected from Excel! However, if you protect the workbood in Excel, OO can't open it.

Mark
Back to top
Guest






PostPosted: Mon Nov 03, 2003 7:51 pm    Post subject: Reply with quote

I'm in the same boat, except I know the .xls file is locked and I have the password to open it. I just don't know where to type the password to get it to unlock the dang file. I just get an error message, no prompt to enter a password. Help?
Back to top
Guest_J
Guest





PostPosted: Sat Nov 08, 2003 9:42 pm    Post subject: Password protected excel file. Reply with quote

I am facing the same problem, I recently installed OO, and I have a lot of excel files that are password protected! OO can't open any of the files, if just gives me an error message. DO I need to instal excel and unlock All the files!

Is there any solution out there?

Regards,

Jad..
Back to top
dpeach
OOo Advocate
OOo Advocate


Joined: 06 Oct 2003
Posts: 397
Location: Mérida, Yucatán, México

PostPosted: Sat Nov 08, 2003 10:05 pm    Post subject: Reply with quote

I would assume that if the file was password protected through Excel, then you will have to have Excel to change or delete the password protection.

I have never used Excel and therefore know nothing about the password protection that you are talking about. But I would not see this as a fault of OOo if Excel was the program that you used to protect it.

Try opening in Excel and taking off the password and see if you can open it in OOo. I hope you get access to your excel files (pun inteded).

dpeach
Back to top
View user's profile Send private message
Gabor
Super User
Super User


Joined: 21 Sep 2003
Posts: 610
Location: Hungary (E-Europe)

PostPosted: Sun Nov 09, 2003 4:33 am    Post subject: Override Reply with quote

This is a terribly big problem for me to. Since it is usually not our own files we face real difficulties with opening but ones that were sent to us by others, the way of development should be to enable OOcalc to override Excel's any protection or ofering to open the tables without certatn features. Of course I know that it is easy to say, I am not a programmer. Maybe it is impossible. But it would be worth a try by experts, perhaps.
Back to top
View user's profile Send private message
Curtz
Super User
Super User


Joined: 19 Feb 2003
Posts: 554
Location: In vino veritas!

PostPosted: Sun Nov 09, 2003 11:47 am    Post subject: Reply with quote

I wouldnt blame OOo for this either. The MSO import/export filters in OOo are as good as reverse engeneering filters get. It would be nice if OOo could also open these procted files, but I don't know if there is a copyright issues involved here, but there sure are lots and lots and lots of work involved.
_________________
BR Curtz

OOo 2.0.4 on rock solid Windows 2000 (English, SP4)
Back to top
View user's profile Send private message
carpman
General User
General User


Joined: 23 Jul 2003
Posts: 15

PostPosted: Tue Nov 11, 2003 9:06 am    Post subject: Reply with quote

so how do we go about gewtting around this problem?

I am going to try opening such a file in gnumeric and see if that helps.
Back to top
View user's profile Send private message
fritzel67
Guest





PostPosted: Fri Dec 05, 2003 5:53 pm    Post subject: Solution to Password Protected MS Office Files Reply with quote

I don't know if a solution was ever found for this problem, but I noticed that if you remove the password from within MS Office, subsequently OpenOffice will be able to open the file.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group