| View previous topic :: View next topic |
| Author |
Message |
Corrie
General User
Joined: 16 Dec 2005
Posts: 24
Location: Canada
|
 Posted: Mon Feb 26, 2007 6:08 pm Post subject: file formats |
 |
|
I do not understand what file format to use in Calc. ods or xml. both are being called native formats. ods cannot be opened by Excel. Can Excel.xml be opened by the newer Excel? I have 2000 and could put in Excel XP pro.
what is the difference between ods and xml? |
|
| Back to top |
|
 |
AndrewZ
Moderator
Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA
|
| Posted: Mon Feb 26, 2007 9:25 pm Post subject: |
|
|
OpenOffice.org's native spreadsheet format is OpenDocument Spreadsheet (.ods). If you are sharing with Microsoft Office users, typically you want to send Microsoft Excel 97/2000/XP (.xls) which is a binary, non-XML format.
In general, I recommend not using the Microsoft Excel 2003 (.xml) format because few programs open it.
_________________
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* OpenOffice.org Ninja
* BleachBit
</signature> |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Tue Feb 27, 2007 2:38 am Post subject: Re: file formats |
|
|
| Corrie wrote: | I do not understand what file format to use in Calc. ods or xml. both are being called native formats. ods cannot be opened by Excel. Can Excel.xml be opened by the newer Excel? I have 2000 and could put in Excel XP pro.
what is the difference between ods and xml? |
To add AndrewZ's comments, Calc uses ods as its native format and it is probably best to always save in ods. When you have to share with an MS Office user just do a "Save As" and save as an xls format.
The rationale for this is that very occasionally saving into xls will mess up a file. If you are always saving in xls you don't have any recourse. If you have the file in ods you still have a functioning file that you can try to modify to work properly in Excel or at least that you can send as a PDF file.
Or if the Excel user is desperate enough he can install OOo himself. 
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Tue Feb 27, 2007 2:59 am Post subject: |
|
|
| Corrie wrote: | | ods or xml. both are being called native formats |
Is that correct? In my version .xml is described as a M$ format. I doubt that it has been adopted as an OOo format.
_________________
search forum by month |
|
| Back to top |
|
|
Corrie
General User
Joined: 16 Dec 2005
Posts: 24
Location: Canada
|
| Posted: Tue Feb 27, 2007 5:50 am Post subject: file format |
|
|
| thanks for all the help. I'm trying to wean from Excel 2002 xp pro. Excel however is easier and faster, but I have a great dislike for MS even apart from the price. Wish for an extra 'fat' box in the ready to use borders (do not want to learn styles and save defaults or templates, don't have a clue what that all is). The choices offered on do it yourself alignment are all in technical terms, I do not understand. Also a much easier to do simple arrow in one step, instead of making a line, then choose your arrow and usually it ends up on the wrong side. These are my only beefs, apart from the slow load, otherwise openoffice is beautiful and the larger icons looks much nicer than Excel's. |
|
| Back to top |
|
|
|
