[Solved] 2.3 won't open .ods file

Discuss the spreadsheet application
Post Reply
ObiWanBenDover
Posts: 5
Joined: Sun Dec 02, 2007 8:37 am

[Solved] 2.3 won't open .ods file

Post by ObiWanBenDover »

I've upgraded to OO 2.3. When I click on a .ods spreadsheet created with an earlier version of OO I get a message that says the file may pose a security risk and instructs me to rename the file using the correct extension for 'ODS SPREADSHEET'. What is the correct extension for an OpenOffice 2.3 spreadsheet?
Last edited by Hagar Delest on Mon Jun 09, 2008 5:16 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
User avatar
Hagar Delest
Moderator
Posts: 33629
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: 2.3 won't open .ods file

Post by Hagar Delest »

It is .ods !

Is there any macro inside ? Do you manage to open the file anyway ?

NB: I've moved your thread to the Calc forum.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
ObiWanBenDover
Posts: 5
Joined: Sun Dec 02, 2007 8:37 am

Re: 2.3 won't open .ods file

Post by ObiWanBenDover »

There are no macros in the spreadsheet. I am able to open the file by right clicking on the desktop icon and using "open with OpenOffice Spreadsheet"
User avatar
Hagar Delest
Moderator
Posts: 33629
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: 2.3 won't open .ods file

Post by Hagar Delest »

Perhaps you've lost your file association. Try that : ERROR:Document does not exist.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
ObiWanBenDover
Posts: 5
Joined: Sun Dec 02, 2007 8:37 am

Re: 2.3 won't open .ods file

Post by ObiWanBenDover »

I'm using Ubuntu 7.10 and the icon properties are set to "open with OpenOffice.org Spreadsheet'.
File name is Portfolio.ods
The full text of the error message that I receive is:

"Cannot open Portfolio.ods

The filename "Portfolio.ods" indicates that this file is of type "ods document". The contents of the file indicate that the file is of type "ODS spreadsheet". If you open this file, the file might present a security risk to your system.

Do not open the file unless you created the file yourself, or received the file from a trusted source. To open the file, rename the file to the correct extension for "ODS spreadsheet", then open the file normally. Alternatively, use the Open With menu to choose a specific application for the file."
User avatar
Hagar Delest
Moderator
Posts: 33629
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: 2.3 won't open .ods file

Post by Hagar Delest »

If you right click on a .ods file then Properties and go to the Open with tab, select OOo 2.3 and see if that helps.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE 7 Gigi) and 25.2 portable on Windows 11.
ObiWanBenDover
Posts: 5
Joined: Sun Dec 02, 2007 8:37 am

Re: 2.3 won't open .ods file

Post by ObiWanBenDover »

The properties are already set for 'OpenOffice.org Spreadsheet'. Another alternative that doesn't work is 'OpenOffice.org' .
Properties would not accept OpenOffice.org 2.3; it said it couldn't find the program.
ObiWanBenDover
Posts: 5
Joined: Sun Dec 02, 2007 8:37 am

Re: 2.3 won't open .ods file

Post by ObiWanBenDover »

I think I have it solved. Apparently the problem was with the Portfolio part of the filename Portfolio.ods. 'Portfolio' might be a reserved word for an OO document. After I renamed the file to 'Testname.ods, the file opens perfectly by clicking on the icon.
Post Reply