helpcontent2/source/text/shared/guide/ms_import_export_limitations.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <helpdocument version="1.0">
   3
   4 <!--
   5 ***********************************************************************
   6  *
   7  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   8  *
   9  * Copyright 2008 by Sun Microsystems, Inc.
  10  *
  11  * OpenOffice.org - a multi-platform office productivity suite
  12  *
  13  * $RCSfile: ms_import_export_limitations.xhp,v $
  14  * $Revision: 1.6.4.1 $
  15  *
  16  * This file is part of OpenOffice.org.
  17  *
  18  * OpenOffice.org is free software: you can redistribute it and/or modify
  19  * it under the terms of the GNU Lesser General Public License version 3
  20  * only, as published by the Free Software Foundation.
  21  *
  22  * OpenOffice.org is distributed in the hope that it will be useful,
  23  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  24  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  25  * GNU Lesser General Public License version 3 for more details
  26  * (a copy is included in the LICENSE file that accompanied this code).
  27  *
  28  * You should have received a copy of the GNU Lesser General Public License
  29  * version 3 along with OpenOffice.org.  If not, see
  30  * <http://www.openoffice.org/license.html>
  31  * for a copy of the LGPLv3 License.
  32  *
  33  ************************************************************************
  34  -->
  35
  36
  37 <meta>
  38 <topic id="textsharedguidems_import_export_limitationsxml" indexer="include">
  39 <title id="tit" xml-lang="en-US">About Converting Microsoft Office Documents</title>
  40 <filename>/text/shared/guide/ms_import_export_limitations.xhp</filename>
  41 </topic>
  42 </meta>
  43 <body>
  44 <bookmark xml-lang="en-US" branch="index" id="bm_id3149760"><bookmark_value>Microsoft Office;document import restrictions</bookmark_value>
  45 <bookmark_value>import restrictions for Microsoft Office</bookmark_value>
  46 <bookmark_value>Microsoft Office;importing password protected files</bookmark_value>
  47 </bookmark><comment>MW moved "Microsoft Office;" from shared/guide/protection.xhp</comment>
  48 <paragraph role="paragraph" id="par_id3149760" xml-lang="en-US" l10n="E" oldref="32" localize="false"/>
  49 <paragraph role="heading" id="hd_id3152425" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="about"><link href="text/shared/guide/ms_import_export_limitations.xhp" name="About Converting Microsoft Office Documents">About Converting Microsoft Office Documents</link>
  50 </variable></paragraph>
  51 <paragraph role="paragraph" id="par_id3147834" xml-lang="en-US" l10n="U" oldref="2">$[officename] can automatically open Microsoft Office 97/2000/XP documents. However, some layout features and formatting attributes in more complex Microsoft Office documents are handled differently in $[officename] or are unsupported. As a result, converted files require some degree of manual reformatting. The amount of reformatting that can be expected is proportional to the complexity of the structure and formatting of the source document. $[officename] cannot run Visual Basic Scripts, but can load them for you to analyze.</paragraph>
  52 <paragraph role="note" id="par_id0804200804174819" xml-lang="en-US" l10n="NEW">The most recent versions of %PRODUCTNAME can load, but not save, the Microsoft Office Open XML document formats with the extensions docx, xlsx, and pptx. The same versions can also run some Excel Visual Basic scripts, if you enable this feature at <item type="menuitem">Tools - Options - Load/Save - VBA Properties</item>.</paragraph>
  53 <paragraph role="paragraph" id="par_id3155934" xml-lang="en-US" l10n="U" oldref="3">The following lists provide a general overview of Microsoft Office features that may cause conversion challenges. These will not affect your ability to use or work with the content of the converted document.</paragraph>
  54 <paragraph role="heading" id="hd_id3155892" xml-lang="en-US" level="2" l10n="U" oldref="6">Microsoft Word</paragraph>
  55 <list type="ordered">
  56 <listitem>
  57 <paragraph role="listitem" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="7">AutoShapes</paragraph>
  58 </listitem>
  59 <listitem>
  60 <paragraph role="listitem" id="par_id3150774" xml-lang="en-US" l10n="U" oldref="8">Revision marks</paragraph>
  61 </listitem>
  62 <listitem>
  63 <paragraph role="listitem" id="par_id3147209" xml-lang="en-US" l10n="U" oldref="9">OLE objects</paragraph>
  64 </listitem>
  65 <listitem>
  66 <paragraph role="listitem" id="par_id3154749" xml-lang="en-US" l10n="U" oldref="10">Certain controls and Microsoft Office form fields</paragraph>
  67 </listitem>
  68 <listitem>
  69 <paragraph role="listitem" id="par_id3149578" xml-lang="en-US" l10n="U" oldref="11">Indexes</paragraph>
  70 </listitem>
  71 <listitem>
  72 <paragraph role="listitem" id="par_id3155342" xml-lang="en-US" l10n="U" oldref="12">Tables, frames, and multi-column formatting</paragraph>
  73 </listitem>
  74 <listitem>
  75 <paragraph role="listitem" id="par_id3153541" xml-lang="en-US" l10n="U" oldref="13">Hyperlinks and bookmarks</paragraph>
  76 </listitem>
  77 <listitem>
  78 <paragraph role="listitem" id="par_id3154143" xml-lang="en-US" l10n="U" oldref="14">Microsoft WordArt graphics</paragraph>
  79 </listitem>
  80 <listitem>
  81 <paragraph role="listitem" id="par_id3156117" xml-lang="en-US" l10n="U" oldref="15">Animated characters/text</paragraph>
  82 </listitem>
  83 </list>
  84 <paragraph role="heading" id="hd_id3153524" xml-lang="en-US" level="2" l10n="U" oldref="24">Microsoft PowerPoint</paragraph>
  85 <list type="ordered">
  86 <listitem>
  87 <paragraph role="listitem" id="par_id3154365" xml-lang="en-US" l10n="U" oldref="25">AutoShapes</paragraph>
  88 </listitem>
  89 <listitem>
  90 <paragraph role="listitem" id="par_id3156424" xml-lang="en-US" l10n="U" oldref="26">Tab, line, and paragraph spacing</paragraph>
  91 </listitem>
  92 <listitem>
  93 <paragraph role="listitem" id="par_id3154910" xml-lang="en-US" l10n="U" oldref="27">Master background graphics</paragraph>
  94 </listitem>
  95 <listitem>
  96 <paragraph role="listitem" id="par_id3159151" xml-lang="en-US" l10n="U" oldref="28">Grouped objects</paragraph>
  97 </listitem>
  98 <listitem>
  99 <paragraph role="listitem" id="par_id3156282" xml-lang="en-US" l10n="U" oldref="29">Certain multimedia effects</paragraph>
 100 </listitem>
 101 </list>
 102 <paragraph role="heading" id="hd_id3150986" xml-lang="en-US" level="2" l10n="U" oldref="16">Microsoft Excel</paragraph>
 103 <list type="ordered">
 104 <listitem>
 105 <paragraph role="listitem" id="par_id3148685" xml-lang="en-US" l10n="U" oldref="17">AutoShapes</paragraph>
 106 </listitem>
 107 <listitem>
 108 <paragraph role="listitem" id="par_id3149514" xml-lang="en-US" l10n="U" oldref="18">OLE objects</paragraph>
 109 </listitem>
 110 <listitem>
 111 <paragraph role="listitem" id="par_id3148943" xml-lang="en-US" l10n="U" oldref="19">Certain controls and Microsoft Office form fields</paragraph>
 112 </listitem>
 113 <listitem>
 114 <paragraph role="listitem" id="par_id3155922" xml-lang="en-US" l10n="U" oldref="20">Pivot tables</paragraph>
 115 </listitem>
 116 <listitem>
 117 <paragraph role="listitem" id="par_id3152361" xml-lang="en-US" l10n="U" oldref="21">New chart types</paragraph>
 118 </listitem>
 119 <listitem>
 120 <paragraph role="listitem" id="par_id3156343" xml-lang="en-US" l10n="U" oldref="22">Conditional formatting</paragraph>
 121 </listitem>
 122 <listitem>
 123 <paragraph role="listitem" id="par_id3149456" xml-lang="en-US" l10n="CHG" oldref="23">Some functions/formulas (see below)</paragraph>
 124 </listitem>
 125 </list>
 126 <paragraph role="paragraph" id="par_id0811200801491971" xml-lang="en-US" l10n="NEW">One example of differences between Calc and Excel is the handling of boolean values. Enter TRUE to cells A1 and A2. </paragraph>
 127 <list type="unordered">
 128 <listitem>
 129 <paragraph role="paragraph" id="par_id0811200801491973" xml-lang="en-US" l10n="NEW">In Calc, the formula =A1+A2 returns the value 2, and the formula =SUM(A1;A2) returns 2. </paragraph>
 130 </listitem>
 131 <listitem>
 132 <paragraph role="paragraph" id="par_id0811200801491972" xml-lang="en-US" l10n="NEW">In Excel, the formula =A1+A2 returns 2, but the formula =SUM(A1,A2) returns 0.<comment>in SUM(A1&lt;limiter&gt;A2), use the Excel limiter comma , in English and semicolon ; in German</comment></paragraph>
 133 </listitem>
 134 </list>
 135 <paragraph role="note" id="par_id3150439" xml-lang="en-US" l10n="CHG" oldref="30">For a detailed overview about converting documents to and from Microsoft Office format, see the <link href="http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide">Migration Guide</link>.</paragraph>
 136 <paragraph role="heading" id="par_idN10A9F" xml-lang="en-US" level="2" l10n="NEW">Opening Microsoft Office Documents That Are Protected With a Password</paragraph>
 137 <paragraph role="paragraph" id="par_id8699606" xml-lang="en-US" l10n="NEW">%PRODUCTNAME can open the following Microsoft Office document types that are protected by a password.</paragraph>
 138 <table id="tbl_id4497512">
 139 <tablerow>
 140 <tablecell>
 141 <paragraph role="tablehead" id="par_idN10AB6" xml-lang="en-US" l10n="NEW">Microsoft Office format</paragraph>
 142 </tablecell>
 143 <tablecell>
 144 <paragraph role="tablehead" id="par_idN10ABC" xml-lang="en-US" l10n="NEW">Supported encryption method</paragraph>
 145 </tablecell>
 146 </tablerow>
 147 <tablerow>
 148 <tablecell>
 149 <paragraph role="tablecontent" id="par_idN10AC3" xml-lang="en-US" l10n="NEW">Word 6.0, Word 95</paragraph>
 150 </tablecell>
 151 <tablecell>
 152 <paragraph role="tablecontent" id="par_idN10AC9" xml-lang="en-US" l10n="NEW">Weak XOR encryption</paragraph>
 153 </tablecell>
 154 </tablerow>
 155 <tablerow>
 156 <tablecell>
 157 <paragraph role="tablecontent" id="par_idN10AD0" xml-lang="en-US" l10n="NEW">Word 97, Word 2000, Word XP, Word 2003</paragraph>
 158 </tablecell>
 159 <tablecell>
 160 <paragraph role="tablecontent" id="par_idN10AD6" xml-lang="en-US" l10n="NEW">Office 97/2000 compatible encryption</paragraph>
 161 </tablecell>
 162 </tablerow>
 163 <tablerow>
 164 <tablecell>
 165 <paragraph role="tablecontent" id="par_idN10ADD" xml-lang="en-US" l10n="NEW">Word XP, Word 2003</paragraph>
 166 </tablecell>
 167 <tablecell>
 168 <paragraph role="tablecontent" id="par_idN10AE3" xml-lang="en-US" l10n="NEW">Weak XOR encryption from older Word versions</paragraph>
 169 </tablecell>
 170 </tablerow>
 171 <tablerow>
 172 <tablecell>
 173 <paragraph role="tablecontent" id="par_idN10AEA" xml-lang="en-US" l10n="NEW">Excel 2.1, Excel 3.0, Excel 4.0, Excel 5.0, Excel 95</paragraph>
 174 </tablecell>
 175 <tablecell>
 176 <paragraph role="tablecontent" id="par_idN10AF0" xml-lang="en-US" l10n="NEW">Weak XOR encryption</paragraph>
 177 </tablecell>
 178 </tablerow>
 179 <tablerow>
 180 <tablecell>
 181 <paragraph role="tablecontent" id="par_idN10AF7" xml-lang="en-US" l10n="NEW">Excel 97, Excel 2000, Excel XP, Excel 2003</paragraph>
 182 </tablecell>
 183 <tablecell>
 184 <paragraph role="tablecontent" id="par_idN10AFD" xml-lang="en-US" l10n="NEW">Office 97/2000 compatible encryption</paragraph>
 185 </tablecell>
 186 </tablerow>
 187 <tablerow>
 188 <tablecell>
 189 <paragraph role="tablecontent" id="par_idN10B04" xml-lang="en-US" l10n="NEW">Excel XP, Excel 2003</paragraph>
 190 </tablecell>
 191 <tablecell>
 192 <paragraph role="tablecontent" id="par_idN10B0A" xml-lang="en-US" l10n="NEW">Weak XOR encryption from older Excel versions</paragraph>
 193 </tablecell>
 194 </tablerow>
 195 </table>
 196
 197 <paragraph role="paragraph" id="par_idN10B0D" xml-lang="en-US" l10n="NEW">Other encryption methods are not supported.</paragraph>
 198 <section id="relatedtopics">
 199 <embed href="text/shared/guide/ms_user.xhp#ms_user"/>
 200 <embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/>
 201 <paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="U" oldref="33"><link href="text/shared/optionen/01010200.xhp" name="Setting the default file format">Setting the default file format</link></paragraph>
 202 </section>
 203 </body>
 204 </helpdocument>