About Import and Export Filters

In Collabora Office, apart from its own XML formats you can also open and save many foreign XML formats.

There may be cases where you have to select the file type yourself in the Open dialog. For example, if you have a database table in text format that you want to open as a database table, you need to specify the file type "Text CSV" after selecting the file.

BASIC Macros in Microsoft Office Documents

In - Load/Save - VBA Properties you can specify the settings for the VBA macro codes in MS Office documents. VBA macros are unable to run in Collabora Office; they must first be converted and adapted. Often you only want to use Collabora Office to change the visible content of a Word, Excel or PowerPoint file and then save the file again in Microsoft Office format without changing the macros they contain. You can set the behavior of Collabora Office as desired: Either the VBA macros are saved in commented form as a subroutine of Collabora Office and when the document is saved in MS Office format are written back correctly again, or you can select the Microsoft Office macros to be removed when loading. The last option is an effective protection against viruses within the Microsoft Office documents.

Notes regarding external formats and file types

Even if they are not installed, some filters can be selected in the Open and Save dialogs. If you select such a filter, a message will appear saying that you can still install the filter if you require.

Importing and Exporting in HTML Format

With Collabora Office Writer, you can insert footnotes and endnotes in your HTML document. They are exported as meta tags. The footnote and endnote characters are exported as hyperlinks.

Comments are used to include unknown characters in an HTML document. Every note that begins with "HTML:..." and ends with ">" is treated as an HTML code, but is exported without these designations. Several tags around text can be included after "HTML:..." Accented characters are converted into the ANSI character set. Comments are created during import (for example, for meta tags that have no room in the file properties or unknown tags).

The HTML import of Collabora Office Writer is able to read files that have UTF-8 or UCS2 character coding. All characters that are contained in the ANSI character set or in the system's character set can be displayed.

When exporting to HTML, the character set selected in - Load/Save - HTML Compatibility is used. Characters not present there are written in a substitute form, which is displayed correctly in modern web browsers. When exporting such characters, you will receive an appropriate warning.

If, in - Load/Save - HTML Compatibility, you select Mozilla Firefox or Collabora Office Writer as the export option, upon export all important font attributes are exported as direct attributes (for example, text color, font size, bold, italic, and so on) in CSS1 styles. (CSS stands for Cascading Style Sheets.) Importing is also carried out according to this standard.

The "font" property corresponds to Mozilla Firefox; that is, before the font size you can specify optional values for "font-style" (italic, none), "font-variant" (normal, small-caps) and "font-weight" (normal, bold).

• For example, "Font: bold italic small-caps 12pt/200% Arial, Helvetica" switches to bold, italic, small caps, double-space with the font family Arial or Helvetica, if Arial doesn't exist.

• "Font: 10pt" switches to a 10pt font, with bold, italic, small caps off.

If Collabora Office Writer are set as the export option, the sizes of the control field and their internal margins are exported as styles (print formats). CSS1 size properties are based on "width" and "height" values. The "Margin" property is used to set equal margins on all sides of the page. To allow different margins, the "Margin-Left", "Margin-Right", "Margin-Top" and "Margin-Bottom" properties are used.

The distances of graphics and Plug-Ins to the content can be set individually for export to Collabora Office Writer. If the top/bottom or right/left margin is set differently, the distances are exported in a "STYLE" option for the corresponding tag as CSS1 size properties "Margin-Top", "Margin-Bottom", "Margin-Left" and "Margin-Right".

Frames are supported with the use of CSS1 extensions for absolute positioned objects. This applies only to the export options Mozilla Firefox and Collabora Office Writer. Frames can be aligned as graphics, and Floating Frames, but character-linked frames are not possible.

Frames are exported as "<SPAN>" or "<DIV>" tags if they do not contain columns. If they do contain columns then they are exported as "<MULTICOL>".

The measurement unit set in Collabora Office is used for HTML export of CSS1 properties. The unit can be set separately for text and HTML documents under - Collabora Office Writer - General or - Collabora Office Writer/Web - View. The number of exported decimal places depends on the unit.

Measurement Unit	Measurement Unit Name in CSS1	Maximum Number of Decimal Places
Millimeter	mm	2
Centimeter	cm	2
Inch	in	2
Pica	pc	2
Point	pt	1

The Collabora Office Web page filter supports certain capabilities of CSS2. However, to use it, print layout export must be activated in - Load/Save - HTML Compatibility. Then, in HTML documents, besides the HTML Page Style, you can also use the styles "First page", "Left page" and "Right page". These styles should enable you to set different page sizes and margins for the first page and for right and left pages when printing.

Importing and Exporting Numbering

If, in - Load/Save - HTML Compatibility, the export option "Collabora Office Writer" is selected, the indents of numberings are exported as "margin-left" CSS1 property in the STYLE attribute of the <OL> and <UL> tags. The property indicates the difference relative to the indent of the next higher level.

A left paragraph indent in numbering is indicated as "margin-left" CSS1 property. First-line indents are ignored in numbering and not exported.

Importing and Exporting Spreadsheet Files

Collabora Office imports and exports references to deleted sections such as, for example, a referenced column. The whole formula can be viewed during the export process and the deleted reference contains an indication (#REF!) to the reference. A #REF! will be correspondingly created for the reference during the import.

Importing and Exporting Graphics Files

As with HTML documents, you can choose to use a filter with or without the element (Collabora Office Impress) in the name to open a Collabora Office graphics file. If without, the file will be opened as a Collabora Office Draw document. Otherwise, the file saved by an old program version is now opened in Collabora Office Impress.

When you import an EPS file, a preview of the graphic is displayed in the document. If a preview is not available, a placeholder corresponding to the size of the graphic is displayed in the document. Under Unix and Microsoft Windows you can print the imported file by using a PostScript printer. When exporting EPS graphics, a preview is created and has the TIFF or EPSI format. If an EPS graphic together with other graphics is exported in the EPS format then this file will be embedded unchanged in the new file.

Multipage-TIFFs are allowed when graphics are imported or exported in TIFF format. The graphics are retrieved as a set of individual pictures in a single file, for example, the individual pages of a fax.

Some Collabora Office Draw and Collabora Office Impress options can be accessed through File - Export. See Graphics Export Options for more information.

PostScript

To export a document or graphic in PostScript format:

1. If you have not yet done so, install a PostScript printer driver, such as the Apple LaserWriter driver.

2. Print the document with the File - Print menu command.

3. Select the PostScript printer in the dialog and mark the Print to file check box. A PostScript file will be created.