| View previous topic :: View next topic |
| Author |
Message |
Ganapathi
Guest
|
 Posted: Wed Mar 03, 2004 2:28 am Post subject: Problem while openning excel file in openoffice |
 |
|
unable to open an excel file in openoffice. it is asking for ASCII filter options.
can any one help! |
|
| Back to top |
|
 |
antonbijl
OOo Advocate
Joined: 04 Aug 2003
Posts: 291
Location: Pretoria, South Africa
|
| Posted: Wed Mar 03, 2004 3:29 am Post subject: |
|
|
Can you provide some more details?
- Version of OOo?
- Version of Excel?
- Platform?
- How are you trying to open it at present? |
|
| Back to top |
|
|
tristang
Newbie
Joined: 26 Apr 2004
Posts: 2
Location: Melbourne, Australia
|
| Posted: Mon Apr 26, 2004 9:08 pm Post subject: |
|
|
I'm having exactly the same issues here.
The XLS file is from a German customer. It will not open in OO.org 1.1.1 on Windows but it will open in Microsoft Excel 2000. It comes up with the ASCII Filter Options dialog and wants to try and import it in to Writer and not Calc.
I can E-mail the XLS if anyone would be interested in solving this issue. |
|
| Back to top |
|
|
amerj
Power User
Joined: 13 Apr 2004
Posts: 69
Location: Zurich, Switzerland
|
| Posted: Tue Apr 27, 2004 3:37 am Post subject: Problem while openning excel file in openoffice |
|
|
Are these Excel files actually CSV files ?
In which please refer to recent postings about this ..... in short with File Open dialogue select CSV file type to get round OOo opening as Writer file.
_________________
/Jeremy |
|
| Back to top |
|
|
Guest
|
| Posted: Wed Apr 28, 2004 3:27 pm Post subject: Re: Problem while openning excel file in openoffice |
|
|
| amerj wrote: | | Are these Excel files actually CSV files? |
I may be a simple Aussie, but I'm not THAT simple!
It is definately an Excel file. I would post the file somewhere but it is an order spreadsheet that a customer has sent us. I can't edit the document and then save it because it'll save it in a format that is then readable by OOo (trying to get rid of Excel here). I'll happily E-mail it to an OOo dev that handles Excel import though. |
|
| Back to top |
|
|
amerj
Power User
Joined: 13 Apr 2004
Posts: 69
Location: Zurich, Switzerland
|
| Posted: Wed Apr 28, 2004 10:38 pm Post subject: Problem while openning excel file in openoffice |
|
|
No need to take it personally!
Just your symptoms were similar to ones I had when trying to import Excel CSV files.
_________________
/Jeremy |
|
| Back to top |
|
|
tristang
Newbie
Joined: 26 Apr 2004
Posts: 2
Location: Melbourne, Australia
|
| Posted: Wed Apr 28, 2004 10:52 pm Post subject: |
|
|
JK 
It is definately a binary file and it definately opens in Excel 2000. If I save it out of Excel again it will open in OpenOffice. But we don't want to be having to do this as we are attempting to replace Excel on any new desktops. |
|
| Back to top |
|
|
|
