diff options
author | Seth Chaiklin <sdc.blanco@youmail.dk> | 2020-10-28 19:04:43 +0200 |
---|---|---|
committer | Seth Chaiklin <sdc.blanco@youmail.dk> | 2020-10-31 23:52:05 +0100 |
commit | a83bcba219360d50b1b38de99be6ae08a49ce500 (patch) | |
tree | d8a4dc5bf569b9cb9695475201ac1c610804bd51 /source | |
parent | 535ed65d68c14ae2b43c8f5fabbd7af574fe33c5 (diff) |
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>
Diffstat (limited to 'source')
-rw-r--r-- | source/text/scalc/guide/userdefined_function.xhp | 17 |
1 files changed, 11 insertions, 6 deletions
diff --git a/source/text/scalc/guide/userdefined_function.xhp b/source/text/scalc/guide/userdefined_function.xhp index c842a08095..80d4f25257 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">You will now see the Basic IDE.</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="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> |