1<?xml version="1.0" encoding="UTF-8"?> 2 3 4 5<!-- 6 *********************************************************************** 7 * 8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9 * 10 * Copyright 2000, 2010 Oracle and/or its affiliates. 11 * 12 * OpenOffice.org - a multi-platform office productivity suite 13 * 14 * This file is part of OpenOffice.org. 15 * 16 * OpenOffice.org is free software: you can redistribute it and/or modify 17 * it under the terms of the GNU Lesser General Public License version 3 18 * only, as published by the Free Software Foundation. 19 * 20 * OpenOffice.org is distributed in the hope that it will be useful, 21 * but WITHOUT ANY WARRANTY; without even the implied warranty of 22 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23 * GNU Lesser General Public License version 3 for more details 24 * (a copy is included in the LICENSE file that accompanied this code). 25 * 26 * You should have received a copy of the GNU Lesser General Public License 27 * version 3 along with OpenOffice.org. If not, see 28 * <http://www.openoffice.org/license.html> 29 * for a copy of the LGPLv3 License. 30 * 31 ************************************************************************ 32 --> 33 34 35 <helpdocument version="1.0"> 36<meta> 37<topic id="textshared0000000020xml" indexer="include" status="PUBLISH"> 38<title id="tit" xml-lang="en-US">About Import and Export Filters</title> 39<filename>/text/shared/00/00000020.xhp</filename> 40</topic> 41</meta> 42<body> 43<bookmark xml-lang="en-US" branch="index" id="bm_id3152952"><bookmark_value>import filters</bookmark_value> 44<bookmark_value>export filters</bookmark_value> 45<bookmark_value>filters; for import and export</bookmark_value> 46<bookmark_value>files; filters and formats</bookmark_value> 47<bookmark_value>formats; on opening and saving</bookmark_value> 48<bookmark_value>importing; HTML and text documents</bookmark_value> 49<bookmark_value>exporting;HTML and text documents</bookmark_value> 50<bookmark_value>text documents; importing/exporting</bookmark_value> 51<bookmark_value>HTML documents; importing/exporting</bookmark_value> 52<bookmark_value>UTF-8/UCS2 support</bookmark_value> 53<bookmark_value>HTML; export character set</bookmark_value> 54<bookmark_value>PostScript; creating files</bookmark_value> 55<bookmark_value>exporting;to PostScript format</bookmark_value> 56</bookmark> 57<paragraph role="heading" id="hd_id3152952" xml-lang="en-US" level="1" l10n="U" oldref="1">About Import and Export Filters</paragraph> 58<paragraph role="paragraph" id="par_id3143272" xml-lang="en-US" l10n="U" oldref="2">In $[officename], apart from its own <link href="text/shared/00/00000021.xhp" name="XML formats">XML formats</link> you can also open and save many foreign XML formats.</paragraph> 59<paragraph role="paragraph" id="par_id3152414" xml-lang="en-US" l10n="U" oldref="3"><switchinline select="sys"><caseinline select="UNIX">In UNIX, certain file formats cannot be recognized automatically. 60</caseinline><defaultinline>$[officename] normally recognizes the correct file type automatically on opening a file.</defaultinline></switchinline> There may be cases where you have to select the file type yourself in the <emph>Open</emph> 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.</paragraph> 61<paragraph role="heading" id="hd_id3148668" xml-lang="en-US" level="2" l10n="U" oldref="238">Basic Macros in MS Office Documents</paragraph> 62<paragraph role="paragraph" id="par_id3156211" xml-lang="en-US" l10n="U" oldref="239">In <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01130100.xhp" name="Load/Save - VBA Properties">Load/Save - VBA Properties</link> you can specify the settings for the VBA macro codes in MS Office documents. VBA macros are unable to run in $[officename]; they must first be converted and adapted. Often you only want to use $[officename] 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 $[officename] as desired: Either the VBA macros are saved in commented form as a subroutine of $[officename] 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.</paragraph> 63<paragraph role="heading" id="hd_id3154232" xml-lang="en-US" level="2" l10n="U" oldref="5">Notes regarding external formats and file types</paragraph> 64<paragraph role="paragraph" id="par_id3154230" xml-lang="en-US" l10n="U" oldref="226">Even if they are not installed, some filters can be selected in the <emph>Open</emph> and <emph>Save</emph> dialogs. If you select such a filter, a message will appear saying that you can still install the filter if you require.</paragraph> 65<paragraph role="paragraph" id="par_id3149999" xml-lang="en-US" l10n="U" oldref="200"><switchinline select="sys"><caseinline select="WIN">If you want to install additional filters or remove individual filters from the installation, close %PRODUCTNAME, start the Setup program and select the <emph>Modify</emph> option. Then you will see a dialog in which you can add or remove individual components of %PRODUCTNAME. Graphic filters can be found in "Optional Components". 66</caseinline></switchinline></paragraph> 67<paragraph role="heading" id="hd_id3156027" xml-lang="en-US" level="3" l10n="U" oldref="7"><switchinline select="appl"><caseinline select="CALC"> 68</caseinline><caseinline select="DRAW"> 69</caseinline><caseinline select="IMPRESS"> 70</caseinline><defaultinline>Importing and Exporting Text Documents</defaultinline></switchinline></paragraph> 71<paragraph role="paragraph" id="par_id3145669" xml-lang="en-US" l10n="U" oldref="8"><switchinline select="appl"><caseinline select="CALC"> 72</caseinline><caseinline select="DRAW"> 73</caseinline><caseinline select="IMPRESS"> 74</caseinline><defaultinline>$[officename] Writer can read various versions of the Microsoft Word text format. You also can save your own texts in Word format. However, not everything available with $[officename] Writer can be transferred to MS Word, and not everything can be imported.</defaultinline></switchinline></paragraph> 75<paragraph role="paragraph" id="par_id3150144" xml-lang="en-US" l10n="U" oldref="233"><switchinline select="appl"><caseinline select="CALC"> 76</caseinline><caseinline select="DRAW"> 77</caseinline><caseinline select="IMPRESS"> 78</caseinline><defaultinline>Importing is normally not problematic. Even redlining information and controls are imported (and exported) so that $[officename] recognizes inserted or deleted text in Word documents as well as font attributes that have been modified. Different coloring for each author and the time of such changes is also included. When graphic text boxes and labels are imported from templates, most of the attributes are also imported as direct paragraph and drawing attributes. However, some of the attributes may be lost during the import procedure.</defaultinline></switchinline></paragraph> 79<paragraph role="paragraph" id="par_id3149095" xml-lang="en-US" l10n="U" oldref="10"><switchinline select="appl"><caseinline select="CALC"> 80</caseinline><caseinline select="DRAW"> 81</caseinline><caseinline select="IMPRESS"> 82</caseinline><defaultinline>It is also possible to import and export <link href="text/shared/00/00000005.xhp#rtf" name="RTF">RTF</link> files. This file format can be used to exchange formatted texts across various applications and platforms. In this way, many formats read by most programs will be transferred without a problem. The clipboard uses RTF format when you insert part of a spreadsheet from $[officename] Calc through <link href="text/shared/00/00000005.xhp" name="DDE">DDE</link> into $[officename] Writer.</defaultinline></switchinline></paragraph> 83<paragraph role="tip" id="par_id3151378" xml-lang="en-US" l10n="U" oldref="237">The filter <emph>Text Encoded</emph> helps you open and save text documents with another encoding font. The filter opens a dialog that enables you to select character set, default fonts, language and paragraph break.</paragraph> 84<paragraph role="heading" id="hd_id3149763" xml-lang="en-US" level="3" l10n="U" oldref="11">Importing and Exporting in HTML Format </paragraph> 85<paragraph role="paragraph" id="par_id3150244" xml-lang="en-US" l10n="U" oldref="198">With $[officename] 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.</paragraph> 86<paragraph role="paragraph" id="par_id3149800" xml-lang="en-US" l10n="U" oldref="199">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).</paragraph> 87<paragraph role="paragraph" id="par_id3149734" xml-lang="en-US" l10n="U" oldref="201">The HTML import of $[officename] 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.</paragraph> 88<paragraph role="paragraph" id="par_id3149578" xml-lang="en-US" l10n="U" oldref="240">When exporting to HTML, the character set selected in <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Load/Save - HTML Compatibility</emph> 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.</paragraph> 89<paragraph role="paragraph" id="par_id3153146" xml-lang="en-US" l10n="CHG" oldref="197">If, in <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Load/Save - HTML Compatibility</emph>, you select Netscape Navigator, MS Internet Explorer, or $[officename] 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. (<link href="text/shared/00/00000002.xhp" name="CSS">CSS</link> stands for Cascading Style Sheets.) Importing is also carried out according to this standard.</paragraph> 90<paragraph role="paragraph" id="par_id3154143" xml-lang="en-US" l10n="U" oldref="130">The "font" property corresponds to Netscape Navigator; 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).</paragraph> 91<list type="unordered"> 92<listitem> 93<paragraph role="listitem" id="par_id3153760" xml-lang="en-US" l10n="U" oldref="131">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.</paragraph> 94</listitem> 95</list> 96<list type="unordered"> 97<listitem> 98<paragraph role="listitem" id="par_id3150129" xml-lang="en-US" l10n="U" oldref="132">"Font: 10pt" switches to a 10pt font, with bold, italic, small caps off.</paragraph> 99</listitem> 100</list> 101<paragraph role="paragraph" id="par_id3155135" xml-lang="en-US" l10n="CHG" oldref="14">If MS Internet Explorer or $[officename] 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.</paragraph> 102<paragraph role="paragraph" id="par_id3148473" xml-lang="en-US" l10n="CHG" oldref="15">The distances of graphics and Plug-Ins to the content can be set individually for export to $[officename] Writer and MS Internet Explorer. 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".</paragraph> 103<paragraph role="paragraph" id="par_id3144510" xml-lang="en-US" l10n="CHG" oldref="16">Text frames are supported with the use of CSS1 extensions for absolute positioned objects. This applies only to the export options Netscape Navigator, MS Internet Explorer, and $[officename] Writer. Text frames can be aligned as graphics, <switchinline select="sys"><caseinline select="WIN"> Plug-Ins, 104</caseinline></switchinline>and Floating Frames, but character-linked frames are not possible.</paragraph> 105<paragraph role="paragraph" id="par_id3147530" xml-lang="en-US" l10n="U" oldref="46">Text 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>".</paragraph> 106<paragraph role="paragraph" id="par_id3153896" xml-lang="en-US" l10n="U" oldref="202">The measurement unit set in $[officename] is used for HTML export of CSS1 properties. The unit can be set separately for text and HTML documents under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Writer - General</emph> or <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Writer/Web - View</emph>. The number of exported decimal places depends on the unit.</paragraph> 107<table id="tbl_id3154346"> 108<tablerow> 109<tablecell colspan="" rowspan=""> 110<paragraph role="paragraph" id="par_id3154935" xml-lang="en-US" l10n="U" oldref="203">Measurement Unit</paragraph> 111</tablecell> 112<tablecell colspan="" rowspan=""> 113<paragraph role="paragraph" id="par_id3154226" xml-lang="en-US" l10n="U" oldref="204">Measurement Unit Name in CSS1</paragraph> 114</tablecell> 115<tablecell colspan="" rowspan=""> 116<paragraph role="paragraph" id="par_id3151106" xml-lang="en-US" l10n="U" oldref="205">Maximum Number of Decimal Places</paragraph> 117</tablecell> 118</tablerow> 119<tablerow> 120<tablecell colspan="" rowspan=""> 121<paragraph role="paragraph" id="par_id3154071" xml-lang="en-US" l10n="U" oldref="206">Millimeter</paragraph> 122</tablecell> 123<tablecell colspan="" rowspan=""> 124<paragraph role="paragraph" id="par_id3149290" xml-lang="en-US" l10n="U" oldref="207">mm</paragraph> 125</tablecell> 126<tablecell colspan="" rowspan=""> 127<paragraph role="paragraph" id="par_id3152920" xml-lang="en-US" l10n="U" oldref="208">2</paragraph> 128</tablecell> 129</tablerow> 130<tablerow> 131<tablecell colspan="" rowspan=""> 132<paragraph role="paragraph" id="par_id3156293" xml-lang="en-US" l10n="U" oldref="209">Centimeter</paragraph> 133</tablecell> 134<tablecell colspan="" rowspan=""> 135<paragraph role="paragraph" id="par_id3154819" xml-lang="en-US" l10n="U" oldref="210">cm</paragraph> 136</tablecell> 137<tablecell colspan="" rowspan=""> 138<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US" l10n="U" oldref="211">2</paragraph> 139</tablecell> 140</tablerow> 141<tablerow> 142<tablecell colspan="" rowspan=""> 143<paragraph role="paragraph" id="par_id3154329" xml-lang="en-US" l10n="U" oldref="212">Inch</paragraph> 144</tablecell> 145<tablecell colspan="" rowspan=""> 146<paragraph role="paragraph" id="par_id3150740" xml-lang="en-US" l10n="U" oldref="213">in</paragraph> 147</tablecell> 148<tablecell colspan="" rowspan=""> 149<paragraph role="paragraph" id="par_id3157320" xml-lang="en-US" l10n="U" oldref="214">2</paragraph> 150</tablecell> 151</tablerow> 152<tablerow> 153<tablecell colspan="" rowspan=""> 154<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US" l10n="U" oldref="215">Pica</paragraph> 155</tablecell> 156<tablecell colspan="" rowspan=""> 157<paragraph role="paragraph" id="par_id3144760" xml-lang="en-US" l10n="U" oldref="216">pc</paragraph> 158</tablecell> 159<tablecell colspan="" rowspan=""> 160<paragraph role="paragraph" id="par_id3145322" xml-lang="en-US" l10n="U" oldref="217">2</paragraph> 161</tablecell> 162</tablerow> 163<tablerow> 164<tablecell colspan="" rowspan=""> 165<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US" l10n="U" oldref="218">Point</paragraph> 166</tablecell> 167<tablecell colspan="" rowspan=""> 168<paragraph role="paragraph" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="219">pt</paragraph> 169</tablecell> 170<tablecell colspan="" rowspan=""> 171<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="220">1</paragraph> 172</tablecell> 173</tablerow> 174</table> 175<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="70">The $[officename] Web page filter supports certain capabilities of CSS2. However, to use it, print layout export must be activated in <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Load/Save - HTML Compatibility</emph>. 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.</paragraph> 176<paragraph role="heading" id="hd_id3145750" xml-lang="en-US" level="3" l10n="U" oldref="223">Importing and Exporting Numbering</paragraph> 177<paragraph role="paragraph" id="par_id3145591" xml-lang="en-US" l10n="U" oldref="224">If, in <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - Load/Save - HTML Compatibility</emph>, the export option "$[officename] Writer" or "Internet Explorer" 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.</paragraph> 178<paragraph role="paragraph" id="par_id3153573" xml-lang="en-US" l10n="U" oldref="225">A left paragraph indent in numbering is indicated as "margin-left" CSS1 property. First-line indents are ignored in numbering and not exported.</paragraph> 179<paragraph role="heading" id="hd_id3148556" xml-lang="en-US" level="3" l10n="U" oldref="235">Importing and Exporting Spreadsheet Files</paragraph> 180<paragraph role="paragraph" id="par_id3153365" xml-lang="en-US" l10n="U" oldref="236">$[officename] 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.</paragraph> 181<paragraph role="heading" id="hd_id3150228" xml-lang="en-US" level="3" l10n="U" oldref="103">Importing and Exporting Graphics Files</paragraph> 182<paragraph role="paragraph" id="par_id3152578" xml-lang="en-US" l10n="U" oldref="104">As with HTML documents, you can choose to use a filter with or without the element ($[officename] Impress) in the name to open a $[officename] graphics file. If without, the file will be opened as a $[officename] Draw document. Otherwise, the file saved by an old program version is now opened in $[officename] Impress.</paragraph> 183<paragraph role="paragraph" id="par_id3144441" xml-lang="en-US" l10n="U" oldref="106">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. <switchinline select="sys"><caseinline select="UNIX"> 184</caseinline><defaultinline>If a different printer is used the preview will be printed.</defaultinline></switchinline> 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.</paragraph> 185<paragraph role="paragraph" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="222">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.</paragraph> 186<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US" l10n="CHG" oldref="109">Some $[officename] Draw and $[officename] Impress options can be accessed through <emph>File - Export</emph>. See <link href="text/shared/00/00000200.xhp" name="Graphics Export Options">Graphics Export Options</link> for more information.</paragraph> 187<paragraph role="heading" id="hd_id3153213" xml-lang="en-US" level="3" l10n="U" oldref="228">PostScript</paragraph> 188<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US" l10n="U" oldref="229">To export a document or graphic in PostScript format:</paragraph> 189<list type="ordered"> 190<listitem> 191<paragraph role="listitem" id="par_id3163714" xml-lang="en-US" l10n="U" oldref="230">If you have not yet done so, install a PostScript printer driver, such as the Apple LaserWriter driver.</paragraph> 192</listitem> 193<listitem> 194<paragraph role="listitem" id="par_id3153142" xml-lang="en-US" l10n="U" oldref="231">Print the document with the <emph>File - Print</emph> menu command.</paragraph> 195</listitem> 196<listitem> 197<paragraph role="listitem" id="par_id3154149" xml-lang="en-US" l10n="U" oldref="242">Select the PostScript printer in the dialog and mark the <emph>Print to file</emph> check box. A PostScript file will be created.</paragraph> 198</listitem> 199</list> 200</body> 201</helpdocument> 202