Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Open Office documents
I have several spreadsheets which I have created in Open Office environment.
Now my employer got me Excel Office 2007 and I'm supposed to convert all these open office documents into Excel . What would be the best way to save my Open Office document so that it would be working ok in Excel ????? Thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Open Office documents
Hi,
You can open OpenOffice spreadsheet files directly from Excel 2007. After you do that you should choose Office Button, Save As, and save them as an Excel 2007 workbook. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Sam" wrote: I have several spreadsheets which I have created in Open Office environment. Now my employer got me Excel Office 2007 and I'm supposed to convert all these open office documents into Excel . What would be the best way to save my Open Office document so that it would be working ok in Excel ????? Thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Open Office documents
Hi Sam
This was copied from OpenOffice website, you may get more information on that website. Microsoft Office interoperability In response to Microsoft's recent movement towards using the Office Open XML format in Microsoft Office 2007, Novell released an Office Open XML converter for OOo under a liberal BSD license (along with GNU GPL and LGPL licensed libraries), that will be submitted for inclusion into the OpenOffice.org project. This allows OOo to read and write Microsoft OpenXML-formatted word processing documents (.docx) in OpenOffice.org. Currently it works only with the latest Novell edition of OpenOffice.org. Sun Microsystems has developed an ODF plugin for Microsoft Office which enables users of Microsoft Office Word, Excel and PowerPoint to read and write ODF documents. The plugin currently works with Microsoft Office 2003, Microsoft Office XP and Microsoft Office 2000. Support for Microsoft Office 2007 is only available in combination with Microsoft Office 2007 SP1. Several software companies (including Microsoft and Novell) are working on an add-in for Microsoft Office that allows reading and writing ODF files. It presently only works for Microsoft Word 2007 / XP / 2003. Microsoft provides a compatibility pack to read and write Office Open XML files with Office 2000, XP and 2003. The compatibility pack can also be used as a stand-alone converter with Microsoft Office 97. This might be helpful in converting older Microsoft Office files via Office Open XML to ODF if a direct conversion doesn't work as expected. However, the Office compatibility pack does not install for Office 2000 or Office XP on Windows 9x. Note that some office applications built with Microsoft components may refuse to import OpenOffice data. Simply Accounting, for example, can import Excel xls files, but refuses to accept OpenOffice xls files for the reason that the OO xls files are not "genuine Microsoft" xls files. HTH John "Sam" wrote in message ... I have several spreadsheets which I have created in Open Office environment. Now my employer got me Excel Office 2007 and I'm supposed to convert all these open office documents into Excel . What would be the best way to save my Open Office document so that it would be working ok in Excel ????? Thanks |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Open Office documents
"Shane Devenshire" wrote in message ... Hi, You can open OpenOffice spreadsheet files directly from Excel 2007. Err yes. And Excel 2007 strips ALL the formulae out....... The only way to open an OO Spreadsheet with all the formulae intact in Excel 2007 is to download and install the Sun ODF plug-in for Office. Then in Excel 2007 click on the Add ins tab and in the Custom Toolbar section (NOT the Menu Commands Section) click on "Import ODF". -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Open Office documents
"Sam" wrote in message ... I have several spreadsheets which I have created in Open Office environment. Now my employer got me Excel Office 2007 and I'm supposed to convert all these open office documents into Excel . What would be the best way to save my Open Office document so that it would be working ok in Excel ????? Thanks See my reply to Shane...... -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel in Office XP-Won't Open File from My Documents | Excel Discussion (Misc queries) | |||
Convertion of Star Office documents to Microsoft Office | Excel Discussion (Misc queries) | |||
Search through open office documents | Excel Discussion (Misc queries) | |||
Can't open documents at home - Microsoft Office 2003 | Charts and Charting in Excel | |||
can't open weblinks in office 200 documents | Excel Discussion (Misc queries) |