Difference between revisions of "Documentation/UserGuide/Migration Guide/Sharing Files"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
== File formats ==
+
{{Documentation/MigrationTOC|Migration=block|PrevNext=block|Prev=Documentation/OOoAuthors User Manual/Migration Guide/Introduction|Next=Documentation/OOoAuthors User Manual/Migration Guide/Importing Files}}
This section gives a simplified overview of Apache OpenOffice’s file format.
+
{{DISPLAYTITLE:Sharing Files with Microsoft Office Users }}
 +
==Sharing in a Mixed application Environment==
 +
{{Note| Migration is people issue, not a software issue}}
 +
Most migration difficulties occur because of incompatibility issues.  No two document production applications will always have 100% fidelity, not even if those two applications are just different versions of the same programme. So one of the essential tasks in a successful migration is to identify infidelity risks and thus reduce user frustration.  Often the problems that occur are not actually caused by the migration but are areas that have always been problematic but it was easier for users to work around than complain.  Migration support desks will inevitably end up fielding calls that have nothing to do with the migration but has been a point of frustration for some time.
  
By default OpenOffice stores its files in Open Document Format ([http://en.wikipedia.org/wiki/OpenDocument ODF]), ISO/IEC 26300. For details about ODF, see [http://books.evc-cit.info/book.php http://books.evc-cit.info/book.php].
+
Many of these can be minimised by the adoption of some simple policies:
 +
#Ensure all computers in the organisation have the same font set. This is especially important where there is a variation in Operating systems
 +
#Put in place policies for document collaboration, for instance establish standard fonts for use in documents 
 +
#Make available a set of templates on the network that covers all document instances that there needs to be collaboration.
 +
#Ensure that all machines use the same default template
  
  
{| style="border-spacing:0;"
+
== File formats ==
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
+
This section gives a simplified overview of Apache OpenOffice’s file format.  
| style="border:none;padding:0.049cm;"| Some compression utilities only check the file extension and may not recognize the file as being compressed. To open an OpenOffice file with such a compression utility, you can rename the file to have the extension .zip.
+
  
|}
+
By default {{OOo}} stores its files in Open Document Format ([http://en.wikipedia.org/wiki/OpenDocument ODF]), ISO/IEC 26300.  For details about ODF, see [http://books.evc-cit.info/book.php here].
By contrast, Microsoft Office files are stored in a proprietary format which is not human readable and not publicly documented. This causes problems for software developers writing filters for importing and exporting in Microsoft Office formats.
+
  
<center>File extensions for OpenOffice 4.0. (OOo 1.1.x extensions are shown in brackets).</center>
+
Older versions of Microsoft Office files are stored in a proprietary format which is not human readable and not publicly documented. Newer versions of MS Office can now edit and save in ODF.  
  
 
+
{| border=1 style="border-collapse:collapse;" cellpadding=3
{| style="border-spacing:0;"
+
|+File extensions for {{OOo}} 4.0.
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''Document type'''</center>
+
! Document type
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''Application'''</center>
+
! Application
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''Extension'''</center>
+
! Extension
| style="border:0.05pt double #808080;padding:0.079cm;"| <center>'''MS Office equiv'''</center>
+
! MS Office equiv
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Text
+
| Text
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Writer
+
| Writer
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odt (sxw)
+
| odt
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| doc
+
| doc, docx
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Text Template
+
| Text Template
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Writer
+
| Writer
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| ott (stw)
+
| ott  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| dot
+
| dot
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Master Document
+
| Master Document  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Writer
+
| Writer
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odm (sxg)
+
| odm
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| doc
+
| doc, docx
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| HTML document
+
| HTML document
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Writer
+
| Writer
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| html
+
| html
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| html
+
| html
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Spreadsheet
+
| Spreadsheet  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Calc
+
| Calc
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| ods (sxc)
+
| ods
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| xls
+
| xls, xlsx
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Spreadsheet Template
+
| Spreadsheet Template
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Calc
+
| Calc
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| ots (stc)
+
| ots
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| xst
+
| xst
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Drawing
+
| Drawing  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Draw
+
| Draw
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odg (sxd)
+
| odg
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| N/A
+
| N/A
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Drawing Template
+
| Drawing Template
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Draw
+
| Draw
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| otg (std)
+
| otg  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| N/A
+
| N/A
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Presentation
+
| Presentation
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Impress
+
| Impress
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odp (sxi)
+
| odp
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| ppt
+
| ppt, pptx
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Presentation Template
+
| Presentation Template
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Impress
+
| Impress
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| otp (sti)
+
| otp
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| pot
+
| pot
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Formula
+
| Formula
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Math
+
| Math
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odf (sxm)
+
| odf
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| N/A
+
| N/A
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Chart
+
| Chart
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Chart
+
| Chart
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odc
+
| odc
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| N/A
+
| N/A
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Database
+
| Database
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Base
+
| Base
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| odb
+
| odb
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| mdb
+
| mdb
  
 
|}
 
|}
  
{| style="border-spacing:0;"
+
Although {{OOo}} can open Microsoft Office files. The reverse is ''not always'' true. Microsoft Office has various degrees of support for ODF, starting in Office 2007, but earlier versions: MSO '97, Office XP etc, are not able to open, read or write ODF documents. For this reason, it is essential, during Migration setup, to identify your document users and their needs to ensure the minimisation of compatibility issues. For example:
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
+
| style="border:none;padding:0.049cm;"| OpenOffice can open Microsoft Office files. The reverse is&nbsp;''not always''&nbsp;true: at this time, Microsoft Office has various degrees of support for ODF, starting in Office 2007.
+
  
If you need to send files to someone using Microsoft Office, save your file first in the native ODF format, then save it to one of the many supported Microsoft Office formats. By doing this, you ensure that even if the filter can not translate perfectly, you have your original in its native format.
+
*Internal usage -- Use Native file format (OD*)
 +
*External User Non AOO user - Editable  -- Save as *.doc (2000, XP)
 +
*External User AOO user - Editable -- Use Native file format (OD*)
 +
*External User - Editable not needed -- Use PDF.
 +
*Archive -- Always use ODF
  
OpenOffice can not open or convert Microsoft Access files (.mdb) files directly, however it can access the data in the tables using DAO and ODBC. See the&nbsp;[https://wiki.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Base_Guide Database Guide]&nbsp;for more information.
+
Identifying these User needs and getting staff to work within those parameters should be part of a pre Migration training programme.
  
|}
+
OpenOffice can not open or convert Microsoft Access files (.mdb) files directly, however it can access the data in the tables using DAO and ODBC. See the [[Documentation/OOoAuthors_User_Manual/Base_Guide|Database Guide]] for more information.}}
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=2 edit]]Bulk conversion ==
+
 
To use Apache OpenOffice to convert a lot of files, click&nbsp;'''File'''&nbsp;'''> Wizards > Document Converter'''.
+
== Bulk conversion ==
 +
To use {{OOo}} to convert a lot of files, click '''File''' '''> Wizards > Document Converter'''.
  
 
Before doing a bulk conversion of files, think about whether it is really necessary. Read this document right through to get an appreciation of the limitations of the conversion process.
 
Before doing a bulk conversion of files, think about whether it is really necessary. Read this document right through to get an appreciation of the limitations of the conversion process.
  
 +
== Opening files ==
 +
=== Opening text documents ===
 +
In addition to the native OpenDocument formats (.odt and .ott), {{OOo}} Writer can import the following text document formats:
  
{| style="border-spacing:0;"
 
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
 
| style="border:none;padding:0.049cm;"| Converting a lot of files can take a long time. I recommend you check for sufficient disk space first, and start converting when the computer is not going to be used for a while. In general, OOo files take up less space than Microsoft Office files, but to be safe you might allow for the same amount of space for the converted files.
 
 
|}
 
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=3 edit]]Opening files ==
 
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=4 edit]]Opening text documents ===
 
In addition to the native OpenDocument formats (.odt and .ott), Apache OpenOffice Writer 2.0 can import the following text document formats:
 
 
 
 
{| style="border-spacing:0;"
 
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Word 6.0/95/97/2000/XP) (.doc, .dot)
 
| style="border:0.05pt double #808080;padding:0.079cm;"| WordPerfect Document (.wpd)
 
  
 +
{|border=1 style="border-collapse:collapse;" cellpadding=3
 +
| Microsoft Word 6.0/95/97/2000/XP)
 +
|(.doc, .dot)
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Word 2003 XML (.xml)
+
| Microsoft Word 2003  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| WPS 2000/Office 1.0 (.wps)
+
|XML
 
+
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Winword 5 (.doc)
+
| Microsoft Office XML 
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocBook (.xml)
+
|docx
 
+
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| StarWriter formats (.sdw, .sgl, .vor)
+
| Microsoft Winword 5
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Ichitaro 8/9/10/11 (.jtd, .jtt)
+
|.doc
 
+
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| AportisDoc (Palm) (.pdb)
+
| WordPerfect Document
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Hangul WP 97 (.hwp)
+
|.wpd
 
+
|-
 +
| WPS 2000/Office 1.0  
 +
|.wps
 +
|-
 +
| AportisDoc (Palm)  
 +
|.pdb
 +
|-
 +
| Pocket Word
 +
| .psw
 +
|-
 +
|Rich Text format
 +
| .rtf,
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Pocket Word (.psw)
+
|Text
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| .rtf, .txt, .csv
+
|.txt, .csv
  
 
|}
 
|}
When opening .HTM or .HTML files, Apache OpenOffice customizes Writer for working with these files.
 
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=5 edit]]Opening spreadsheets ===
+
When opening .HTM or .HTML files, OpenOffice.org customizes Writer for working with these files.
In addition to the native OpenDocument formats (.ods and .ots), Apache OpenOffice Calc 2.0 can open the following spreadsheet formats:
+
  
 +
=== Opening spreadsheets ===
 +
In addition to the native OpenDocument formats (.ods and .ots), OpenOffice.org Calc 2.0 can open the following spreadsheet formats:
  
  
{| style="border-spacing:0;"
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Excel 97/2000/XP (.xls, .xlw, .xlt)
+
| Microsoft Excel 97/2000/XP (.xls, .xlw, .xlt)
| style="border:0.05pt double #808080;padding:0.079cm;"| Rich Text Format (.rtf)
+
| Rich Text Format (.rtf)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Excel 4.x–5/95 (.xls and .xlw, .xlt)
+
| Microsoft Excel 4.x–5/95 (.xls and .xlw, .xlt)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Text CSV (.csv and .txt)
+
| Text CSV (.csv and .txt)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft Excel 2003 XML (.xml)
+
| Microsoft Excel 2003 XML (.xml)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Lotus 1-2-3 (.wk1 and .wk1)
+
| Lotus 1-2-3 (.wk1 and .wk1)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Data Interchange Format (.dif)
+
| Data Interchange Format (.dif)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| StarCalc formats (.sdc, .vor)
+
| StarCalc formats (.sdc, .vor)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| dBase (.dbf)
+
| dBase (.dbf)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| SYLK (.slk)
+
| SYLK (.slk)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| .htm and .html files including Web page queries
+
| .htm and .html files including Web page queries
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Pocket Excel (pxl)
+
| Pocket Excel (pxl)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Quattro Pro 6.0 (.wb2)
+
| Quattro Pro 6.0 (.wb2)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"|  
+
|  
  
 
|}
 
|}
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=6 edit]]Opening presentations ===
 
In addition to the native OpenDocument formats (.odp and .otp), Apache OpenOffice Impress 2.0 can open the following presentation formats:
 
  
 +
=== Opening presentations ===
 +
In addition to the native OpenDocument formats (.odp and .otp), OpenOffice.org Impress 2.0 can open the following presentation formats:
  
  
{| style="border-spacing:0;"
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft PowerPoint 97/2000/XP (.ppt, .pps)
+
| Microsoft PowerPoint 97/2000/XP (.ppt, .pps)
| style="border:0.05pt double #808080;padding:0.079cm;"| Computer Graphics Metafile (.cgm)
+
| Computer Graphics Metafile (.cgm)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Microsoft PowerPoint 97/2000/XP Template (.pot)
+
| Microsoft PowerPoint 97/2000/XP Template (.pot)
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| StarDraw, StarImpress (.sda, .sdd, .sdp, .vor)
+
| StarDraw, StarImpress (.sda, .sdd, .sdp, .vor)
  
 
|}
 
|}
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=7 edit]]Opening graphics files ===
+
=== Opening graphics files ===
In addition to the native OpenDocument formats (.odg, and .otg), Apache OpenOffice Draw 2.0 can open the following graphic formats:
+
In addition to the native OpenDocument formats (.odg, and .otg), OpenOffice.org Draw 2.0 can open the following graphic formats:
  
BMP, JPEG/JPG, PCX, PSD, SGV, WMF, DXF, MET, PGM, RAS, SVM, XBM, EMF, PBM, PLT, SDA, TGA, XPM, EPS, PCD, PNG, SDD, TIF/TIFF, GIF, PCT, PPM, SGF, VOR
+
BMP, JPEG/JPG, PCX, PSD, SGV, WMF, DXF, MET, PGM, RAS, SVM, XBM, EMF, PBM, PLT, SDA, TGA, XPM, EPS, PCD, PNG, SDD, TIF/TIFF, GIF, PCT, PPM, SGF, VOR  
  
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=8 edit]]Opening formula files ===
+
=== Opening formula files ===
In addition to OpenDocument Formula files, Apache OpenOffice Math 2.0 can open the StarMath (.smf) and MathML (.mml) files.
+
In addition to OpenDocument Formula files, OpenOffice.org Math 2.0 can open the StarMath (.smf) and MathML (.mml) files.
  
<nowiki>When opening a Word document that contains an embedded equation editor object, select the [L] checkbox for&nbsp;</nowiki>''MathType to Apache OpenOffice Math/Apache OpenOffice Math to MathType''&nbsp;in&nbsp;'''Tools'''&nbsp;>&nbsp;'''Options'''&nbsp;>&nbsp;'''Load/Save'''&nbsp;>&nbsp;'''Microsoft Office'''&nbsp;and the object will be automatically converted to an Apache OpenOffice Math object.
+
<nowiki>When opening a Word document that contains an embedded equation editor object, select the [L] checkbox for </nowiki>''MathType to OpenOffice.org Math/OpenOffice.org Math to MathType'' in '''Tools''' > '''Options''' > '''Load/Save''' > '''Microsoft Office''' and the object will be automatically converted to an OpenOffice.org Math object.
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=9 edit]]Saving files ==
+
== Saving files ==
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=10 edit]]Default file format ===
+
=== Default file format ===
Apache OpenOffice saves files in the OpenDocument format by default unless told otherwise. This default can be changed, for example if you always want to save as Microsoft Office files. To change the default file formats:
+
  
# Go to&nbsp;'''Tools > Options > Load/Save > General'''.[[Image:500px-Doc_mig_options_loadsave_general.png]]
+
OpenOffice.org saves files in the OpenDocument format by default unless told otherwise. This default can be changed, for example if you always want to save as Microsoft Office files. To change the default file formats:
# In the Standard File Format section of this page, choose a document type (for example, “Text document”) and a file format from the&nbsp;'''Always save as'''&nbsp;list.
+
 
 +
# Go to '''Tools > Options > Load/Save > General'''.<br>[[Image:doc_mig_options_loadsave_general.png|frameless|500px|'''Figure 1''':Choosing default formats for saving files]]
 +
# In the Standard File Format section of this page, choose a document type (for example, “Text document”) and a file format from the '''Always save as''' list.
 
# Repeat for each document type as necessary.
 
# Repeat for each document type as necessary.
# Click&nbsp;'''OK'''&nbsp;to save your changes.
+
# Click '''OK''' to save your changes.
  
 +
{{Note|If the option “Warn when not saving in OpenDocument or default format” is checked on the '''Options - Load/Save - General dialog''', a warning dialog about potential loss of formatting may be displayed. In most cases, no loss of formatting will occur, so you may find this warning annoying and choose to disable it.
  
{| style="border-spacing:0;"
+
The Java Runtime Environment is required to use the mobile device filters for AportisDoc (Palm), Pocket Word and Pocket Excel.}}
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
+
| style="border:none;padding:0.049cm;"| If the option “Warn when not saving in OpenDocument or default format” is checked on the&nbsp;'''Options - Load/Save - General dialog''', a warning dialog about potential loss of formatting may be displayed. In most cases, no loss of formatting will occur, so you may find this warning annoying and choose to disable it.
+
  
The Java Runtime Environment is required to use the mobile device filters for AportisDoc (Palm), Pocket Word and Pocket Excel.
+
=== Export to PDF and XHTML ===
 
+
|}
+
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=11 edit]]Export to PDF and XHTML ===
+
 
Each application has the ability to directly export to PDF (Portable Document Format). This industry-standard format for universal file compression and viewing is ideal for sending the file to anyone else to view using Acrobat Reader or any other PDF display program on any operating system.
 
Each application has the ability to directly export to PDF (Portable Document Format). This industry-standard format for universal file compression and viewing is ideal for sending the file to anyone else to view using Acrobat Reader or any other PDF display program on any operating system.
  
You can export directly to PDF using the button on the toolbar next to the Printer icon, or by choosing&nbsp;'''File > Export as PDF''', which allows you to select some detailed options.
+
You can export directly to PDF using the button on the toolbar next to the Printer icon, or by choosing '''File > Export as PDF''', which allows you to select some detailed options.
  
To export as XHTML, use&nbsp;'''File > Export'''&nbsp;and for File format choose&nbsp;'''XHTML'''&nbsp;In the dropdown box.
+
To export as XHTML, use '''File > Export''' and for File format choose '''XHTML''' In the dropdown box.  
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=12 edit]]Saving files in other formats ===
+
=== Saving files in other formats ===
To save files in different formats, use&nbsp;'''File > Save As&nbsp;'''and select a format from the&nbsp;'''File Type'''&nbsp;dropdown box.
+
To save files in different formats, use '''File > Save As '''and select a format from the '''File Type''' dropdown box.  
  
[[Image:500px-Doc_mig_saveas.png]]
+
[[Image:doc_mig_saveas.png|500px|'''Figure 2''': The OpenOffice.org Save As dialog, showing some of the Save formats]]
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=13 edit]]Writer can save to these file formats ===
+
=== Writer can save to these file formats ===
 
In addition to its native formats, Writer can save in these formats:
 
In addition to its native formats, Writer can save in these formats:
  
Apache OpenOffice Writer 1.x (.sxw, .stw)
+
OpenOffice.org Writer 1.x (.sxw, .stw)
  
 
Microsoft Word 97/2000/XP (.doc)
 
Microsoft Word 97/2000/XP (.doc)
Line 281: Line 286:
 
HTML (.html; .htm)
 
HTML (.html; .htm)
  
 +
{{Note|The .rtf format is commonly used for transferring text files between applications, but you are likely to experience loss of formatting and images when the file is opened by Microsoft Office. The best way to pass a file in Writer to a Microsoft Word user is to save it as Microsoft Word 97/2000/XP (.doc).}}
  
{| style="border-spacing:0;"
+
=== Calc can save to these file formats ===
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
+
| style="border:none;padding:0.049cm;"| The .rtf format is commonly used for transferring text files between applications, but you are likely to experience loss of formatting and images when the file is opened by Microsoft Office. The best way to pass a file in Writer to a Microsoft Word user is to save it as Microsoft Word 97/2000/XP (.doc).
+
 
+
|}
+
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=14 edit]]Calc can save to these file formats ===
+
 
In addition to its native formats, Calc can save in these formats:
 
In addition to its native formats, Calc can save in these formats:
  
Apache OpenOffice Calc 1.x (.sxc, .stc)
+
OpenOffice.org Calc 1.x (.sxc, .stc)
  
 
Microsoft Excel 97/2000/XP (.xls; .xlw)
 
Microsoft Excel 97/2000/XP (.xls; .xlw)
Line 312: Line 313:
 
StarCalc formats (.sdc, .vor)
 
StarCalc formats (.sdc, .vor)
  
HTM and HTML files
+
HTM and HTML files  
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=15 edit]]Impress can save to these file formats ===
+
=== Impress can save to these file formats ===
 
In addition to its native formats, Impress can save in these formats:
 
In addition to its native formats, Impress can save in these formats:
  
Line 325: Line 326:
 
Impress can also export to MacroMedia Flash (.swf) and any of the graphics formats as listed below for Draw.
 
Impress can also export to MacroMedia Flash (.swf) and any of the graphics formats as listed below for Draw.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=16 edit]]Draw can save to these file formats ===
+
=== Draw can save to these file formats ===
 
Draw can only save in its native and StarDraw formats, but it can export to:
 
Draw can only save in its native and StarDraw formats, but it can export to:
  
 
BMP, EMF, EPS, GIF, JPEG, MET, PBM, PCT, PGM, PNG, PPM, RAS, SVG, SVM, TIFF, WMF, XPM
 
BMP, EMF, EPS, GIF, JPEG, MET, PBM, PCT, PGM, PNG, PPM, RAS, SVG, SVM, TIFF, WMF, XPM
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=17 edit]]The HTML writer can save in these formats ===
+
=== The HTML writer can save in these formats ===
 
HTML Document (.html; .htm)
 
HTML Document (.html; .htm)
  
Apache OpenOffice 1.0 HTML Template (.stw)
+
OpenOffice.org 1.0 HTML Template (.stw)
  
Apache OpenOffice 2.0 HTML Template (.oth)
+
OpenOffice.org 2.0 HTML Template (.oth)
  
 
StarWriter/Web 5.0 and 4.0 (.vor)
 
StarWriter/Web 5.0 and 4.0 (.vor)
  
Text (Apache OpenOffice Writer/Web) (.txt)
+
Text (OpenOffice.org Writer/Web) (.txt)
  
Text Encoded (Apache OpenOffice Writer/Web) (.txt)
+
Text Encoded (OpenOffice.org Writer/Web) (.txt)
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=18 edit]]Object Linking and Embedding (OLE) ==
+
== Object Linking and Embedding (OLE) ==
To change the settings for Microsoft Office OLE objects, use&nbsp;'''Tools'''&nbsp;>&nbsp;'''Options'''&nbsp;>&nbsp;'''Load/Save'''&nbsp;>&nbsp;'''Microsoft Office'''.
+
To change the settings for Microsoft Office OLE objects, use '''Tools''' > '''Options''' > '''Load/Save''' > '''Microsoft Office'''.
  
 
Having all of these options checked allows embedded objects to be converted and thus be editable in both office suites.
 
Having all of these options checked allows embedded objects to be converted and thus be editable in both office suites.
  
For other OLE objects, it will depend on the machine where the file is being edited just as it does with Microsoft Office alone. Thus Windows application based OLE objects will not be editable in Apache OpenOffice on a Linux machine, although the object will still be displayed correctly and can be resized.
+
For other OLE objects, it will depend on the machine where the file is being edited just as it does with Microsoft Office alone. Thus Windows application based OLE objects will not be editable in OpenOffice.org on a Linux machine, although the object will still be displayed correctly and can be resized.
  
[[Image:500px-Doc_mig_options_loadsave_vba.png]]
+
[[Image:doc_mig_options_loadsave_vba.png|500px|'''Figure 3''': Choosing Load/Save VBA Properties]]
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=19 edit]]Linked files ==
+
== Linked files ==
 
Cells copied from Excel and pasted special, linked and with RTF format, into Word are imported into Writer as a normal table. This means that when the document is imported, the link to the Excel file is lost.
 
Cells copied from Excel and pasted special, linked and with RTF format, into Word are imported into Writer as a normal table. This means that when the document is imported, the link to the Excel file is lost.
  
 
Similarly when a chart is copied from Excel and pasted special, linked into Word, and then the file imported into Writer, the chart is imported as an embedded OLE object but is not converted into a Calc chart. On saving the file in Word format and then opening the file in Word and trying to edit the chart by double-clicking, it displays an error message.
 
Similarly when a chart is copied from Excel and pasted special, linked into Word, and then the file imported into Writer, the chart is imported as an embedded OLE object but is not converted into a Calc chart. On saving the file in Word format and then opening the file in Word and trying to edit the chart by double-clicking, it displays an error message.
  
 +
{{Warn|Links in Microsoft Office files between Word and Excel are lost when the Microsoft office files have been edited by OpenOffice.org.}}
  
{| style="border-spacing:0;"
+
== WordArt and Fontwork ==
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_caution.png]]
+
The equivalent to Microsoft Office’s WordArt in OpenOffice.org is Fontwork. WordArt objects are imported as Fontwork objects; they may look slightly different on import. Fontwork objects are automatically exported to WordArt objects when the document is saved in a Microsoft Office format.
| style="border:none;padding:0.049cm;"| Links in Microsoft Office files between Word and Excel are lost when the Microsoft office files have been edited by Apache OpenOffice.
+
 
+
|}
+
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=20 edit]]WordArt and Fontwork ==
+
The equivalent to Microsoft Office’s WordArt in Apache OpenOffice is Fontwork. WordArt objects are imported as Fontwork objects; they may look slightly different on import. Fontwork objects are automatically exported to WordArt objects when the document is saved in a Microsoft Office format.
+
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=21 edit]]Vector graphics ==
+
== Vector graphics ==
The basic shapes (lines, arrows, rectangles, ovals) all import and export without any problem. Apache OpenOffice provides a greater degree of control over some properties than Microsoft Office does, so sometimes there will be changes when going from Apache OpenOffice to Microsoft Office. Examples include the size of arrow heads, and line styles.
+
The basic shapes (lines, arrows, rectangles, ovals) all import and export without any problem. OpenOffice.org provides a greater degree of control over some properties than Microsoft Office does, so sometimes there will be changes when going from OpenOffice.org to Microsoft Office. Examples include the size of arrow heads, and line styles.
  
 
The Microsoft Office autoshapes, such as the smiley face, keep their special characteristics, for instance the ability to adjust the degree of the smile or frown on the smiley face.
 
The Microsoft Office autoshapes, such as the smiley face, keep their special characteristics, for instance the ability to adjust the degree of the smile or frown on the smiley face.
  
Microsoft Office provides more shadow options than Apache OpenOffice, so sometimes there will be a change in shadow appearance. Microsoft Office shadow styles 1, 2, 4, 6, 14, 17 and 18 are supported in Apache OpenOffice. Horizontal and tapered shadows do not get imported and any 3D effect on the bottom left is ignored.
+
Microsoft Office provides more shadow options than OpenOffice.org, so sometimes there will be a change in shadow appearance. Microsoft Office shadow styles 1, 2, 4, 6, 14, 17 and 18 are supported in OpenOffice.org. Horizontal and tapered shadows do not get imported and any 3D effect on the bottom left is ignored.
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=22 edit]]Frames and text boxes ==
+
== Frames and text boxes ==
When frames or text boxes from Microsoft Office are imported into Apache OpenOffice with linked text, the links are lost.
+
When frames or text boxes from Microsoft Office are imported into OpenOffice.org with linked text, the links are lost.
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=23 edit]]Active content controls ==
+
== Active content controls ==
These are the controls in Microsoft Office available on the Controls toolbar; they all import without a problem. However, as these controls typically require macros to be of use, they will be functionally useless in the absence of macros custom built for use in Apache OpenOffice.
+
These are the controls in Microsoft Office available on the Controls toolbar; they all import without a problem. However, as these controls typically require macros to be of use, they will be functionally useless in the absence of macros custom built for use in OpenOffice.org.
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=24 edit]]Macros ==
+
== Macros ==
Apache OpenOffice cannot run Microsoft Office macros. Although the macro language is very similar, the underlying objects are quite different. To set whether Apache OpenOffice keeps attached macros (so that they are still available for use in Microsoft Office) for Word, Excel and PowerPoint files, use'''Tools'''&nbsp;>&nbsp;'''Options'''&nbsp;>&nbsp;'''Load/Save'''&nbsp;>&nbsp;'''VBA Properties'''.
+
OpenOffice.org cannot run Microsoft Office macros. Although the macro language is very similar, the underlying objects are quite different. To set whether OpenOffice.org keeps attached macros (so that they are still available for use in Microsoft Office) for Word, Excel and PowerPoint files, use '''Tools''' > '''Options''' > '''Load/Save''' > '''VBA Properties'''.
  
 +
{{Note|Opening a Microsoft Office file infected with a macro virus is quite safe in OpenOffice.org.}}
  
{| style="border-spacing:0;"
+
OpenOffice.org has the ability to record macros. It is better practice to use the application program interface (API).
| style="border:none;padding:0.049cm;"| [[Image:42px-Documentation_note.png]]
+
| style="border:none;padding:0.049cm;"| Opening a Microsoft Office file infected with a macro virus is quite safe in Apache OpenOffice.
+
  
|}
+
== Import, export and sharing issues in text documents ==
Apache OpenOffice has the ability to record macros. It is better practice to use the application program interface (API).
+
=== Good practice in text documents ===
 
+
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=25 edit]]Import, export and sharing issues in text documents ==
+
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=26 edit]]Good practice in text documents ===
+
 
Some issues can be avoided simply by using good word-processing practice:
 
Some issues can be avoided simply by using good word-processing practice:
  
Line 400: Line 393:
 
* Use only commonly available fonts.
 
* Use only commonly available fonts.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=27 edit]]Compatibility settings in Apache OpenOffice for the current document ===
+
=== Compatibility settings in OpenOffice.org for the current document ===
The following settings change the way Apache OpenOffice works with the current document so that it works more like Microsoft Office.
+
The following settings change the way OpenOffice.org works with the current document so that it works more like Microsoft Office.
  
Use&nbsp;'''Tools'''&nbsp;>&nbsp;'''Options'''&nbsp;'''> Apache OpenOffice Writer > Compatibility'''.
+
Use '''Tools''' > '''Options''' '''> OpenOffice.org Writer > Compatibility'''.
  
[[Image:500px-Doc_mig_options_writer_compat.png]]
+
[[Image:doc_mig_options_writer_compat.png|500px|'''Figure 4''': Choosing compatibility options]]
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=28 edit]]Add paragraph and table spacing at tops of pages (in current document) ====
+
==== Add paragraph and table spacing at tops of pages (in current document) ====
 
In Writer, with this setting unchecked, if a paragraph at the top of the page (or column) is formatted with space above then that space is ignored; whereas in Word the space above is included. Checking this option causes Writer to behave in the same way as Word.
 
In Writer, with this setting unchecked, if a paragraph at the top of the page (or column) is formatted with space above then that space is ignored; whereas in Word the space above is included. Checking this option causes Writer to behave in the same way as Word.
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=29 edit]]Use Apache OpenOffice 1.1 tabstop formatting ====
+
==== Use OpenOffice.org 1.1 tabstop formatting ====
 
This setting specifies whether centered and right-aligned paragraphs containing tabs are formatted as a whole in the center or aligned to the right. If this checkbox is checked, only the text to the right of the last tab is aligned to the right, while the text to the left remains as is.
 
This setting specifies whether centered and right-aligned paragraphs containing tabs are formatted as a whole in the center or aligned to the right. If this checkbox is checked, only the text to the right of the last tab is aligned to the right, while the text to the left remains as is.
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=30 edit]]Use Apache OpenOffice 1.1 line spacing ====
+
==== Use OpenOffice.org 1.1 line spacing ====
 
Writer uses the greater of the two spacings for above and below paragraphs; Word sums the two together. Uncheck this box to have Writer behave in the same way as Word.
 
Writer uses the greater of the two spacings for above and below paragraphs; Word sums the two together. Uncheck this box to have Writer behave in the same way as Word.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=31 edit]]Font and font spacing ===
+
=== Font and font spacing ===
 
Text effect animations are imported by Writer with the character attribute of blinking from Word files. For example “Marching red ants” simply becomes “blinking”.
 
Text effect animations are imported by Writer with the character attribute of blinking from Word files. For example “Marching red ants” simply becomes “blinking”.
  
 
Typically Word’s character spacing is tighter than Writer’s, so often Word will fit more characters to a line. It is also possible that the spacing between lines could be slightly different. The end result is that the page breaks may be in different places.
 
Typically Word’s character spacing is tighter than Writer’s, so often Word will fit more characters to a line. It is also possible that the spacing between lines could be slightly different. The end result is that the page breaks may be in different places.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=32 edit]]Tables ===
+
=== Tables ===
 
The author could find no issues with tables.
 
The author could find no issues with tables.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=33 edit]]Mail merge documents ===
+
=== Mail merge documents ===
As Apache OpenOffice has a different approach to data sources. On importing a Word document that is the main document for a mail merge, there is no connection with the data source. It is not just a matter of making that connection; each field needs to be reinserted. See the Mail Merge section in the chapter titled “Differences in use between Writer and Word”.
+
As OpenOffice.org has a different approach to data sources. On importing a Word document that is the main document for a mail merge, there is no connection with the data source. It is not just a matter of making that connection; each field needs to be reinserted. See the Mail Merge section in the chapter titled “Differences in use between Writer and Word”.
  
Also in Word you can have another Word document as a data source for a mail merge. There is no way of specifying a Word (or Writer) document as a data source in Apache OpenOffice.
+
Also in Word you can have another Word document as a data source for a mail merge. There is no way of specifying a Word (or Writer) document as a data source in OpenOffice.org.
  
Writer does not have the option of suppressing blank lines when data fields are empty, so you need to use conditional fields.
+
Writer does not have the option of suppressing blank lines when data fields are empty, so you need to use conditional fields.  
  
 
<nowiki>Writer merge fields export as text with the name of the field between angle brackets, for example <Name>.</nowiki>
 
<nowiki>Writer merge fields export as text with the name of the field between angle brackets, for example <Name>.</nowiki>
  
''Summary'': To work in a shared environment would require a separate file for each “main document”: one in Word format, the other in Apache OpenOffice format. If you have a master mail merge document in Word format, it is probably easiest to paste the text into Writer and use the Writer mail merge wizard to recreate the mail merge from scratch.
+
''Summary'': To work in a shared environment would require a separate file for each “main document”: one in Word format, the other in OpenOffice.org format. If you have a master mail merge document in Word format, it is probably easiest to paste the text into Writer and use the Writer mail merge wizard to recreate the mail merge from scratch.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=34 edit]]Forms ===
+
=== Forms ===
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=35 edit]]Issues with forms created in Microsoft Office ====
+
==== Issues with forms created in Microsoft Office ====
A locked file in Microsoft Office imports unlocked into Apache OpenOffice; that is, in design mode.
+
A locked file in Microsoft Office imports unlocked into OpenOffice.org; that is, in design mode.
  
Text form fields import into Apache OpenOffice as Input fields and so lose their type. For example, a text form field of type “number” or “date” will accept any text for input. In use a text form field in Apache OpenOffice displays a dialog for entering the text. Exporting back to Microsoft Office, text form fields are changed into “Fillin” fields. The current date and time and calculation fields import as simple text.
+
Text form fields import into OpenOffice.org as Input fields and so lose their type. For example, a text form field of type “number” or “date” will accept any text for input. In use a text form field in OpenOffice.org displays a dialog for entering the text. Exporting back to Microsoft Office, text form fields are changed into “Fillin” fields. The current date and time and calculation fields import as simple text.
  
 
Checkboxes import and export correctly.
 
Checkboxes import and export correctly.
Line 445: Line 438:
 
Drop-down form fields import as Input List fields. Like text form fields in operation these display a dialog from which the user can select an option. On export back to Microsoft Office they return to drop-down form fields again.
 
Drop-down form fields import as Input List fields. Like text form fields in operation these display a dialog from which the user can select an option. On export back to Microsoft Office they return to drop-down form fields again.
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=36 edit]]Issues with forms created in Apache OpenOffice ====
+
==== Issues with forms created in OpenOffice.org ====
The controls are exported as active controls when there is a Microsoft Office equivalent. As Word does not have the same database functionality of Apache OpenOffice and as the macros are not compatible, it would be very difficult to have one form that works in both environments using standard form controls.
+
The controls are exported as active controls when there is a Microsoft Office equivalent. As Word does not have the same database functionality of OpenOffice.org and as the macros are not compatible, it would be very difficult to have one form that works in both environments using standard form controls.
  
''Summary'': To work in a shared environment with forms is not easy, but one workaround would be to use other fields like Input field and Input List. To insert these fields, use&nbsp;'''Insert'''&nbsp;>&nbsp;'''Fields'''&nbsp;>&nbsp;'''Other'''&nbsp;>&nbsp;'''Functions'''.
+
''Summary'': To work in a shared environment with forms is not easy, but one workaround would be to use other fields like Input field and Input List. To insert these fields, use '''Insert''' > '''Fields''' > '''Other''' > '''Functions'''.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=37 edit]]Footnotes, endnotes, tables of contents and indexes ===
+
=== Footnotes, endnotes, tables of contents and indexes ===
 
Footnotes, endnotes and indexes all import / export correctly. Some issues have been found:
 
Footnotes, endnotes and indexes all import / export correctly. Some issues have been found:
  
Line 460: Line 453:
 
''Summary'': Working in a shared environment is possible with some minor issues.
 
''Summary'': Working in a shared environment is possible with some minor issues.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=38 edit]]Numbered paragraphs, outline numbering, cross-references ===
+
=== Numbered paragraphs, outline numbering, cross-references ===
 
Numbered paragraphs, outline numbering, and cross-references import / export without a problem, except for references to numbered paragraphs:
 
Numbered paragraphs, outline numbering, and cross-references import / export without a problem, except for references to numbered paragraphs:
  
Line 467: Line 460:
 
* Cross-references to chapter numbers do not have the same format as that displayed.
 
* Cross-references to chapter numbers do not have the same format as that displayed.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=39 edit]]Page numbering ===
+
=== Page numbering ===
A quick and dirty approach in Word for having a different first page (like a cover page) and then to have the numbering start on the second page but numbered as page 1 is to have a layout of different first page and setting the starting page to be zero. Unfortunately, on importing such a file into Apache OpenOffice the page number on the second page is 2 instead of 1. To fix this problem in Writer:
+
A quick and dirty approach in Word for having a different first page (like a cover page) and then to have the numbering start on the second page but numbered as page 1 is to have a layout of different first page and setting the starting page to be zero. Unfortunately, on importing such a file into OpenOffice.org the page number on the second page is 2 instead of 1. To fix this problem in Writer:
  
 
# Create a page style for how the pages after the first page should look. Name it (for example) Convert1.
 
# Create a page style for how the pages after the first page should look. Name it (for example) Convert1.
Line 474: Line 467:
 
# '''Format > Paragraph > Text Flow'''.
 
# '''Format > Paragraph > Text Flow'''.
 
# In the Breaks portion of the dialog, select the checkbox Insert.
 
# In the Breaks portion of the dialog, select the checkbox Insert.
# Check&nbsp;'''With Page Style'''.
+
# Check '''With Page Style'''.
 
# Choose the page style created in step 1.
 
# Choose the page style created in step 1.
# Leave the position as&nbsp;'''Before'''&nbsp;and set the page number to 1.
+
# Leave the position as '''Before''' and set the page number to 1.
  
 
On exporting this document back to Word it will work, the only difference being that the document will have a section break at the end of the first page. Documents created with section breaks like this in Word will work fine importing and exporting with Writer. There is one difference with Word: now there will be a blank page between the cover page and the next page when printed (or print previewed).
 
On exporting this document back to Word it will work, the only difference being that the document will have a section break at the end of the first page. Documents created with section breaks like this in Word will work fine importing and exporting with Writer. There is one difference with Word: now there will be a blank page between the cover page and the next page when printed (or print previewed).
Line 484: Line 477:
 
''Summary'': For some documents a little work maybe required to fix up the page numbering on importing to Writer. Once “fixed” the page numbering of the documents will import / export without a problem.
 
''Summary'': For some documents a little work maybe required to fix up the page numbering on importing to Writer. Once “fixed” the page numbering of the documents will import / export without a problem.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=40 edit]]Date and time fields ===
+
=== Date and time fields ===
 
Word’s CreateDate and SaveDate fields do not get imported with the same formats. For example, if the fields in the Word document have a format that includes time, then this information is not displayed by default. To include time in the format:
 
Word’s CreateDate and SaveDate fields do not get imported with the same formats. For example, if the fields in the Word document have a format that includes time, then this information is not displayed by default. To include time in the format:
  
'''Right-click'''&nbsp;on the field >&nbsp;'''Fields'''&nbsp;> scroll to the bottom of the Formats listbox >&nbsp;'''Additional formats >'''&nbsp;in format code add HH:MM:SS
+
'''Right-click''' on the field > '''Fields''' > scroll to the bottom of the Formats listbox > '''Additional formats >''' in format code add HH:MM:SS
  
 
On export the SaveDate / DocInformation:Modified is exported as text.
 
On export the SaveDate / DocInformation:Modified is exported as text.
Line 493: Line 486:
 
Writer’s Time Fixed and Date Fixed fields get exported as text.
 
Writer’s Time Fixed and Date Fixed fields get exported as text.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=41 edit]]Importing Word fields ===
+
=== Importing Word fields ===
<center>Imported Word fields conversion</center>
+
  
 
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
{| style="border-spacing:0;"
+
|+Imported Word fields conversion
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''Word field:'''</center>
+
! Word field:
| style="border:0.05pt double #808080;padding:0.079cm;"| <center>'''Writer converts to:'''</center>
+
! Writer converts to:
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| ASK
+
| ASK
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Input field
+
| Input field
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| AUTHOR
+
| AUTHOR
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Created
+
| DocInformation:Created
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| AUTONUM
+
| AUTONUM
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Number Range AutoNr
+
| Number Range AutoNr
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| AUTONUMLGL
+
| AUTONUMLGL
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Number range AutoNr
+
| Number range AutoNr
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| AUTONUMOUT
+
| AUTONUMOUT
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Number range AutoNr
+
| Number range AutoNr
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| COMMENTS
+
| COMMENTS
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInfomation:Comments
+
| DocInfomation:Comments
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| CREATEDATE
+
| CREATEDATE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Created
+
| DocInformation:Created
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| DATE
+
| DATE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Date
+
| Date
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| EDITTIME
+
| EDITTIME
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Modified
+
| DocInformation:Modified
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| FILENAME
+
| FILENAME
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| File name
+
| File name
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| FILLIN
+
| FILLIN
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Input field
+
| Input field
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| HYPERLINK
+
| HYPERLINK
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| (as a hyperlink)
+
| (as a hyperlink)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| INFO xxx
+
| INFO xxx
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:xxx
+
| DocInformation:xxx
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| KEYWORDS
+
| KEYWORDS
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Keywords
+
| DocInformation:Keywords
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| LASTSAVEDBY
+
| LASTSAVEDBY
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Modified
+
| DocInformation:Modified
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| MACROBUTTON
+
| MACROBUTTON
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| (the name of the macro?)
+
| (the name of the macro?)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| MERGEFIELD
+
| MERGEFIELD
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Mail merge fields (displayed as the name of the field)
+
| Mail merge fields (displayed as the name of the field)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| MERGEREC
+
| MERGEREC
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Record number
+
| Record number
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| NEXT
+
| NEXT
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Next record
+
| Next record
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| NOTEREF
+
| NOTEREF
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Show variable
+
| Show variable
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| NUMCHARS
+
| NUMCHARS
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Statistics (with select = Characters)
+
| Statistics (with select = Characters)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| NUMPAGES
+
| NUMPAGES
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Statistics (with select = Pages)
+
| Statistics (with select = Pages)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| PAGE
+
| PAGE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Page numbers
+
| Page numbers
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| PAGEREF
+
| PAGEREF
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Bookmarks (displayed as name of bookmark)
+
| Bookmarks (displayed as name of bookmark)
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| REVNUM
+
| REVNUM
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Document number
+
| DocInformation:Document number
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| SAVEDATE
+
| SAVEDATE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Modified
+
| DocInformation:Modified
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| SEQ
+
| SEQ
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Number range
+
| Number range
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| SET
+
| SET
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Set variable
+
| Set variable
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| SUBJECT
+
| SUBJECT
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Subject
+
| DocInformation:Subject
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| TEMPLATE
+
| TEMPLATE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Templates
+
| Templates
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| TIME
+
| TIME
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Date
+
| Date
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| TITLE
+
| TITLE
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| DocInformation:Title
+
| DocInformation:Title
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| TOC
+
| TOC
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| (Displays the table of contents)
+
| (Displays the table of contents)
  
 
|}
 
|}
The following fields are not imported into Apache OpenOffice (only the text that they displayed when last saved): =, IF, DOCPROPERTY, FILESIZE, LINK, LISTNUM, QUOTE, SECTION, SECTIONPAGES, STYLEREF, TOA, USERADDRESS, USERINITIALS, USERNAME.
+
 
 +
The following fields are not imported into OpenOffice.org (only the text that they displayed when last saved): <nowiki>=, IF, DOCPROPERTY, FILESIZE, LINK, LISTNUM, QUOTE, SECTION, SECTIONPAGES, STYLEREF, TOA, USERADDRESS, USERINITIALS, USERNAME.</nowiki>
  
 
The following fields are ignored on import: AUTOTEXT, AUTOTEXTLIST, BARCODE, BIDIOUTLINE, DOCVARIABLE, EQ, GOTOBUTTON, INCLUDETEXT, LISTNUM, MERGESEQ, PRINT, RD, SKIPIF, SYMBOL, TA, TC.
 
The following fields are ignored on import: AUTOTEXT, AUTOTEXTLIST, BARCODE, BIDIOUTLINE, DOCVARIABLE, EQ, GOTOBUTTON, INCLUDETEXT, LISTNUM, MERGESEQ, PRINT, RD, SKIPIF, SYMBOL, TA, TC.
Line 640: Line 633:
 
The Word field EDITTIME is mapped to Writer field DocInformation:Modified on import but the meaning has changed to the date and time last saved rather than how long the file has been open for editing.
 
The Word field EDITTIME is mapped to Writer field DocInformation:Modified on import but the meaning has changed to the date and time last saved rather than how long the file has been open for editing.
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=42 edit]]Import, export and sharing issues in spreadsheets ==
+
== Import, export and sharing issues in spreadsheets ==
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=43 edit]]Form fields ===
+
=== Form fields ===
 
Combo boxes, list boxes and checkboxes with links to spreadsheet cells all import and export properly, although due to font handling the number of rows displayed in list boxes may be slightly different. List boxes in Calc can either have multi-selection or not, whereas Excel has two multi-selection modes: multi and extend. In Excel a link from a multi-selection listbox to a cell is ignored (at least in Excel 2000; the author has not checked Excel XP). In Calc the link works, but if more than one item is selected, the cell’s value is set to #N/A.
 
Combo boxes, list boxes and checkboxes with links to spreadsheet cells all import and export properly, although due to font handling the number of rows displayed in list boxes may be slightly different. List boxes in Calc can either have multi-selection or not, whereas Excel has two multi-selection modes: multi and extend. In Excel a link from a multi-selection listbox to a cell is ignored (at least in Excel 2000; the author has not checked Excel XP). In Calc the link works, but if more than one item is selected, the cell’s value is set to #N/A.
  
Line 648: Line 641:
 
Scroll bars and spinners are now implemented in Calc, but are not imported yet.
 
Scroll bars and spinners are now implemented in Calc, but are not imported yet.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=44 edit]]Array constants ===
+
=== Array constants ===
Array constants are not available in Apache OpenOffice. The workaround is to have the constant values in cells on a sheet and refer to them. Array constants used as parameters to a function in Excel are omitted when imported into Calc.
+
Array constants are not available in OpenOffice.org. The workaround is to have the constant values in cells on a sheet and refer to them. Array constants used as parameters to a function in Excel are omitted when imported into Calc.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=45 edit]]Optional parameters in formulas ===
+
=== Optional parameters in formulas ===
 
Some formulas have more than one optional parameter at the end of the parameter list. In Excel it is possible to leave an optional parameter blank and specify a later parameter, but this is not possible in Calc. Formulas with optional parameters are not correctly imported into Calc.
 
Some formulas have more than one optional parameter at the end of the parameter list. In Excel it is possible to leave an optional parameter blank and specify a later parameter, but this is not possible in Calc. Formulas with optional parameters are not correctly imported into Calc.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=46 edit]]Functions ===
+
=== Functions ===
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=47 edit]]Statistical, engineering and financial functions ====
+
==== Statistical, engineering and financial functions ====
In Excel some of the financial functions accept string parameters for dates; in Apache OpenOffice they require a serial number, and thus they are not correctly imported into Calc.
+
In Excel some of the financial functions accept string parameters for dates; in OpenOffice.org they require a serial number, and thus they are not correctly imported into Calc.
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=48 edit]]Analysis ToolPak Functions ====
+
==== Analysis ToolPak Functions ====
 
The function EFFECT provided by the Analysis ToolPak for Excel is converted to EFFECT_ADD in Calc and returns the same results.
 
The function EFFECT provided by the Analysis ToolPak for Excel is converted to EFFECT_ADD in Calc and returns the same results.
  
==== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=49 edit]]Other functions not implemented / imported ====
+
==== Other functions not implemented / imported ====
Only three other functions are not imported: INFO, GETPIVOTDATA, and HYPERLINK. Hyperlinks are supported but not as a function; use the&nbsp;'''Hyperlink'''&nbsp;button on the Function bar.
+
Only three other functions are not imported: INFO, GETPIVOTDATA, and HYPERLINK. Hyperlinks are supported but not as a function; use the '''Hyperlink''' button on the Function bar.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=50 edit]]DataPilot—Pivot Table ===
+
=== DataPilot—Pivot Table ===
 
DataPilots are Calc’s equivalent to Excel’s Pivot Tables. However there are a number of limitations. Pivot tables import from Excel into Calc (although the cells do not have the PivotTable shading) but as soon as they are worked on these limitations become apparent. The limitations are:
 
DataPilots are Calc’s equivalent to Excel’s Pivot Tables. However there are a number of limitations. Pivot tables import from Excel into Calc (although the cells do not have the PivotTable shading) but as soon as they are worked on these limitations become apparent. The limitations are:
  
 
* There is no PivotChart facility, but a DataPilot can be used as the data source for a chart.
 
* There is no PivotChart facility, but a DataPilot can be used as the data source for a chart.
* The user interface allows a maximum of 8 fields in the data, row or column areas. (An alternative interface which allows more is available from:&nbsp;[http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/]&nbsp;in a document called MyDataPilot.sxc.
+
* The user interface allows a maximum of 8 fields in the data, row or column areas. (An alternative interface which allows more is available from: [http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/] in a document called MyDataPilot.sxc.
 
* There is some ability to group data (for example, a date field grouping by week or quarter but not by month). The workaround is to create a new column with a formula for calculating the grouping, e.g. =Month().
 
* There is some ability to group data (for example, a date field grouping by week or quarter but not by month). The workaround is to create a new column with a formula for calculating the grouping, e.g. =Month().
 
* You can not define different formats for different fields.
 
* You can not define different formats for different fields.
 
* Calc can have formulas based on things like “Difference From” or “% of”, but can not have own custom fields (work around create new columns to calculate the desired values).
 
* Calc can have formulas based on things like “Difference From” or “% of”, but can not have own custom fields (work around create new columns to calculate the desired values).
* The Application Program Interface specification is incomplete for writing macros that work with DataPilots—for example, the ability to control through another program, such as Apache OpenOffice’s own macro language, BASIC, whether the tables have grand totals, or having access to DataPilots created from external data.
+
* The Application Program Interface specification is incomplete for writing macros that work with DataPilots—for example, the ability to control through another program, such as OpenOffice.org’s own macro language, BASIC, whether the tables have grand totals, or having access to DataPilots created from external data.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=51 edit]]AutoFilter ===
+
=== AutoFilter ===
 
AutoFilter imports and exports correctly with the required rows being hidden. However, there are a number of differences between Excel and Calc:
 
AutoFilter imports and exports correctly with the required rows being hidden. However, there are a number of differences between Excel and Calc:
  
Line 682: Line 675:
 
* In the drop down lists, the equivalent to Excel’s “Custom” is called “Standard”.
 
* In the drop down lists, the equivalent to Excel’s “Custom” is called “Standard”.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=52 edit]]Charts ===
+
=== Charts ===
 
Chart types that Excel provides but Calc does not:
 
Chart types that Excel provides but Calc does not:
  
Line 695: Line 688:
 
* The data must be contiguous, with the labels in the first row or column.
 
* The data must be contiguous, with the labels in the first row or column.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=53 edit]]Number formats ===
+
=== Number formats ===
 
There is no “accounting” format (with the currency symbol at the left edge of the cell). A workaround would be to have another column to the left that contains the currency symbol.
 
There is no “accounting” format (with the currency symbol at the left edge of the cell). A workaround would be to have another column to the left that contains the currency symbol.
  
 
<nowiki>There is no predefined option for bracketing negative numbers. Use a custom format such as “$#,##0.00_);[RED]($#,##0.00)”.</nowiki>
 
<nowiki>There is no predefined option for bracketing negative numbers. Use a custom format such as “$#,##0.00_);[RED]($#,##0.00)”.</nowiki>
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=54 edit]]Grid lines ===
+
=== Grid lines ===
 
In Excel grid lines are a property of a worksheet; in Calc it is an application-wide option:
 
In Excel grid lines are a property of a worksheet; in Calc it is an application-wide option:
  
'''Tools > Options > Apache OpenOffice Calc > View'''
+
'''Tools > Options > OpenOffice.org Calc > View'''
  
== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=55 edit]]Import, export and sharing issues in presentations ==
+
== Import, export and sharing issues in presentations ==
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=56 edit]]Color gradients and borders ===
+
=== Color gradients and borders ===
The author had not noticed the following changes, so this is a direct quote from&nbsp;''StarOffice 7 Migration Guide''&nbsp;by Sun.
+
The author had not noticed the following changes, so this is a direct quote from ''StarOffice 7 Migration Guide'' by Sun.
  
 
Unlike Microsoft PowerPoint, StarOffice Impress does not support three-color gradients, double and triple borders, or round-dotted borders. To improve the results of the import, you have to make the necessary adjusts before import. Change three-color presets to similar two-color gradient fills and change double and triple border lines to a single border line with appropriate width. Round-dotted border lines that are mapped to rectangle-border closely resemble the original line style in PowerPoint, so manual editing should not be necessary.
 
Unlike Microsoft PowerPoint, StarOffice Impress does not support three-color gradients, double and triple borders, or round-dotted borders. To improve the results of the import, you have to make the necessary adjusts before import. Change three-color presets to similar two-color gradient fills and change double and triple border lines to a single border line with appropriate width. Round-dotted border lines that are mapped to rectangle-border closely resemble the original line style in PowerPoint, so manual editing should not be necessary.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=57 edit]]Multimedia ===
+
=== Multimedia ===
 
Voice-over narration is not supported by Impress.
 
Voice-over narration is not supported by Impress.
  
 
There appear to be no settings for multimedia custom animations, such as the ability to play a sound for the next slides.
 
There appear to be no settings for multimedia custom animations, such as the ability to play a sound for the next slides.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=58 edit]]Chart animations ===
+
=== Chart animations ===
 
There is no facility in Impress for “chart effects” as there is in PowerPoint, such as presenting a series or category at a time. On import the charts simply appear. A workaround is to have multiple copies of the chart with each one set up to display as desired.
 
There is no facility in Impress for “chart effects” as there is in PowerPoint, such as presenting a series or category at a time. On import the charts simply appear. A workaround is to have multiple copies of the chart with each one set up to display as desired.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=59 edit]]Pack and Go ===
+
=== Pack and Go ===
 
The Pack and Go feature in PowerPoint allowed a PowerPoint file to be split over several floppy disks and assured that all related files were included. This facility is not included in Impress, nor can Impress open such files.
 
The Pack and Go feature in PowerPoint allowed a PowerPoint file to be split over several floppy disks and assured that all related files were included. This facility is not included in Impress, nor can Impress open such files.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=60 edit]]Fields ===
+
=== Fields ===
 
Date fields are exported as text, so they do not automatically update.
 
Date fields are exported as text, so they do not automatically update.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=61 edit]]Action settings and interaction ===
+
=== Action settings and interaction ===
 
PowerPoint provides action settings for mouseover, but Impress does not have this option, only on mouse click, so mouseovers get mapped to mouse clicks. PowerPoint has an option for highlighting the object on mouse click or mouse over; Impress does not have this, so it gets ignored on import.
 
PowerPoint provides action settings for mouseover, but Impress does not have this option, only on mouse click, so mouseovers get mapped to mouse clicks. PowerPoint has an option for highlighting the object on mouse click or mouse over; Impress does not have this, so it gets ignored on import.
  
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=62 edit]]PowerPoint custom animations and Impress object effects ===
+
=== PowerPoint custom animations and Impress object effects ===
 
Table 3 shows how the custom animations and object effects are imported into Impress and exported to PowerPoint.
 
Table 3 shows how the custom animations and object effects are imported into Impress and exported to PowerPoint.
  
<center>Importing / exporting custom animations between PowerPoint and Impress</center>
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
 
+
|+Importing / exporting custom animations between PowerPoint and Impress
 
+
! PowerPoint
{| style="border-spacing:0;"
+
! Impress
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''PowerPoint'''</center>
+
| style="border:0.05pt double #808080;padding:0.079cm;"| <center>'''Impress'''</center>
+
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Appear
+
| Appear
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Appear
+
| Appear
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Blinds
+
| Blinds
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade Horizontally
+
| Fade Horizontally
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Box
+
| Box
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade To Center
+
| Fade To Center
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Checkerboard
+
| Checkerboard
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Checkerboard
+
| Checkerboard
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Diamond
+
| Diamond
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Appear
+
| Appear
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Crawl
+
| Crawl
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fly In From bottom
+
| Fly In From bottom
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Dissolve
+
| Dissolve
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Dissolve
+
| Dissolve
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Flash once
+
| Flash once
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Appear
+
| Appear
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Peek
+
| Peek
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Short Fly In from Bottom
+
| Short Fly In from Bottom
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Random Bars
+
| Random Bars
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Horizontal lines
+
| Horizontal lines
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Spiral
+
| Spiral
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Spiral Outward Clockwise
+
| Spiral Outward Clockwise
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Split
+
| Split
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Close Vertical
+
| Close Vertical
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Stretch
+
| Stretch
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Stretch Vertical
+
| Stretch Vertical
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Strips
+
| Strips
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Top Right
+
| Fade From Top Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Swivel
+
| Swivel
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Rotate Horizontally
+
| Rotate Horizontally
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Wipe
+
| Wipe
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cross-Fade From Top
+
| Cross-Fade From Top
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Zoom
+
| Zoom
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Center
+
| Fade From Center
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Random effects
+
| Random effects
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Vertical Lines
+
| Vertical Lines
  
 
|}
 
|}
=== [[https://wiki.openoffice.org/w/index.php?title=Documentation/UserGuide/Migration_Guide/Sharing_Files&action=edit&section=63 edit]]PowerPoint—Impress slide transitions ===
 
<center>Table 4 shows how slide transitions are imported into Impress and exported to PowerPoint.</center>
 
  
 +
=== PowerPoint—Impress slide transitions ===
  
{| style="border-spacing:0;"
+
{|border=1 style="border-collapse:collapse;" cellpadding=3
| style="border-top:0.05pt double #808080;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| <center>'''PowerPoint'''</center>
+
|+Table 4 shows how slide transitions are imported into Impress and exported to PowerPoint.
| style="border:0.05pt double #808080;padding:0.079cm;"| <center>'''Impress'''</center>
+
! PowerPoint
 +
! Impress
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Blinds Horizontal
+
| Blinds Horizontal
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Venitian Blinds Horizontal
+
| Venitian Blinds Horizontal
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Blinds Vertical
+
| Blinds Vertical
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Venitian Blinds Vertical
+
| Venitian Blinds Vertical
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Box In
+
| Box In
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Box In
+
| Box In
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Box Out
+
| Box Out
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Box Out
+
| Box Out
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Checkerboard Across
+
| Checkerboard Across
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Checkerboard Across
+
| Checkerboard Across
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Checkerboard Down
+
| Checkerboard Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Checkerboard Down
+
| Checkerboard Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Down
+
| Cover Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Down
+
| Cover Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Left
+
| Cover Left
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Left
+
| Cover Left
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Right
+
| Cover Right
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Right
+
| Cover Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Up
+
| Cover Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Up
+
| Cover Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Left Down
+
| Cover Left Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Left-Down
+
| Cover Left-Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Right Down
+
| Cover Right Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Right-Down
+
| Cover Right-Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Left Up
+
| Cover Left Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Left-Up
+
| Cover Left-Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cover Right Up
+
| Cover Right Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Cover Right-Up
+
| Cover Right-Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cut
+
| Cut
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| No effect
+
| No effect
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Cut Through Black
+
| Cut Through Black
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| No effect
+
| No effect
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Dissolve
+
| Dissolve
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Dissolve
+
| Dissolve
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Fade Through Black
+
| Fade Through Black
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade Through Black
+
| Fade Through Black
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Random Bars Horizontally
+
| Random Bars Horizontally
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Random Bars Horizontal
+
| Random Bars Horizontal
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Random Bars Vertically
+
| Random Bars Vertically
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Random Bars Vertical
+
| Random Bars Vertical
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Horizontal In
+
| Horizontal In
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Split Horizontal In
+
| Split Horizontal In
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Horizontal Out
+
| Horizontal Out
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Split Horizontal Out
+
| Split Horizontal Out
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Split Vertical In
+
| Split Vertical In
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Split Vertical In
+
| Split Vertical In
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Split Vertical Out
+
| Split Vertical Out
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Split Vertical Out
+
| Split Vertical Out
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Strips Left Down
+
| Strips Left Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Top Right
+
| Fade From Top Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Strips Left Up
+
| Strips Left Up  
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Bottom Right
+
| Fade From Bottom Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Strips Right Down
+
| Strips Right Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Top Left
+
| Fade From Top Left
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Strips Right Up
+
| Strips Right Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Fade From Bottom Left
+
| Fade From Bottom Left
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Down
+
| Uncover Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Down
+
| Uncover Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Left
+
| Uncover Left
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Left
+
| Uncover Left
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Right
+
| Uncover Right
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Right
+
| Uncover Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Up
+
| Uncover Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Up
+
| Uncover Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Left Down
+
| Uncover Left Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Left-Down
+
| Uncover Left-Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Left Up
+
| Uncover Left Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Left-Up
+
| Uncover Left-Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Right Down
+
| Uncover Right Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Right-Down
+
| Uncover Right-Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Uncover Right Up
+
| Uncover Right Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Uncover Right-Up
+
| Uncover Right-Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Wipe Down
+
| Wipe Down
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Wipe Down
+
| Wipe Down
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Wipe Left
+
| Wipe Left
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Wipe Left
+
| Wipe Left
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Wipe Right
+
| Wipe Right
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Wipe Right
+
| Wipe Right
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Wipe Up
+
| Wipe Up
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Wipe Up
+
| Wipe Up
  
 
|-
 
|-
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:none;padding:0.079cm;"| Random Transition
+
| Random Transition
| style="border-top:none;border-bottom:0.05pt double #808080;border-left:0.05pt double #808080;border-right:0.05pt double #808080;padding:0.079cm;"| Random Transition
+
| Random Transition
  
 
|}
 
|}
  
{| style="border-spacing:0;"
 
|| Content on this page is licensed under the&nbsp;[http://creativecommons.org/licenses/by/3.0/ Creative Common Attribution 3.0 license (CC-BY)].
 
 
|}
 
[https://wiki.openoffice.org/wiki/Special:Categories Category]:&nbsp;
 
  
* [https://wiki.openoffice.org/wiki/Category:CC-BY_License CC-BY License]
+
{{CCBY}}

Latest revision as of 13:25, 14 July 2018



Sharing in a Mixed application Environment

Documentation note.png Migration is people issue, not a software issue

Most migration difficulties occur because of incompatibility issues. No two document production applications will always have 100% fidelity, not even if those two applications are just different versions of the same programme. So one of the essential tasks in a successful migration is to identify infidelity risks and thus reduce user frustration. Often the problems that occur are not actually caused by the migration but are areas that have always been problematic but it was easier for users to work around than complain. Migration support desks will inevitably end up fielding calls that have nothing to do with the migration but has been a point of frustration for some time.

Many of these can be minimised by the adoption of some simple policies:

  1. Ensure all computers in the organisation have the same font set. This is especially important where there is a variation in Operating systems
  2. Put in place policies for document collaboration, for instance establish standard fonts for use in documents
  3. Make available a set of templates on the network that covers all document instances that there needs to be collaboration.
  4. Ensure that all machines use the same default template


File formats

This section gives a simplified overview of Apache OpenOffice’s file format.

By default Apache OpenOffice stores its files in Open Document Format (ODF), ISO/IEC 26300. For details about ODF, see here.

Older versions of Microsoft Office files are stored in a proprietary format which is not human readable and not publicly documented. Newer versions of MS Office can now edit and save in ODF.

File extensions for Apache OpenOffice 4.0.
Document type Application Extension MS Office equiv
Text Writer odt doc, docx
Text Template Writer ott dot
Master Document Writer odm doc, docx
HTML document Writer html html
Spreadsheet Calc ods xls, xlsx
Spreadsheet Template Calc ots xst
Drawing Draw odg N/A
Drawing Template Draw otg N/A
Presentation Impress odp ppt, pptx
Presentation Template Impress otp pot
Formula Math odf N/A
Chart Chart odc N/A
Database Base odb mdb

Although Apache OpenOffice can open Microsoft Office files. The reverse is not always true. Microsoft Office has various degrees of support for ODF, starting in Office 2007, but earlier versions: MSO '97, Office XP etc, are not able to open, read or write ODF documents. For this reason, it is essential, during Migration setup, to identify your document users and their needs to ensure the minimisation of compatibility issues. For example:

  • Internal usage -- Use Native file format (OD*)
  • External User Non AOO user - Editable -- Save as *.doc (2000, XP)
  • External User AOO user - Editable -- Use Native file format (OD*)
  • External User - Editable not needed -- Use PDF.
  • Archive -- Always use ODF

Identifying these User needs and getting staff to work within those parameters should be part of a pre Migration training programme.

OpenOffice can not open or convert Microsoft Access files (.mdb) files directly, however it can access the data in the tables using DAO and ODBC. See the Database Guide for more information.}}

Bulk conversion

To use Apache OpenOffice to convert a lot of files, click File > Wizards > Document Converter.

Before doing a bulk conversion of files, think about whether it is really necessary. Read this document right through to get an appreciation of the limitations of the conversion process.

Opening files

Opening text documents

In addition to the native OpenDocument formats (.odt and .ott), Apache OpenOffice Writer can import the following text document formats:


Microsoft Word 6.0/95/97/2000/XP) (.doc, .dot)
Microsoft Word 2003 XML
Microsoft Office XML docx
Microsoft Winword 5 .doc
WordPerfect Document .wpd
WPS 2000/Office 1.0 .wps
AportisDoc (Palm) .pdb
Pocket Word .psw
Rich Text format .rtf,
Text .txt, .csv

When opening .HTM or .HTML files, OpenOffice.org customizes Writer for working with these files.

Opening spreadsheets

In addition to the native OpenDocument formats (.ods and .ots), OpenOffice.org Calc 2.0 can open the following spreadsheet formats:


Microsoft Excel 97/2000/XP (.xls, .xlw, .xlt) Rich Text Format (.rtf)
Microsoft Excel 4.x–5/95 (.xls and .xlw, .xlt) Text CSV (.csv and .txt)
Microsoft Excel 2003 XML (.xml) Lotus 1-2-3 (.wk1 and .wk1)
Data Interchange Format (.dif) StarCalc formats (.sdc, .vor)
dBase (.dbf) SYLK (.slk)
.htm and .html files including Web page queries Pocket Excel (pxl)
Quattro Pro 6.0 (.wb2)

Opening presentations

In addition to the native OpenDocument formats (.odp and .otp), OpenOffice.org Impress 2.0 can open the following presentation formats:


Microsoft PowerPoint 97/2000/XP (.ppt, .pps) Computer Graphics Metafile (.cgm)
Microsoft PowerPoint 97/2000/XP Template (.pot) StarDraw, StarImpress (.sda, .sdd, .sdp, .vor)

Opening graphics files

In addition to the native OpenDocument formats (.odg, and .otg), OpenOffice.org Draw 2.0 can open the following graphic formats:

BMP, JPEG/JPG, PCX, PSD, SGV, WMF, DXF, MET, PGM, RAS, SVM, XBM, EMF, PBM, PLT, SDA, TGA, XPM, EPS, PCD, PNG, SDD, TIF/TIFF, GIF, PCT, PPM, SGF, VOR


Opening formula files

In addition to OpenDocument Formula files, OpenOffice.org Math 2.0 can open the StarMath (.smf) and MathML (.mml) files.

When opening a Word document that contains an embedded equation editor object, select the [L] checkbox for MathType to OpenOffice.org Math/OpenOffice.org Math to MathType in Tools > Options > Load/Save > Microsoft Office and the object will be automatically converted to an OpenOffice.org Math object.

Saving files

Default file format

OpenOffice.org saves files in the OpenDocument format by default unless told otherwise. This default can be changed, for example if you always want to save as Microsoft Office files. To change the default file formats:

  1. Go to Tools > Options > Load/Save > General.
    Figure 1:Choosing default formats for saving files
  2. In the Standard File Format section of this page, choose a document type (for example, “Text document”) and a file format from the Always save as list.
  3. Repeat for each document type as necessary.
  4. Click OK to save your changes.
Documentation note.png If the option “Warn when not saving in OpenDocument or default format” is checked on the Options - Load/Save - General dialog, a warning dialog about potential loss of formatting may be displayed. In most cases, no loss of formatting will occur, so you may find this warning annoying and choose to disable it.

The Java Runtime Environment is required to use the mobile device filters for AportisDoc (Palm), Pocket Word and Pocket Excel.

Export to PDF and XHTML

Each application has the ability to directly export to PDF (Portable Document Format). This industry-standard format for universal file compression and viewing is ideal for sending the file to anyone else to view using Acrobat Reader or any other PDF display program on any operating system.

You can export directly to PDF using the button on the toolbar next to the Printer icon, or by choosing File > Export as PDF, which allows you to select some detailed options.

To export as XHTML, use File > Export and for File format choose XHTML In the dropdown box.

Saving files in other formats

To save files in different formats, use File > Save As and select a format from the File Type dropdown box.

Figure 2: The OpenOffice.org Save As dialog, showing some of the Save formats

Writer can save to these file formats

In addition to its native formats, Writer can save in these formats:

OpenOffice.org Writer 1.x (.sxw, .stw)

Microsoft Word 97/2000/XP (.doc)

Microsoft Word 95 (.doc)

Microsoft Word 6.0 (.doc)

Microsoft Word 2003 XML (.xml)

Microsoft Pocket Word (.psw)

DocBook (.xml)

Aportis Doc (Palm) (.pdb)

Rich Text Format (.rtf)

StarWriter 5.0 (.sdw)

StarWriter Template (.vor)

StarWriter 4.0 (.sdw)

StarWriter 4.0 Template (.vor)

StarWriter 3.0 (.sdw)

StarWriter Template 3.0 (.vor)

Text (.txt)

Text Encoded (.txt)

HTML (.html; .htm)

Documentation note.png The .rtf format is commonly used for transferring text files between applications, but you are likely to experience loss of formatting and images when the file is opened by Microsoft Office. The best way to pass a file in Writer to a Microsoft Word user is to save it as Microsoft Word 97/2000/XP (.doc).

Calc can save to these file formats

In addition to its native formats, Calc can save in these formats:

OpenOffice.org Calc 1.x (.sxc, .stc)

Microsoft Excel 97/2000/XP (.xls; .xlw)

Microsoft Excel 97/2000/XP Template (.xlt)

Microsoft Excel 95 (.xls; .xlw)

Microsoft Pocket Excel (.pxl)

Microsoft Excel 2003 XML (.xml)

Data Interchange Format (.dif)

dBase (.dbf)

SYLK (.slk)

Text CSV (.csv; .txt)

StarCalc formats (.sdc, .vor)

HTM and HTML files

Impress can save to these file formats

In addition to its native formats, Impress can save in these formats:

Microsoft PowerPoint 97/2000/XP (.ppt; .pps)

Microsoft PowerPoint 97/2000/XP Template (.pot)

StarDraw, StarImpress (.sda, .sdd, .vor)

Impress can also export to MacroMedia Flash (.swf) and any of the graphics formats as listed below for Draw.

Draw can save to these file formats

Draw can only save in its native and StarDraw formats, but it can export to:

BMP, EMF, EPS, GIF, JPEG, MET, PBM, PCT, PGM, PNG, PPM, RAS, SVG, SVM, TIFF, WMF, XPM

The HTML writer can save in these formats

HTML Document (.html; .htm)

OpenOffice.org 1.0 HTML Template (.stw)

OpenOffice.org 2.0 HTML Template (.oth)

StarWriter/Web 5.0 and 4.0 (.vor)

Text (OpenOffice.org Writer/Web) (.txt)

Text Encoded (OpenOffice.org Writer/Web) (.txt)

Object Linking and Embedding (OLE)

To change the settings for Microsoft Office OLE objects, use Tools > Options > Load/Save > Microsoft Office.

Having all of these options checked allows embedded objects to be converted and thus be editable in both office suites.

For other OLE objects, it will depend on the machine where the file is being edited just as it does with Microsoft Office alone. Thus Windows application based OLE objects will not be editable in OpenOffice.org on a Linux machine, although the object will still be displayed correctly and can be resized.

Figure 3: Choosing Load/Save VBA Properties

Linked files

Cells copied from Excel and pasted special, linked and with RTF format, into Word are imported into Writer as a normal table. This means that when the document is imported, the link to the Excel file is lost.

Similarly when a chart is copied from Excel and pasted special, linked into Word, and then the file imported into Writer, the chart is imported as an embedded OLE object but is not converted into a Calc chart. On saving the file in Word format and then opening the file in Word and trying to edit the chart by double-clicking, it displays an error message.

Documentation caution.png Links in Microsoft Office files between Word and Excel are lost when the Microsoft office files have been edited by OpenOffice.org.

WordArt and Fontwork

The equivalent to Microsoft Office’s WordArt in OpenOffice.org is Fontwork. WordArt objects are imported as Fontwork objects; they may look slightly different on import. Fontwork objects are automatically exported to WordArt objects when the document is saved in a Microsoft Office format.

Vector graphics

The basic shapes (lines, arrows, rectangles, ovals) all import and export without any problem. OpenOffice.org provides a greater degree of control over some properties than Microsoft Office does, so sometimes there will be changes when going from OpenOffice.org to Microsoft Office. Examples include the size of arrow heads, and line styles.

The Microsoft Office autoshapes, such as the smiley face, keep their special characteristics, for instance the ability to adjust the degree of the smile or frown on the smiley face.

Microsoft Office provides more shadow options than OpenOffice.org, so sometimes there will be a change in shadow appearance. Microsoft Office shadow styles 1, 2, 4, 6, 14, 17 and 18 are supported in OpenOffice.org. Horizontal and tapered shadows do not get imported and any 3D effect on the bottom left is ignored.

Frames and text boxes

When frames or text boxes from Microsoft Office are imported into OpenOffice.org with linked text, the links are lost.

Active content controls

These are the controls in Microsoft Office available on the Controls toolbar; they all import without a problem. However, as these controls typically require macros to be of use, they will be functionally useless in the absence of macros custom built for use in OpenOffice.org.

Macros

OpenOffice.org cannot run Microsoft Office macros. Although the macro language is very similar, the underlying objects are quite different. To set whether OpenOffice.org keeps attached macros (so that they are still available for use in Microsoft Office) for Word, Excel and PowerPoint files, use Tools > Options > Load/Save > VBA Properties.

Documentation note.png Opening a Microsoft Office file infected with a macro virus is quite safe in OpenOffice.org.

OpenOffice.org has the ability to record macros. It is better practice to use the application program interface (API).

Import, export and sharing issues in text documents

Good practice in text documents

Some issues can be avoided simply by using good word-processing practice:

  • Use character and paragraph styles rather than direct formatting.
  • Use paragraph formatting for space before and after rather than hard returns, particularly in numbered or bulleted lists.
  • Use paragraph text flow properties (for example, keep with next) rather than using manual page breaks.
  • Do not use multiple tabs or spaces to align text – either set specific tab stops or better yet use a table.
  • Use only commonly available fonts.

Compatibility settings in OpenOffice.org for the current document

The following settings change the way OpenOffice.org works with the current document so that it works more like Microsoft Office.

Use Tools > Options > OpenOffice.org Writer > Compatibility.

Figure 4: Choosing compatibility options

Add paragraph and table spacing at tops of pages (in current document)

In Writer, with this setting unchecked, if a paragraph at the top of the page (or column) is formatted with space above then that space is ignored; whereas in Word the space above is included. Checking this option causes Writer to behave in the same way as Word.

Use OpenOffice.org 1.1 tabstop formatting

This setting specifies whether centered and right-aligned paragraphs containing tabs are formatted as a whole in the center or aligned to the right. If this checkbox is checked, only the text to the right of the last tab is aligned to the right, while the text to the left remains as is.

Use OpenOffice.org 1.1 line spacing

Writer uses the greater of the two spacings for above and below paragraphs; Word sums the two together. Uncheck this box to have Writer behave in the same way as Word.

Font and font spacing

Text effect animations are imported by Writer with the character attribute of blinking from Word files. For example “Marching red ants” simply becomes “blinking”.

Typically Word’s character spacing is tighter than Writer’s, so often Word will fit more characters to a line. It is also possible that the spacing between lines could be slightly different. The end result is that the page breaks may be in different places.

Tables

The author could find no issues with tables.

Mail merge documents

As OpenOffice.org has a different approach to data sources. On importing a Word document that is the main document for a mail merge, there is no connection with the data source. It is not just a matter of making that connection; each field needs to be reinserted. See the Mail Merge section in the chapter titled “Differences in use between Writer and Word”.

Also in Word you can have another Word document as a data source for a mail merge. There is no way of specifying a Word (or Writer) document as a data source in OpenOffice.org.

Writer does not have the option of suppressing blank lines when data fields are empty, so you need to use conditional fields.

Writer merge fields export as text with the name of the field between angle brackets, for example <Name>.

Summary: To work in a shared environment would require a separate file for each “main document”: one in Word format, the other in OpenOffice.org format. If you have a master mail merge document in Word format, it is probably easiest to paste the text into Writer and use the Writer mail merge wizard to recreate the mail merge from scratch.

Forms

Issues with forms created in Microsoft Office

A locked file in Microsoft Office imports unlocked into OpenOffice.org; that is, in design mode.

Text form fields import into OpenOffice.org as Input fields and so lose their type. For example, a text form field of type “number” or “date” will accept any text for input. In use a text form field in OpenOffice.org displays a dialog for entering the text. Exporting back to Microsoft Office, text form fields are changed into “Fillin” fields. The current date and time and calculation fields import as simple text.

Checkboxes import and export correctly.

Drop-down form fields import as Input List fields. Like text form fields in operation these display a dialog from which the user can select an option. On export back to Microsoft Office they return to drop-down form fields again.

Issues with forms created in OpenOffice.org

The controls are exported as active controls when there is a Microsoft Office equivalent. As Word does not have the same database functionality of OpenOffice.org and as the macros are not compatible, it would be very difficult to have one form that works in both environments using standard form controls.

Summary: To work in a shared environment with forms is not easy, but one workaround would be to use other fields like Input field and Input List. To insert these fields, use Insert > Fields > Other > Functions.

Footnotes, endnotes, tables of contents and indexes

Footnotes, endnotes and indexes all import / export correctly. Some issues have been found:

  • The location of the endnotes may change (in Word the endnotes are placed before the index. In Writer they are always at the end of the document).
  • Writer bibliographic entries become text in Word.
  • A three-column index exported from Writer to Word as three columns but on re-import it was one column.
  • On importing a Word file containing index entry fields, the index entry fields are imported but as fields to the left of the text rather than the field containing the text.

Summary: Working in a shared environment is possible with some minor issues.

Numbered paragraphs, outline numbering, cross-references

Numbered paragraphs, outline numbering, and cross-references import / export without a problem, except for references to numbered paragraphs:

  • Cross-references to the numbers of numbered paragraphs that are not numbered using outline numbering do not work as Writer does not have this ability.
  • Writer also does not have the ability to use relative numbering in its cross-references to numbers.
  • Cross-references to chapter numbers do not have the same format as that displayed.

Page numbering

A quick and dirty approach in Word for having a different first page (like a cover page) and then to have the numbering start on the second page but numbered as page 1 is to have a layout of different first page and setting the starting page to be zero. Unfortunately, on importing such a file into OpenOffice.org the page number on the second page is 2 instead of 1. To fix this problem in Writer:

  1. Create a page style for how the pages after the first page should look. Name it (for example) Convert1.
  2. Have the cursor in the first paragraph of the second page.
  3. Format > Paragraph > Text Flow.
  4. In the Breaks portion of the dialog, select the checkbox Insert.
  5. Check With Page Style.
  6. Choose the page style created in step 1.
  7. Leave the position as Before and set the page number to 1.

On exporting this document back to Word it will work, the only difference being that the document will have a section break at the end of the first page. Documents created with section breaks like this in Word will work fine importing and exporting with Writer. There is one difference with Word: now there will be a blank page between the cover page and the next page when printed (or print previewed).

In the author’s testing a document with different formats for odd and even page numbering, the odd page numbers were imported as the text of the first odd page rather than as a field.

Summary: For some documents a little work maybe required to fix up the page numbering on importing to Writer. Once “fixed” the page numbering of the documents will import / export without a problem.

Date and time fields

Word’s CreateDate and SaveDate fields do not get imported with the same formats. For example, if the fields in the Word document have a format that includes time, then this information is not displayed by default. To include time in the format:

Right-click on the field > Fields > scroll to the bottom of the Formats listbox > Additional formats > in format code add HH:MM:SS

On export the SaveDate / DocInformation:Modified is exported as text.

Writer’s Time Fixed and Date Fixed fields get exported as text.

Importing Word fields

Imported Word fields conversion
Word field: Writer converts to:
ASK Input field
AUTHOR DocInformation:Created
AUTONUM Number Range AutoNr
AUTONUMLGL Number range AutoNr
AUTONUMOUT Number range AutoNr
COMMENTS DocInfomation:Comments
CREATEDATE DocInformation:Created
DATE Date
EDITTIME DocInformation:Modified
FILENAME File name
FILLIN Input field
HYPERLINK (as a hyperlink)
INFO xxx DocInformation:xxx
KEYWORDS DocInformation:Keywords
LASTSAVEDBY DocInformation:Modified
MACROBUTTON (the name of the macro?)
MERGEFIELD Mail merge fields (displayed as the name of the field)
MERGEREC Record number
NEXT Next record
NOTEREF Show variable
NUMCHARS Statistics (with select = Characters)
NUMPAGES Statistics (with select = Pages)
PAGE Page numbers
PAGEREF Bookmarks (displayed as name of bookmark)
REVNUM DocInformation:Document number
SAVEDATE DocInformation:Modified
SEQ Number range
SET Set variable
SUBJECT DocInformation:Subject
TEMPLATE Templates
TIME Date
TITLE DocInformation:Title
TOC (Displays the table of contents)

The following fields are not imported into OpenOffice.org (only the text that they displayed when last saved): =, IF, DOCPROPERTY, FILESIZE, LINK, LISTNUM, QUOTE, SECTION, SECTIONPAGES, STYLEREF, TOA, USERADDRESS, USERINITIALS, USERNAME.

The following fields are ignored on import: AUTOTEXT, AUTOTEXTLIST, BARCODE, BIDIOUTLINE, DOCVARIABLE, EQ, GOTOBUTTON, INCLUDETEXT, LISTNUM, MERGESEQ, PRINT, RD, SKIPIF, SYMBOL, TA, TC.

The Word field EDITTIME is mapped to Writer field DocInformation:Modified on import but the meaning has changed to the date and time last saved rather than how long the file has been open for editing.

Import, export and sharing issues in spreadsheets

Form fields

Combo boxes, list boxes and checkboxes with links to spreadsheet cells all import and export properly, although due to font handling the number of rows displayed in list boxes may be slightly different. List boxes in Calc can either have multi-selection or not, whereas Excel has two multi-selection modes: multi and extend. In Excel a link from a multi-selection listbox to a cell is ignored (at least in Excel 2000; the author has not checked Excel XP). In Calc the link works, but if more than one item is selected, the cell’s value is set to #N/A.

Option buttons import into Calc, but the link with cells works differently. In Calc each option button has its own link to a cell, setting its value to true or false depending on whether the option is selected. In Excel the cell link returns the number of the selected option button. On exporting option buttons to Excel, the option buttons lose their radio operation; in other words, they are not grouped so that selecting one “unselects” the others.

Scroll bars and spinners are now implemented in Calc, but are not imported yet.

Array constants

Array constants are not available in OpenOffice.org. The workaround is to have the constant values in cells on a sheet and refer to them. Array constants used as parameters to a function in Excel are omitted when imported into Calc.

Optional parameters in formulas

Some formulas have more than one optional parameter at the end of the parameter list. In Excel it is possible to leave an optional parameter blank and specify a later parameter, but this is not possible in Calc. Formulas with optional parameters are not correctly imported into Calc.

Functions

Statistical, engineering and financial functions

In Excel some of the financial functions accept string parameters for dates; in OpenOffice.org they require a serial number, and thus they are not correctly imported into Calc.

Analysis ToolPak Functions

The function EFFECT provided by the Analysis ToolPak for Excel is converted to EFFECT_ADD in Calc and returns the same results.

Other functions not implemented / imported

Only three other functions are not imported: INFO, GETPIVOTDATA, and HYPERLINK. Hyperlinks are supported but not as a function; use the Hyperlink button on the Function bar.

DataPilot—Pivot Table

DataPilots are Calc’s equivalent to Excel’s Pivot Tables. However there are a number of limitations. Pivot tables import from Excel into Calc (although the cells do not have the PivotTable shading) but as soon as they are worked on these limitations become apparent. The limitations are:

  • There is no PivotChart facility, but a DataPilot can be used as the data source for a chart.
  • The user interface allows a maximum of 8 fields in the data, row or column areas. (An alternative interface which allows more is available from: http://homepages.paradise.net.nz/hillview/OOo/ in a document called MyDataPilot.sxc.
  • There is some ability to group data (for example, a date field grouping by week or quarter but not by month). The workaround is to create a new column with a formula for calculating the grouping, e.g. =Month().
  • You can not define different formats for different fields.
  • Calc can have formulas based on things like “Difference From” or “% of”, but can not have own custom fields (work around create new columns to calculate the desired values).
  • The Application Program Interface specification is incomplete for writing macros that work with DataPilots—for example, the ability to control through another program, such as OpenOffice.org’s own macro language, BASIC, whether the tables have grand totals, or having access to DataPilots created from external data.

AutoFilter

AutoFilter imports and exports correctly with the required rows being hidden. However, there are a number of differences between Excel and Calc:

  • There is only one AutoFilter active for a spreadsheet document at a time. The rows remain hidden but the drop-downs in the first row disappear on applying AutoFilter elsewhere.
  • The remaining visible row numbers do not change color to warn that there is a filter in place.
  • Error values do not show as an option in the drop down lists when cells in the column have errors.
  • In the drop down lists, the equivalent to Excel’s “Custom” is called “Standard”.

Charts

Chart types that Excel provides but Calc does not:

  • Bar of pie converts to a 2D – columns – normal.
  • Pie of pie converts to a 2D – columns – normal.
  • Radar filled converts to 3D – columns deep.
  • Radar with markers – converts to 2D – net – normal but counterclockwise rather than Excel’s clockwise.

Other charting issues include:

  • There are fewer axis options, such as no option for having an inverted y axis (negative at top towards positive at bottom).
  • The data must be contiguous, with the labels in the first row or column.

Number formats

There is no “accounting” format (with the currency symbol at the left edge of the cell). A workaround would be to have another column to the left that contains the currency symbol.

There is no predefined option for bracketing negative numbers. Use a custom format such as “$#,##0.00_);[RED]($#,##0.00)”.

Grid lines

In Excel grid lines are a property of a worksheet; in Calc it is an application-wide option:

Tools > Options > OpenOffice.org Calc > View

Import, export and sharing issues in presentations

Color gradients and borders

The author had not noticed the following changes, so this is a direct quote from StarOffice 7 Migration Guide by Sun.

Unlike Microsoft PowerPoint, StarOffice Impress does not support three-color gradients, double and triple borders, or round-dotted borders. To improve the results of the import, you have to make the necessary adjusts before import. Change three-color presets to similar two-color gradient fills and change double and triple border lines to a single border line with appropriate width. Round-dotted border lines that are mapped to rectangle-border closely resemble the original line style in PowerPoint, so manual editing should not be necessary.

Multimedia

Voice-over narration is not supported by Impress.

There appear to be no settings for multimedia custom animations, such as the ability to play a sound for the next slides.

Chart animations

There is no facility in Impress for “chart effects” as there is in PowerPoint, such as presenting a series or category at a time. On import the charts simply appear. A workaround is to have multiple copies of the chart with each one set up to display as desired.

Pack and Go

The Pack and Go feature in PowerPoint allowed a PowerPoint file to be split over several floppy disks and assured that all related files were included. This facility is not included in Impress, nor can Impress open such files.

Fields

Date fields are exported as text, so they do not automatically update.

Action settings and interaction

PowerPoint provides action settings for mouseover, but Impress does not have this option, only on mouse click, so mouseovers get mapped to mouse clicks. PowerPoint has an option for highlighting the object on mouse click or mouse over; Impress does not have this, so it gets ignored on import.

PowerPoint custom animations and Impress object effects

Table 3 shows how the custom animations and object effects are imported into Impress and exported to PowerPoint.

Importing / exporting custom animations between PowerPoint and Impress
PowerPoint Impress
Appear Appear
Blinds Fade Horizontally
Box Fade To Center
Checkerboard Checkerboard
Diamond Appear
Crawl Fly In From bottom
Dissolve Dissolve
Flash once Appear
Peek Short Fly In from Bottom
Random Bars Horizontal lines
Spiral Spiral Outward Clockwise
Split Close Vertical
Stretch Stretch Vertical
Strips Fade From Top Right
Swivel Rotate Horizontally
Wipe Cross-Fade From Top
Zoom Fade From Center
Random effects Vertical Lines

PowerPoint—Impress slide transitions

Table 4 shows how slide transitions are imported into Impress and exported to PowerPoint.
PowerPoint Impress
Blinds Horizontal Venitian Blinds Horizontal
Blinds Vertical Venitian Blinds Vertical
Box In Box In
Box Out Box Out
Checkerboard Across Checkerboard Across
Checkerboard Down Checkerboard Down
Cover Down Cover Down
Cover Left Cover Left
Cover Right Cover Right
Cover Up Cover Up
Cover Left Down Cover Left-Down
Cover Right Down Cover Right-Down
Cover Left Up Cover Left-Up
Cover Right Up Cover Right-Up
Cut No effect
Cut Through Black No effect
Dissolve Dissolve
Fade Through Black Fade Through Black
Random Bars Horizontally Random Bars Horizontal
Random Bars Vertically Random Bars Vertical
Horizontal In Split Horizontal In
Horizontal Out Split Horizontal Out
Split Vertical In Split Vertical In
Split Vertical Out Split Vertical Out
Strips Left Down Fade From Top Right
Strips Left Up Fade From Bottom Right
Strips Right Down Fade From Top Left
Strips Right Up Fade From Bottom Left
Uncover Down Uncover Down
Uncover Left Uncover Left
Uncover Right Uncover Right
Uncover Up Uncover Up
Uncover Left Down Uncover Left-Down
Uncover Left Up Uncover Left-Up
Uncover Right Down Uncover Right-Down
Uncover Right Up Uncover Right-Up
Wipe Down Wipe Down
Wipe Left Wipe Left
Wipe Right Wipe Right
Wipe Up Wipe Up
Random Transition Random Transition


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools