tdf#137724 repair access command to Basic Macro editing in Calc
* change two menu command sequences
+ add step about selecting where Module is stored.
- remove a word from a menu sequence
+ <menuitem>
Change-Id: I694e544de5977a1ca74b5a3ae572a944f148b830
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104951
Tested-by: Jenkins
Reviewed-by: Seth Chaiklin <sdc.blanco@youmail.dk>
diff --git a/source/text/scalc/guide/userdefined_function.xhp b/source/text/scalc/guide/userdefined_function.xhp
index c842a08..80d4f25 100644
--- a/source/text/scalc/guide/userdefined_function.xhp
+++ b/source/text/scalc/guide/userdefined_function.xhp
@@ -1,4 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -16,7 +17,7 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalcguideuserdefined_functionxml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">User-Defined Functions</title>
@@ -47,10 +48,13 @@
<h2 id="hd_id3149260">Defining A Function Using %PRODUCTNAME Basic</h2>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3148456" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.</paragraph>
<paragraph role="listitem" id="par_id3148456" xml-lang="en-US">Choose <menuitem>Tools - Macros - Edit Macros</menuitem>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3154510" xml-lang="en-US">Click the <emph>Edit</emph> button. You will now see the Basic IDE.</paragraph>
<paragraph role="listitem" id="par_id3154510" xml-lang="en-US">You will now see the Basic IDE.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id651603905832952">In the Object Catalog window, double-click on the module where you want to store your macro.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150327" xml-lang="en-US">Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:</paragraph>
@@ -64,7 +68,7 @@
<list type="unordered">
<listitem>
<paragraph role="listitem" id="par_id3155443" xml-lang="en-US">Close the Basic-IDE window.</paragraph>
<paragraph role="listitem" id="par_id3150043" xml-lang="en-US">Your function is automatically saved in the default module and is now available. If you apply the function in a Calc document that is to be used on another computer, you can copy the function to the Calc document as described in the next section.</paragraph>
<paragraph role="listitem" id="par_id3150043" xml-lang="en-US">Your function is automatically saved in the selected module and is now available. If you apply the function in a Calc document that is to be used on another computer, you can copy the function to the Calc document as described in the next section.</paragraph>
</listitem>
</list>
<h2 id="hd_id3147340">Copying a Function To a Document</h2>
@@ -72,7 +76,7 @@
<paragraph role="paragraph" id="par_id3154022" xml-lang="en-US">If you want to copy the user-defined function to a Calc document:</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3150304" xml-lang="en-US">Choose <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Basic</menuitem>.</paragraph>
<paragraph role="listitem" id="par_id3150304" xml-lang="en-US">Choose <menuitem>Tools - Macros - Organize Macros - Basic</menuitem>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150086" xml-lang="en-US">In the <emph>Macro from</emph> field select <emph>My Macros - Standard - Module1</emph> and click <emph>Edit</emph>.</paragraph>
@@ -84,7 +88,7 @@
<paragraph role="listitem" id="par_idN1081D" xml-lang="en-US">Close the Basic-IDE.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150517" xml-lang="en-US">Choose <item type="menuitem">Tools - Macros - Organize Macros - %PRODUCTNAME Basic</item> .</paragraph>
<paragraph role="listitem" id="par_id3150517" xml-lang="en-US">Choose <menuitem>Tools - Macros - Organize Macros - Basic</menuitem> .</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3145384" xml-lang="en-US">In the <emph>Macro from</emph> field select <emph>(Name of the Calc document) - Standard - Module1</emph>. Click <emph>Edit</emph>.</paragraph>
@@ -110,6 +114,7 @@
<section id="relatedtopics">
<embed href="text/scalc/guide/calculate.xhp#calculate"/>
<embed href="text/scalc/guide/formula_enter.xhp#formula_enter"/>
<embed href="text/sbasic/guide/basic_2_python.xhp#basic2python"/>
</section>
</body>
</helpdocument>
