135 lines
7.8 KiB
XML
135 lines
7.8 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<helpdocument version="1.0">
|
|
|
|
<!--
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
-->
|
|
|
|
|
|
<meta>
|
|
<topic id="textsharedguidems_userxml" indexer="include">
|
|
<title id="tit">Using Microsoft Office and $[officename]</title>
|
|
<filename>/text/shared/guide/ms_user.xhp</filename>
|
|
</topic>
|
|
</meta>
|
|
<body>
|
|
<bookmark branch="index" id="bm_id3150789"><bookmark_value>Office;Microsoft Office and $[officename]</bookmark_value>
|
|
<bookmark_value>Microsoft Office;new users information</bookmark_value>
|
|
<bookmark_value>opening;Microsoft Office files</bookmark_value>
|
|
<bookmark_value>saving;in Microsoft Office file format</bookmark_value>
|
|
<bookmark_value>macros; in MS Office documents</bookmark_value>
|
|
</bookmark>
|
|
<h1 id="hd_id3150789"><variable id="ms_user"><link href="text/shared/guide/ms_user.xhp">Using Microsoft Office and $[officename]</link>
|
|
</variable></h1>
|
|
<paragraph role="paragraph" id="par_id3152801">$[officename] can open and save documents in the Microsoft Office file formats, including Microsoft Office Open XML formats.</paragraph>
|
|
<h2 id="hd_id3145345">Opening a Microsoft Office File</h2>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3147008">Choose <emph>File - Open</emph>. Select a Microsoft Office file in the $[officename] file open dialog.</paragraph>
|
|
</listitem>
|
|
</list>
|
|
<table id="tbl_id3147653">
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph role="tablehead" id="par_id3156346">MS Office file...</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph role="tablehead" id="par_id3155342">...will open in $[officename] module</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3153543">Microsoft Word, *.doc, *.docx</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3147620">$[officename] Writer</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3154898">Microsoft Excel, *.xls, *.xlsx</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3149580">$[officename] Calc</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
<tablerow>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3147574">Microsoft PowerPoint, *.ppt, *.pps, *.pptx</paragraph>
|
|
</tablecell>
|
|
<tablecell>
|
|
<paragraph role="tablecontent" id="par_id3153626">$[officename] Impress</paragraph>
|
|
</tablecell>
|
|
</tablerow>
|
|
</table>
|
|
|
|
<h2 id="hd_id3147303">Saving as a Microsoft Office File</h2>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3145068">Choose <emph>File - Save As</emph>.</paragraph>
|
|
</listitem>
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3153379">In the <emph>File type</emph> box, select a Microsoft Office file format.</paragraph>
|
|
</listitem>
|
|
</list>
|
|
<h2 id="hd_id3154138">Saving Documents by Default in Microsoft Office Formats</h2>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3144760">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - </emph><link href="text/shared/optionen/01010200.xhp"><emph>Load/Save - General</emph></link>.</paragraph>
|
|
</listitem>
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3148453">In the <emph>Default file format and ODF settings</emph> area, first select a document type, then select the file type for saving.</paragraph>
|
|
</listitem>
|
|
</list>
|
|
<paragraph role="paragraph" id="par_id3149807">From now on, if you save a document, the <emph>File type </emph>will be set according to your choice. Of course, you still can select another file type in the file save dialog.</paragraph>
|
|
<switch select="sys">
|
|
<case select="WIN">
|
|
<h2 id="hd_id3156423">Opening Microsoft Office Files by Default</h2>
|
|
<embed href="text/shared/guide/ms_doctypes.xhp#ms_extensions"/>
|
|
</case>
|
|
</switch>
|
|
<h2 id="hd_id3153092">Converting Many Microsoft Office Files into OpenDocument Format</h2>
|
|
<paragraph role="paragraph" id="par_id3146986">The <emph>Document Converter Wizard</emph> will copy and convert all Microsoft Office files in a folder into $[officename] documents in the OpenDocument file format. You can specify the folder to be read, and the folder where the converted files are to be saved.</paragraph>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3150486">Choose <link href="text/shared/autopi/01130000.xhp"><emph>File - Wizards - Document Converter</emph></link> to start the wizard.</paragraph>
|
|
</listitem>
|
|
</list>
|
|
<h2 id="hd_id3154319">Macros in Microsoft Office and $[officename]</h2>
|
|
<paragraph role="paragraph" id="par_id3154921">With a few exceptions, Microsoft Office and $[officename] cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and $[officename] uses Basic code based on the $[officename] API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different.</paragraph>
|
|
<note id="par_id0804200804173539">The most recent versions of %PRODUCTNAME can run some Excel Visual Basic scripts if you enable this feature at <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - Load/Save - VBA Properties</item>.</note>
|
|
<paragraph role="paragraph" id="par_id3152577">If you use macros in one of the applications and want to use the same functionality in the other application, you must edit the macros. $[officename] can load the macros that are contained within Microsoft Office files and you can then view and edit the macro code in the $[officename] <link href="text/shared/main0600.xhp">Basic IDE</link> editor.</paragraph>
|
|
<h3 id="hd_id3152596">You can choose to preserve or delete VBA macros</h3>
|
|
<paragraph role="paragraph" id="par_id3153144">Open a Microsoft Office document that contains VBA macro code. Change only the normal contents (text, cells, graphics), and do not edit the macros. Save the document as a Microsoft Office file type. Open the file in Microsoft Office, and the VBA macros will run as before.</paragraph>
|
|
<paragraph role="paragraph" id="par_id3150011">You may delete the VBA macros from the Microsoft Office file on loading or on saving.</paragraph>
|
|
<list type="ordered">
|
|
<listitem>
|
|
<paragraph role="listitem" id="par_id3155366">Choose <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - </emph><link href="text/shared/optionen/01130100.xhp"><emph>Load/Save - VBA Properties</emph></link> to set the VBA macro handling of $[officename].</paragraph>
|
|
</listitem>
|
|
</list>
|
|
|
|
<section id="relatedtopics">
|
|
<embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/>
|
|
<embed href="text/shared/guide/doc_open.xhp#doc_open"/>
|
|
<embed href="text/shared/guide/import_ms.xhp#import_ms"/>
|
|
<embed href="text/shared/guide/export_ms.xhp#export_ms"/>
|
|
<switch select="sys">
|
|
<case select="WIN"><embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/></case>
|
|
</switch>
|
|
</section>
|
|
</body>
|
|
</helpdocument>
|