From 37c3a04916cc6d3e605e33de0733d58e6ba37f1f Mon Sep 17 00:00:00 2001 From: Julien Nabet Date: Wed, 2 Aug 2023 14:52:00 +0200 Subject: 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 --- source/text/sbasic/shared/calc_functions.xhp | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'source/text/sbasic/shared/calc_functions.xhp') diff --git a/source/text/sbasic/shared/calc_functions.xhp b/source/text/sbasic/shared/calc_functions.xhp index 11ed299864..5ed6792d5f 100644 --- a/source/text/sbasic/shared/calc_functions.xhp +++ b/source/text/sbasic/shared/calc_functions.xhp @@ -21,20 +21,20 @@ setting Calc function;macros macros;calling Calc function macros;setting Calc function - createUNOservice function;calling Calc function + CreateUnoService function;calling Calc function API;sheet.addin.Analysis API;sheet.FunctionAccess

Using Calc Functions in Macros

In addition to the native BASIC functions, you can call Calc functions in your macros and scripts and set Calc functions in cell formulas.

Calling Internal Calc functions in Basic

- Use the CreateUNOService function to access the com.sun.star.sheet.FunctionAccess service. + Use the CreateUnoService function to access the com.sun.star.sheet.FunctionAccess service. The example below creates a function named MyVlook that calls the VLOOKUP Calc function over a data array passed as argument and returns the value found by the function. Function MyVlook(Lookup, DataArray As Object, Index As Integer, SortedRangeLookup as Byte) Dim oService As Object - Set oService = createUnoService("com.sun.star.sheet.FunctionAccess") + Set oService = CreateUnoService("com.sun.star.sheet.FunctionAccess") ' Always use the function name in English MyVlook = oService.callFunction("VLOOKUP", Array(Lookup, DataArray, Index, SortedRangeLookup)) End Function @@ -76,7 +76,7 @@ REM Example calling Add-in function SQRTPI Function MySQRTPI(arg as double) as double Dim oService as Object - oService = createUNOService("com.sun.star.sheet.addin.Analysis") + oService = CreateUnoService("com.sun.star.sheet.addin.Analysis") MySQRTPI = oService.getSqrtPi(arg) End Function -- cgit