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