helpcontent2/source/text/shared/guide/ms_user.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_user.xhp,v $
  14  * $Revision: 1.9.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_userxml" indexer="include">
  39 <title id="tit" xml-lang="en-US">Using Microsoft Office and $[officename]</title>
  40 <filename>/text/shared/guide/ms_user.xhp</filename>
  41 </topic>
  42 </meta>
  43 <body>
  44 <bookmark xml-lang="en-US" branch="index" id="bm_id3150789"><bookmark_value>Office;Microsoft Office and $[officename]</bookmark_value>
  45 <bookmark_value>Microsoft Office;new users information</bookmark_value>
  46 <bookmark_value>opening;Microsoft Office files</bookmark_value>
  47 <bookmark_value>saving;in Microsoft Office file format</bookmark_value>
  48 <bookmark_value>macros; in MS Office documents</bookmark_value>
  49 </bookmark>
  50 <paragraph role="heading" id="hd_id3150789" xml-lang="en-US" level="1" l10n="U" oldref="30"><variable id="ms_user"><link href="text/shared/guide/ms_user.xhp" name="Using Microsoft Office and $[officename]">Using Microsoft Office and $[officename]</link>
  51 </variable></paragraph>
  52 <paragraph role="paragraph" id="par_id3152801" xml-lang="en-US" l10n="CHG" oldref="1">$[officename] can open and save documents in the Microsoft Office file formats. Microsoft Office Open XML formats can be read, but not saved.</paragraph>
  53 <paragraph role="heading" id="hd_id3145345" xml-lang="en-US" level="2" l10n="U" oldref="2">Opening a Microsoft Office File</paragraph>
  54 <list type="ordered">
  55 <listitem>
  56 <paragraph role="listitem" id="par_id3147008" xml-lang="en-US" l10n="U" oldref="3">Choose <emph>File - Open</emph>. Select a Microsoft Office file in the $[officename] file open dialog.</paragraph>
  57 </listitem>
  58 </list>
  59 <table id="tbl_id3147653">
  60 <tablerow>
  61 <tablecell>
  62 <paragraph role="tablehead" id="par_id3156346" xml-lang="en-US" l10n="U" oldref="4">MS Office file...</paragraph>
  63 </tablecell>
  64 <tablecell>
  65 <paragraph role="tablehead" id="par_id3155342" xml-lang="en-US" l10n="U" oldref="5">...will open in $[officename] module</paragraph>
  66 </tablecell>
  67 </tablerow>
  68 <tablerow>
  69 <tablecell>
  70 <paragraph role="tablecontent" id="par_id3153543" xml-lang="en-US" l10n="U" oldref="6">MS Word, *.doc, *.docx</paragraph>
  71 </tablecell>
  72 <tablecell>
  73 <paragraph role="tablecontent" id="par_id3147620" xml-lang="en-US" l10n="U" oldref="7">$[officename] Writer</paragraph>
  74 </tablecell>
  75 </tablerow>
  76 <tablerow>
  77 <tablecell>
  78 <paragraph role="tablecontent" id="par_id3154898" xml-lang="en-US" l10n="U" oldref="8">MS Excel, *.xls, *.xlsx</paragraph>
  79 </tablecell>
  80 <tablecell>
  81 <paragraph role="tablecontent" id="par_id3149580" xml-lang="en-US" l10n="U" oldref="9">$[officename] Calc</paragraph>
  82 </tablecell>
  83 </tablerow>
  84 <tablerow>
  85 <tablecell>
  86 <paragraph role="tablecontent" id="par_id3147574" xml-lang="en-US" l10n="U" oldref="10">MS PowerPoint, *.ppt, *.pps, *.pptx</paragraph>
  87 </tablecell>
  88 <tablecell>
  89 <paragraph role="tablecontent" id="par_id3153626" xml-lang="en-US" l10n="U" oldref="11">$[officename] Impress</paragraph>
  90 </tablecell>
  91 </tablerow>
  92 </table>
  93
  94 <paragraph role="heading" id="hd_id3147303" xml-lang="en-US" level="2" l10n="U" oldref="12">Saving as a Microsoft Office File</paragraph>
  95 <list type="ordered">
  96 <listitem>
  97 <paragraph role="listitem" id="par_id3145068" xml-lang="en-US" l10n="U" oldref="13">Choose <emph>File - Save As</emph>.</paragraph>
  98 </listitem>
  99 <listitem>
 100 <paragraph role="listitem" id="par_id3153379" xml-lang="en-US" l10n="U" oldref="14">In the <emph>File type</emph> box, select a Microsoft Office file format.</paragraph>
 101 </listitem>
 102 </list>
 103 <paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="2" l10n="CHG" oldref="15">Saving Documents by Default in Microsoft Office Formats</paragraph>
 104 <list type="ordered">
 105 <listitem>
 106 <paragraph role="listitem" id="par_id3144760" xml-lang="en-US" l10n="U" oldref="16">Choose <link href="text/shared/optionen/01010200.xhp" name="Tools - Options - Load/Save - General"><emph>Tools - Options - Load/Save - General</emph></link>.</paragraph>
 107 </listitem>
 108 <listitem>
 109 <paragraph role="listitem" id="par_id3148453" xml-lang="en-US" l10n="U" oldref="17">In the <emph>Default file format</emph> area, first select a document type, then select the file type for saving.</paragraph>
 110 </listitem>
 111 </list>
 112 <paragraph role="paragraph" id="par_id3149807" xml-lang="en-US" l10n="U" oldref="18">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>
 113 <switch select="sys">
 114 <case select="WIN">
 115 <paragraph role="heading" id="hd_id3156423" xml-lang="en-US" level="2" l10n="CHG" oldref="19">Opening Microsoft Office Files by Default</paragraph>
 116 <embed href="text/shared/guide/ms_doctypes.xhp#ms_extensions"/>
 117 </case>
 118 </switch>
 119 <paragraph role="heading" id="hd_id3153092" xml-lang="en-US" level="2" l10n="CHG" oldref="20">Converting Many Microsoft Office Files into OpenDocument Format</paragraph>
 120 <paragraph role="paragraph" id="par_id3146986" xml-lang="en-US" l10n="CHG" oldref="21">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>
 121 <list type="ordered">
 122 <listitem>
 123 <paragraph role="listitem" id="par_id3150486" xml-lang="en-US" l10n="U" oldref="22">Choose <link href="text/shared/autopi/01130000.xhp" name="File - AutoPilot - Document Converter"><emph>File - Wizards - Document Converter</emph></link> to start the wizard.</paragraph>
 124 </listitem>
 125 </list>
 126 <paragraph role="heading" id="hd_id3154319" xml-lang="en-US" level="2" l10n="U" oldref="23">Macros in Microsoft Office and $[officename]</paragraph>
 127 <paragraph role="paragraph" id="par_id3154921" xml-lang="en-US" l10n="U" oldref="24">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>
 128 <paragraph role="note" id="par_id0804200804173539" xml-lang="en-US" l10n="NEW">The most recent versions of %PRODUCTNAME can run some Excel Visual Basic scripts if you enable this feature at <item type="menuitem">Tools - Options - Load/Save - VBA Properties</item>.</paragraph>
 129 <paragraph role="paragraph" id="par_id3152577" xml-lang="en-US" l10n="U" oldref="25">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" name="Basic IDE">Basic IDE</link> editor.</paragraph>
 130 <paragraph role="heading" id="hd_id3152596" xml-lang="en-US" level="3" l10n="U" oldref="26">You can choose to preserve or delete VBA macros</paragraph>
 131 <paragraph role="paragraph" id="par_id3153144" xml-lang="en-US" l10n="U" oldref="27">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>
 132 <paragraph role="paragraph" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="28">You may delete the VBA macros from the Microsoft Office file on loading or on saving.</paragraph>
 133 <list type="ordered">
 134 <listitem>
 135 <paragraph role="listitem" id="par_id3155366" xml-lang="en-US" l10n="U" oldref="29">Choose <link href="text/shared/optionen/01130100.xhp" name="Tools - Options - Load/Save - VBA Properties"><emph>Tools - Options - Load/Save - VBA Properties</emph></link> to set the VBA macro handling of $[officename].</paragraph>
 136 </listitem>
 137 </list>
 138 <embed href="text/shared/00/00000004.xhp#related"/>
 139 <embed href="text/shared/guide/ms_import_export_limitations.xhp#about"/>
 140 <embed href="text/shared/guide/doc_open.xhp#doc_open"/>
 141 <embed href="text/shared/guide/import_ms.xhp#import_ms"/>
 142 <embed href="text/shared/guide/export_ms.xhp#export_ms"/>
 143 <switch select="sys">
 144 <case select="WIN"><embed href="text/shared/guide/ms_doctypes.xhp#ms_doctypes"/>
 145 </case>
 146 </switch>
 147 </body>
 148 </helpdocument>