tdf#156580: CreateUnoService is spelled differently in help
Change-Id: I98728e1215a716f9e35080e819956d0801922284
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/155234
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
diff --git a/source/text/sbasic/guide/basic_2_python.xhp b/source/text/sbasic/guide/basic_2_python.xhp
index 0022270..df88ce5 100644
--- a/source/text/sbasic/guide/basic_2_python.xhp
+++ b/source/text/sbasic/guide/basic_2_python.xhp
@@ -50,7 +50,7 @@
<paragraph role="bascode" localize="false" id="N0454"> If location="document" Then</paragraph>
<paragraph role="bascode" localize="false" id="N0455"> sp = ThisComponent.getScriptProvider()</paragraph>
<paragraph role="bascode" localize="false" id="N0456"> Else</paragraph>
<paragraph role="bascode" localize="false" id="N0457"> mspf = CreateUNOService("com.sun.star.script.provider.MasterScriptProviderFactory")</paragraph>
<paragraph role="bascode" localize="false" id="N0457"> mspf = CreateUnoService("com.sun.star.script.provider.MasterScriptProviderFactory")</paragraph>
<paragraph role="bascode" localize="false" id="N0458"> sp = mspf.createScriptProvider("")</paragraph>
<paragraph role="bascode" localize="false" id="N0459"> End If</paragraph>
<paragraph role="bascode" localize="false" id="N0460"> uri = "vnd.sun.star.script:"& macro &"?language=Python&location="& location</paragraph>
diff --git a/source/text/sbasic/shared/03/sf_session.xhp b/source/text/sbasic/shared/03/sf_session.xhp
index 8b97152..2c491b3 100644
--- a/source/text/sbasic/shared/03/sf_session.xhp
+++ b/source/text/sbasic/shared/03/sf_session.xhp
@@ -407,7 +407,7 @@
<embed href="text/sbasic/shared/00000003.xhp#In_Python"/>
<pycode>
<paragraph role="pycode" localize="false" id="pyc_id201626818671015">bas = CreateScriptService("Basic")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id781626818671422">a = bas.createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id781626818671422">a = bas.CreateUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id441626818671679">result = session.HasUnoMethod(a, "callFunction")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id981626818671871">bas.MsgBox(result) # True</paragraph>
</pycode>
@@ -437,7 +437,7 @@
<embed href="text/sbasic/shared/00000003.xhp#In_Python"/>
<pycode>
<paragraph role="pycode" localize="false" id="pyc_id331626818906928">bas = CreateScriptService("Basic")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id191626818907607">a = bas.createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id191626818907607">a = bas.CreateUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id951626818907799">result = session.HasUnoProperty(a, "Wildcards")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id441626818907959">bas.MsgBox(result) # True</paragraph>
</pycode>
@@ -588,7 +588,7 @@
<embed href="text/sbasic/shared/00000003.xhp#In_Python"/>
<pycode>
<paragraph role="pycode" localize="false" id="pyc_id501626820431003">bas = CreateScriptService("Basic")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id991626820431395">a = bas.createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id991626820431395">a = bas.CreateUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id81626820431651">methods = session.UnoMethods(a)</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id281626820432068">msg = "\n".join(methods)</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id281626820432763">bas.MsgBox(msg)</paragraph>
@@ -618,7 +618,7 @@
<embed href="text/sbasic/shared/00000003.xhp#In_Python"/>
<pycode>
<paragraph role="pycode" localize="false" id="pyc_id821626820748621">bas = CreateScriptService("Basic")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id861626820749053">svc = bas.createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id861626820749053">svc = bas.CreateUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id671626821449697">properties = session.UnoProperties(a)</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id991626821450160">b = "Wildcards" in properties</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id371626820749214">bas.MsgBox(str(b)) # True</paragraph>
@@ -650,9 +650,9 @@
<embed href="text/sbasic/shared/00000003.xhp#In_Python"/>
<pycode>
<paragraph role="pycode" localize="false" id="pyc_id501626821620216">bas = CreateScriptService("Basic")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id501626821626352">svc = bas.createUnoService("com.sun.star.system.SystemShellExecute")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id501626821626352">svc = bas.CreateUnoService("com.sun.star.system.SystemShellExecute")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id131626821626637">txt = session.UnoObjectType(svc) # "com.sun.star.comp.system.SystemShellExecute"</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id771626821626792">svc = bas.createUnoService("com.sun.star.beans.Property")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id771626821626792">svc = bas.CreateUnoService("com.sun.star.beans.Property")</paragraph>
<paragraph role="pycode" localize="false" id="pyc_id251626821626944">txt = session.UnoObjectType(svc) # "com.sun.star.beans.Property"</paragraph>
</pycode>
</section>
diff --git a/source/text/sbasic/shared/03131600.xhp b/source/text/sbasic/shared/03131600.xhp
index 0739fe7..5cffdfa 100644
--- a/source/text/sbasic/shared/03131600.xhp
+++ b/source/text/sbasic/shared/03131600.xhp
@@ -63,7 +63,7 @@
<paragraph id="par_idm1206773152" role="bascode" localize="false"> </paragraph>
<paragraph id="par_idm1206772000" role="bascode" localize="false">Function FileOpenDialog(title As String) As String</paragraph>
<paragraph id="bas_id11593417954966" role="bascode" localize="false"> res = com.sun.star.ui.dialogs.ExecutableDialogResults</paragraph>
<paragraph id="par_idm1206770832" role="bascode" localize="false"> filepicker = createUnoService("com.sun.star.ui.dialogs.FilePicker")</paragraph>
<paragraph id="par_idm1206770832" role="bascode" localize="false"> filepicker = CreateUnoService("com.sun.star.ui.dialogs.FilePicker")</paragraph>
<paragraph id="par_idm1206769648" role="bascode" localize="false"> filepicker.Title = title</paragraph>
<paragraph id="par_idm1206768496" role="bascode" localize="false"> If res.OK = filepicker.execute() Then </paragraph>
<paragraph id="par_idm1206767344" role="bascode" localize="false"> files = filepicker.getSelectedFiles()</paragraph>
diff --git a/source/text/sbasic/shared/CallByName.xhp b/source/text/sbasic/shared/CallByName.xhp
index 9c6b341..8459b51 100644
--- a/source/text/sbasic/shared/CallByName.xhp
+++ b/source/text/sbasic/shared/CallByName.xhp
@@ -89,7 +89,7 @@
<paragraph role="bascode" id="bas_id611644506475669" localize="false"> Dim p As Object : p = CreateScriptService("ScriptForge.Platform")</paragraph>
<paragraph role="bascode" id="bas_id591644509462257" localize="false"> MsgBox CallByName(p, "Architecture", _Get) ' 32bit/64bit</paragraph>
<paragraph role="bascode" id="bas_id781644506475901" localize="false"></paragraph>
<paragraph id="par_idm1341471776" role="bascode" localize="false"> Dim uno As Object : uno = CreateUNOService("com.sun.star.ui.dialogs.OfficeFilePicker")</paragraph>
<paragraph id="par_idm1341471776" role="bascode" localize="false"> Dim uno As Object : uno = CreateUnoService("com.sun.star.ui.dialogs.OfficeFilePicker")</paragraph>
<paragraph id="par_idm1341417776" role="bascode" localize="false"> Dim fs As Object : fs = CreateScriptService("ScriptForge.FileSystem")</paragraph>
<paragraph id="par_idm1341471777" role="bascode" localize="false"> CallByName(uno, "DisplayDirectory", _Let, fs.HomeFolder)</paragraph>
<paragraph role="bascode" id="bas_id681644507154187" localize="false"> MsgBox CallByName(uno, "DisplayDirectory", _Get)</paragraph>
diff --git a/source/text/sbasic/shared/calc_functions.xhp b/source/text/sbasic/shared/calc_functions.xhp
index 11ed299..5ed6792 100644
--- a/source/text/sbasic/shared/calc_functions.xhp
+++ b/source/text/sbasic/shared/calc_functions.xhp
@@ -21,20 +21,20 @@
<bookmark_value>setting Calc function;macros</bookmark_value>
<bookmark_value>macros;calling Calc function</bookmark_value>
<bookmark_value>macros;setting Calc function</bookmark_value>
<bookmark_value>createUNOservice function;calling Calc function</bookmark_value>
<bookmark_value>CreateUnoService function;calling Calc function</bookmark_value>
<bookmark_value>API;sheet.addin.Analysis</bookmark_value>
<bookmark_value>API;sheet.FunctionAccess</bookmark_value>
</bookmark>
<h1 id="hd_id91592352089011"><variable id="CallingCalcFunctionsh1"><link href="text/sbasic/shared/calc_functions.xhp">Using Calc Functions in Macros</link></variable></h1>
<paragraph role="paragraph" id="par_id1001592359117987">In addition to the native BASIC functions, you can call Calc functions in your macros and scripts and set Calc functions in cell formulas.</paragraph>
<h2 id="hd_id251592352174921">Calling Internal Calc functions in Basic</h2>
<paragraph role="paragraph" id="par_id731592352332694">Use the <literal>CreateUNOService</literal> function to access the <literal>com.sun.star.sheet.FunctionAccess</literal> service.</paragraph>
<paragraph role="paragraph" id="par_id731592352332694">Use the <literal>CreateUnoService</literal> function to access the <literal>com.sun.star.sheet.FunctionAccess</literal> service.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<paragraph role="paragraph" id="par_id751629987917982">The example below creates a function named <literal>MyVlook</literal> that calls the <literal>VLOOKUP</literal> Calc function over a data array passed as argument and returns the value found by the function.</paragraph>
<bascode>
<paragraph role="bascode" localize="false" id="bas_id371629987889347">Function MyVlook(Lookup, DataArray As Object, Index As Integer, SortedRangeLookup as Byte)</paragraph>
<paragraph role="bascode" localize="false" id="bas_id21629987889617"> Dim oService As Object</paragraph>
<paragraph role="bascode" localize="false" id="bas_id671629987889986"> Set oService = createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="bascode" localize="false" id="bas_id671629987889986"> Set oService = CreateUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
<paragraph role="bascode" id="bas_id271629987890173"> ' Always use the function name in English</paragraph>
<paragraph role="bascode" localize="false" id="bas_id831629987890360"> MyVlook = oService.callFunction("VLOOKUP", Array(Lookup, DataArray, Index, SortedRangeLookup))</paragraph>
<paragraph role="bascode" localize="false" id="bas_id91629987891281">End Function</paragraph>
@@ -76,7 +76,7 @@
<paragraph role="bascode" id="bas_id421592358343633">REM Example calling Add-in function SQRTPI</paragraph>
<paragraph role="bascode" id="bas_id731592358351744">Function MySQRTPI(arg as double) as double</paragraph>
<paragraph role="bascode" id="bas_id731592358361242" localize="false"> Dim oService as Object</paragraph>
<paragraph role="bascode" id="bas_id971592358368906" localize="false"> oService = createUNOService("com.sun.star.sheet.addin.Analysis")</paragraph>
<paragraph role="bascode" id="bas_id971592358368906" localize="false"> oService = CreateUnoService("com.sun.star.sheet.addin.Analysis")</paragraph>
<paragraph role="bascode" id="bas_id211592358377026"> MySQRTPI = oService.getSqrtPi(arg)</paragraph>
<paragraph role="bascode" id="bas_id451592358385346" localize="false">End Function</paragraph>
</bascode>
