Opening an Excel file with OpenOffice?

[joedom111]

Can this be done? What about other MS Office files? I admit I didn't spend much time looking for a solution, but I'm a Cisco guy, and I'm only helping someone out. Any replies would be greatly appreciated.

 

[iSeriesCodePoet]

Yes, you can. Also Word and PowerPoint. You can read and save as these three as well.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[joedom111]

I've been told that, but when I go to open a file such as an EXCEL file, I'm told that there is no program associated with this file, and asks me to associate it....but I don't know what to use to open all MS Office file types.
Can you help me out with setting this up?
Thanks

 

[jrjuiliano]

Originally when you install Open Office it should have given you an option to associate files with Open Office (i.e., all MS Excel, Word and Power Point). You might want to consider running your installation again.

At any rate, you can also just open up the spreadsheet prog and open the Excel file directly, or you can associate the program with :: "C:\Program Files\OpenOffice.org1.1\program\soffice.exe" -calc :: (as is written in the properties for the start menu shortcut.

J.R.

 

[iSeriesCodePoet]

If you are using the latest version, on install it asks if you want OpenOffice to be the defualt.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[joedom111]

I wish I could re-install it, but we just opened this call center and I have 30 new employees already working.....I don't want to get into re-installing....so I can just associate the files by opening the spreadsheet program in Open Office?

 

[iSeriesCodePoet]

What version are you using? One of us can take a look.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[joedom111]

I'll let you know first thing in the AM.
By the way Poet, thanks for the laugh with 15 Things to do while at Wal-Mart. I laughed hard while reading that.

 

[joedom111]

The version we're running is 1.1.0.

 

[TonyGroves]

If you have OpenOffice.org installed and opening an MS Office file doesn't call up OpenOffice.org, then you could try the following.

First, copy and paste the following text (between and not including the dashed lines) into a file with a .reg extension (lets call it freedom.reg).

----------------------------------
REGEDIT4

[HKEY_CLASSES_ROOT\.doc]
@="soffice6.doc"

[HKEY_CLASSES_ROOT\.DOT]
@="soffice6.dot"

[HKEY_CLASSES_ROOT\.POT]
@="soffice6.pot"

[HKEY_CLASSES_ROOT\.pps]
@="soffice6.pps"

[HKEY_CLASSES_ROOT\.PPT]
@="soffice6.ppt"

[HKEY_CLASSES_ROOT\.rtf]
@="soffice6.rtf"

[HKEY_CLASSES_ROOT\.XLS]
@="soffice6.xls"

[HKEY_CLASSES_ROOT\.XLT]
@="soffice6.xlt"
------------------------------------

Then, on one machine, do a backup of the registry (just to be safe), then double-click freedom.reg, which will merge the file into the registry (it only takes a second). Then test to see that when you open an MS Office file, it opens in OpenOffice.org. If you are happy, then you can do the same thing on all of your machines.

 

[TonyGroves]

Re my previous message, it only applies to Windows (any 32-bit variety).