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

How can I stop OOO2 opening a downloaded xls as html.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon Oct 03, 2005 4:50 am    Post subject: How can I stop OOO2 opening a downloaded xls as html. Reply with quote

I can do this inOOO1 and checked on a friends computer which uses excel -no trouble.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
DiGro
Super User
Super User


Joined: 02 Jun 2004
Posts: 1415
Location: Hoorn NH, The Netherlands

PostPosted: Mon Oct 03, 2005 7:37 am    Post subject: Reply with quote

Tools > Options > Load and Save > Microsoft Office

Or did you already check that ?

DiGro
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Tue Oct 04, 2005 6:50 am    Post subject: Reply with quote

yes I have excel to calc ticked
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Wed Oct 05, 2005 9:31 pm    Post subject: Reply with quote

Carl,

I have no answers, only a couple of questions. Forgive me if you've already considered and discarded them. I am assuming you're talking about xls files downloaded from somewhere on the net.

Is it only happening to one file?
Is it only happening on one site?
Have you tried a different site?

Perhaps you could paste a URL and someone here could have a go at opening the file(s) - if that is appropriate.

Where I'm heading with this is maybe it is a problem with the file (eg. a URL or HTML or some such in cell A1) and OO is responding by opening it as HTML. Or some smilarly bizarre issue with the site.

I'm currently at work therefore forced to use IE, every xls I can find opens as a spreadsheet in the IE window (or they're zipped). I saved one locally and OO opened it up fine ("Capital Budgeting Analysis" sheet from this page).

Edit
Just thought of something else: Have you tried opening the file(s) with OO 1.1.x?
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Thu Oct 06, 2005 6:57 am    Post subject: Reply with quote

Dale wrote:
Carl,

I have no answers, only a couple of questions. Forgive me if you've already considered and discarded them. I am assuming you're talking about xls files downloaded from somewhere on the net.

Is it only happening to one file?
Is it only happening on one site?
Have you tried a different site?

Perhaps you could paste a URL and someone here could have a go at opening the file(s) - if that is appropriate.

Where I'm heading with this is maybe it is a problem with the file (eg. a URL or HTML or some such in cell A1) and OO is responding by opening it as HTML. Or some smilarly bizarre issue with the site.

I'm currently at work therefore forced to use IE, every xls I can find opens as a spreadsheet in the IE window (or they're zipped). I saved one locally and OO opened it up fine ("Capital Budgeting Analysis" sheet from this page).

Edit
Just thought of something else: Have you tried opening the file(s) with OO 1.1.x?


Carl,
Just as a check I went to the file Dale references with Firefox and it opened automatically in OOo2.0.0 RC_1.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Fri Oct 07, 2005 7:48 am    Post subject: Reply with quote

Quote:
Is it only happening to one file?
Is it only happening on one site?
Have you tried a different site?


I have no trouble with other downloads and it works fine with ooo1etc. I noticed that in Excel it opened as an xls which I could work on too, but the format was a little more fancy in that the grid lines were not visible so that it looked better as a bank statement. I suspect taht the trigger for Html is in this formatting.

Quote:
Perhaps you could paste a URL and someone here could have a go at opening the file(s) - if that is appropriate.
well that is the problem its my bank account, which means I am stuck with the problem. Changing banks or not using OOO2 is too silly.

Quote:
Where I'm heading with this is maybe it is a problem with the file (eg. a URL or HTML or some such in cell A1) and OO is responding by opening it as HTML. Or some smilarly bizarre issue with the site.

I will explore this idea.
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Fri Oct 07, 2005 4:02 pm    Post subject: Reply with quote

carl wrote:
I have no trouble with other downloads and it works fine with ooo1etc. I noticed that in Excel it opened as an xls which I could work on too, but the format was a little more fancy in that the grid lines were not visible so that it looked better as a bank statement. I suspect taht the trigger for Html is in this formatting.
In case you don't know: Turning grid lines on/off is in Tools>Option, select View tab. I've got a vague idea it might be a setting for individual spreadsheets. So maybe no HTML there.

Quote:
well that is the problem its my bank account, which means I am stuck with the problem. Changing banks or not using OOO2 is too silly.
I see what you mean. Perhaps if you've access to another OOo2 installation you can take a copy of the problem spreadsheet and see if you can reproduce the problem.

This is all obvious stuff. I'm afraid I'm not being much help to you.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon Oct 10, 2005 2:53 am    Post subject: Reply with quote

I tried ne-nameing the xls as csv and opened in OOO2
and this was the first line:
<TABLE width=600 border=0 cellspacing=0 cellpadding=0><TR><TD><strong> Kontonummer xxxxxxx

BTW the csv opened identically in OOO1

To check I opened the unaltered xls in OOO2 and got the HTML version
and in OOO1 I got an easy to use xls
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
zaber
General User
General User


Joined: 13 Oct 2005
Posts: 6

PostPosted: Thu Oct 13, 2005 9:52 am    Post subject: Reply with quote

I am not sure if it has been resolved or not but we are having the same issue. The file in question is actually a HTML file with a .XLS extension. It will open in Excel and in the spreadsheet in OOo1, but in OOo2 it opens in the HTML editor. Is there any way to force it to be opened in the spreadsheet?
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Thu Oct 13, 2005 9:06 pm    Post subject: Reply with quote

The nice thing about Forums is that you are not alone!
Zaber , thanks for your much clearer explanation of our problem.

Now we just need an answer!
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
zaber
General User
General User


Joined: 13 Oct 2005
Posts: 6

PostPosted: Fri Oct 14, 2005 10:39 am    Post subject: More Information Reply with quote

I have some more information on this. The code to make this happen is from Microsoft to export a “data set” readable by Excel. I would guess we will see more of this issue as OOo2 becomes more heavily used.

Carl I don’t think we are anywhere near alone with this issue.
Back to top
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Mon Oct 24, 2005 3:30 pm    Post subject: Reply with quote

Carl,

Just in case you haven't seen it:
http://www.oooforum.org/forum/viewtopic.phtml?p=100269#100269

Edit
And this one
http://www.oooforum.org/forum/viewtopic.phtml?p=100286#100286
It looks like this behaviour is by design. (Choosing the application - Writer/Calc - based on content, not file extension)
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos
Back to top
View user's profile Send private message
carl
Super User
Super User


Joined: 21 Apr 2003
Posts: 920
Location: Germany

PostPosted: Mon Oct 24, 2005 10:13 pm    Post subject: Reply with quote

One of the many things that I like about OpenOffice is that the user is able to make his/her own decisions based on options that are visible in the various menus.
I am not able to deal with the MS "everything is possible ,but you have to be the programmer to know where to look" approach.

This problem shows that not all progress is an improvement! Crying or Very sad
_________________
carl
Using OpenOffice.org 2 on XP sp2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
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