| View previous topic :: View next topic |
| Author |
Message |
tredmond
Newbie
Joined: 11 Mar 2005
Posts: 2
|
 Posted: Fri Mar 11, 2005 10:52 pm Post subject: Excel wks opens in writer/web instead of calc |
 |
|
| I have a excel wks that will not open in calc but keeps opening in writer/web |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2478
Location: Chonburi Thailand Asia
|
| Posted: Tue Mar 15, 2005 8:09 am Post subject: |
|
|
Whatever a WKS is:
I assume that you double click in Explorer on a file with *.wks extension.
Then your file association isn't correct.
Assign WKS to soffice/calc: c:\programs\openoffice\soffice -calc "%1"
or open the file with File->Open dialogue from OOo.
HTH (and works 
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
r_vinoya
Super User
Joined: 03 Dec 2003
Posts: 619
Location: Somewhere in the Philippines
|
| Posted: Tue Mar 15, 2005 5:15 pm Post subject: |
|
|
| probe1 wrote: | Whatever a WKS is:
I assume that you double click in Explorer on a file with *.wks extension.
Then your file association isn't correct.
Assign WKS to soffice/calc: c:\programs\openoffice\soffice -calc "%1"
or open the file with File->Open dialogue from OOo.
HTH (and works |
I think wks means "worksheet"... is this right? So the extension would be *.xls.
_________________
# : - ) |
|
| Back to top |
|
|
tredmond
Newbie
Joined: 11 Mar 2005
Posts: 2
|
| Posted: Tue Mar 15, 2005 9:10 pm Post subject: |
|
|
Yes, I was abbreviating and the the issue is a extension issue, as I have other .xls files that open just find. The issue is something with the fact that the file is being downloaded from the web.
Thanks |
|
| Back to top |
|
|
Colorado6202
General User
Joined: 27 Sep 2004
Posts: 22
|
| Posted: Wed Mar 16, 2005 8:54 am Post subject: |
|
|
| .wks was the file name extension for spreadsheets created with early versions of Lotus 1-2-3 under DOS. Excel can read these and then save as native Excel files, which you can then import into OOoCalc. Lotus later went to .wk1 and .wk3 files, which you can do the same thing with. |
|
| Back to top |
|
|
rbauer
Newbie
Joined: 24 Mar 2005
Posts: 1
|
| Posted: Thu Mar 24, 2005 9:35 am Post subject: |
|
|
I can confirm this behavior - it happens to me with excel files saved in what looks like xml format. I can open/view these files in notepad and it's human-readable, not the typical gibberish you would see with xls files. Anyway, OOo 1.9.79 (2.0 beta) wants to open this in Writer/Web. It makes no difference if I double-click the file in explorer, or use File->Open in Calc.
For reference, here are the first few lines from the xls file, as they appear in notepad:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11"> |
|
| Back to top |
|
|
edb_gene
Newbie
Joined: 18 Sep 2004
Posts: 2
Location: Bergen, NORWAY
|
| Posted: Sun Oct 23, 2005 9:22 am Post subject: |
|
|
| rbauer wrote: | ...Anyway, OOo 1.9.79 (2.0 beta) wants to open this in Writer/Web. It makes no difference if I double-click the file in explorer, or use File->Open in Calc.
For reference, here are the first few lines from the xls file, as they appear in notepad:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
...
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11"> |
Ah the same problem in OOo 2.0. The file you have is a Microsoft Office XP Excel 2003 file which is Microsoft's own 'SpreadSheetML' format.
If you install the (Optional) XSLT Sample filters, you will be able to export something similar. (Save As... Microsoft Excel 2003 XML)
OOo 2.0 should also be able to read the format, and it does read it's own 'Save as' file, but I've been having problems with a very simple MS-SpreadSheetML .XLS file generated my MySQL Query Browser.
I'm searching the forums for others that have seen this problem, before raising an Issue. |
|
| Back to top |
|
|
lightsup55
Power User
Joined: 24 Jun 2005
Posts: 91
Location: Maryland, USA
|
| Posted: Wed Oct 26, 2005 3:26 pm Post subject: |
|
|
| edb_gene wrote: | | Microsoft Office XP Excel 2003 |
Kinda like saying "Windows PC Macintosh"?
Microsoft Office XP does not include Microsoft Excel 2003.
Microsoft Office XP does include Microsoft Excel 2002 (a.k.a. Microsoft Excel XP).
So...
Don't you mean Microsoft Excel 2003 (a.k.a. Microsoft Office Excel 2003)?
_________________
 |
|
| Back to top |
|
|
foxcole
Super User
Joined: 19 Jan 2006
Posts: 2771
Location: Minneapolis, Minnesota
|
| Posted: Mon Oct 29, 2007 10:54 am Post subject: |
|
|
| edb_gene wrote: | If you install the (Optional) XSLT Sample filters, you will be able to export something similar. (Save As... Microsoft Excel 2003 XML)
OOo 2.0 should also be able to read the format, and it does read it's own 'Save as' file, but I've been having problems with a very simple MS-SpreadSheetML .XLS file generated my MySQL Query Browser.
I'm searching the forums for others that have seen this problem, before raising an Issue. |
Where does one find those XSLT filters?
I'm a relatively seasoned Writer user but have hardly touched Calc. Now I find I need it for a project (but can get Excel 2003 if I must)... working with xls files exported from a server-side application called InfoSource. That program generates pivot table reports that can be exported to a local Excel file (I exported it as formatted because I wanted to see if it would retain the pivot table, or DataPilot aspect, but it doesn't), and of course it exports with the <HTML> tag, so Writer for Web grabs it right away. That means I'm confirming it happens in 2.3 as well.
I guess I have two problems in all this. The first is whether it's possible to export a pivot table from Excel 2003 to Calc's DataPilot (assuming, of course, that I can create a pivot table file from the server application), and the second is whether Calc can open an xls file or whether I'd have to export it from Excel in a different format.... if i can do that and still keep the pivot table alive.
_________________
Cheers!
---Fox
WinXP Pro SP2, OOo Portable 2.3.1, OOo local 2.4 RC4
New OpenOffice forum: http://user.services.openoffice.org/en/forum/
Manuals: http://documentation.openoffice.org/manuals/index.html |
|
| Back to top |
|
|
|
