summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-16 23:57:06 -0300
committerAdolfo Jayme Barrientos <fitojb@ubuntu.com>2020-06-17 13:53:35 +0200
commitcc69c3dde48f5038567ae0b964b9ef9b5f302748 (patch)
treeb6e85c8235ce418dd36fc8865c914b7fbccee850
parentFix application color and h1 underline CSS (diff)
downloadhelp-cc69c3dde48f5038567ae0b964b9ef9b5f302748.zip
help-cc69c3dde48f5038567ae0b964b9ef9b5f302748.tar.gz
tdf#134032 Calling Calc function from basic
Change-Id: I7c3c64e0df4d89b46e49afb869f3e2de0825a6e2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96485 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 7af288d0fa90e5e31c29014501f06f776a00366a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96504 Reviewed-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
-rw-r--r--AllLangHelp_sbasic.mk1
-rw-r--r--source/auxiliary/sbasic.tree1
-rw-r--r--source/text/sbasic/shared/03131600.xhp11
-rw-r--r--source/text/sbasic/shared/calc_functions.xhp865
-rw-r--r--source/text/scalc/01/04060115.xhp43
-rw-r--r--source/text/scalc/01/04060116.xhp1
6 files changed, 896 insertions, 26 deletions
diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index 6a53d6b..6dcb58d 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -358,6 +358,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/03170010 \
helpcontent2/source/text/sbasic/shared/05060700 \
helpcontent2/source/text/sbasic/shared/code-stubs \
+ helpcontent2/source/text/sbasic/shared/calc_functions \
helpcontent2/source/text/sbasic/shared/classmodule \
helpcontent2/source/text/sbasic/shared/compatible \
helpcontent2/source/text/sbasic/shared/compatibilitymode \
diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree
index 804b861..fc7df97 100644
--- a/source/auxiliary/sbasic.tree
+++ b/source/auxiliary/sbasic.tree
@@ -50,6 +50,7 @@
<topic id="sbasic/text/sbasic/shared/03110000.xhp">Comparison Operators</topic>
<topic id="sbasic/text/sbasic/shared/03120000.xhp">Strings</topic>
<topic id="sbasic/text/sbasic/shared/uno_objects.xhp">UNO Objects, Functions and Services</topic>
+ <topic id="sbasic/text/sbasic/shared/calc_functions.xhp">Calling Calc functions</topic>
<topic id="sbasic/text/sbasic/shared/special_vba_func.xhp">Exclusive VBA functions</topic>
<topic id="sbasic/text/sbasic/shared/03130000.xhp">Other Commands</topic>
</node>
diff --git a/source/text/sbasic/shared/03131600.xhp b/source/text/sbasic/shared/03131600.xhp
index ddf4fe2..b0c499b 100644
--- a/source/text/sbasic/shared/03131600.xhp
+++ b/source/text/sbasic/shared/03131600.xhp
@@ -33,7 +33,7 @@
<bookmark_value>API;FunctionAccess</bookmark_value>
</bookmark>
-<paragraph id="hd_id3150682" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03131600.xhp" name="CreateUnoService Function">CreateUnoService Function</link></paragraph>
+<h1 id="hd_id3150682"><variable id="createunoserviceh1"><link href="text/sbasic/shared/03131600.xhp" name="CreateUnoService Function">CreateUnoService Function</link></variable></h1>
<paragraph id="par_id3152924" role="paragraph" xml-lang="en-US">Instantiates a Uno service with the ProcessServiceManager.</paragraph>
</section>
@@ -45,11 +45,11 @@
<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id731561653332192">
<bookmark_value>Calc functions;API Service</bookmark_value>
-<bookmark_value>Calling Calc functions in Basic</bookmark_value>
-<bookmark_value>CreateUnoService function; Calling Calc functions</bookmark_value>
</bookmark>
<paragraph role="paragraph" id="par_id891561653344669">Calling Calc functions in Basic:</paragraph>
+<section id="calcinternalfunctions">
<bascode>
+ <paragraph role="bascode" id="par_id741592351349391" xml-lang="en-US">REM The code below does not work for add-in functions, which have a different calling procedure.</paragraph>
<paragraph role="bascode" id="par_id511561653511948" xml-lang="en-US" localize="false">Function MyVlook(item, InRange As Object, FromCol As Integer)</paragraph>
<paragraph role="bascode" id="par_id771561653522280" xml-lang="en-US" localize="false"> Dim oService As Object</paragraph>
<paragraph role="bascode" id="par_id791561653536896" xml-lang="en-US" localize="false"> oService = createUnoService("com.sun.star.sheet.FunctionAccess")</paragraph>
@@ -57,7 +57,7 @@
<paragraph role="bascode" id="par_id391561653548274" xml-lang="en-US" localize="false"> MyVlook = oService.callFunction("VLOOKUP",Array(item, InRange, FromCol, True))</paragraph>
<paragraph role="bascode" id="par_id951561653556383" xml-lang="en-US" localize="false">End Function</paragraph>
</bascode>
-
+</section>
<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<paragraph id="par_id3154046" role="paragraph" localize="false" xml-lang="en-US"><literal>oIntrospection = CreateUnoService( "com.sun.star.beans.Introspection" )</literal></paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id8334604">
@@ -78,5 +78,8 @@
<paragraph id="par_idm1206766192" role="bascode" localize="false" xml-lang="en-US"> FileOpenDialog=files(0)</paragraph>
<paragraph id="par_idm1206765040" role="bascode" localize="false" xml-lang="en-US">End Function</paragraph>
</bascode>
+<section id="relatedtopics">
+ <embed href="text/sbasic/shared/calc_functions.xhp#CallingCalcFunctionsh1"/>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/calc_functions.xhp b/source/text/sbasic/shared/calc_functions.xhp
new file mode 100644
index 0000000..7f0169f
--- /dev/null
+++ b/source/text/sbasic/shared/calc_functions.xhp
@@ -0,0 +1,865 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="callingcalcfunction" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Calling Calc Functions in Macros</title>
+ <filename>/text/sbasic/shared/calc_functions.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id291592361063458">
+ <bookmark_value>calling Calc function;macros</bookmark_value>
+ <bookmark_value>macros;calling Calc function</bookmark_value>
+ <bookmark_value>createUNOservice function;calling Calc function</bookmark_value>
+ <bookmark_value>API;addin.Analysis</bookmark_value>
+</bookmark>
+<h1 id="hd_id91592352089011"><variable id="CallingCalcFunctionsh1"><link href="text/sbasic/shared/calc_functions.xhp" name="Calling Calc Functions">Calling Calc Functions</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.</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>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
+<embed href="text/sbasic/shared/03131600.xhp#calcinternalfunctions"/>
+<h2 id="hd_id561592352225441">Calling Add-In Calc Functions in BASIC</h2>
+<paragraph role="paragraph" id="par_id261592359338681">The Calc Add-In functions are in service <literal>com.sun.star.sheet.addin.Analysis</literal>.</paragraph>
+ <embed href="text/sbasic/shared/00000003.xhp#functexample"/>
+<bascode>
+<paragraph role="bascode" id="bas_id421592358343633">REM Example calling Addin function SQRTPI</paragraph>
+<paragraph role="bascode" id="bas_id731592358351744">Function MySQRTPI(arg as double) as double</paragraph>
+<paragraph role="bascode" id="bas_id731592358361242"> Dim oService as Object</paragraph>
+<paragraph role="bascode" id="bas_id971592358368906"> 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">End Function</paragraph>
+</bascode>
+
+<table id="tab_id971592356505781">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id511592356505781" role="tablehead" xml-lang="en-US" localize="false">Calc Function name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id471592356505782" role="tablehead" xml-lang="en-US" localize="false">UNO service name</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id721592355432992" role="tablecontent" xml-lang="en-US" >ACCRINT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id391592355432992" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getAccrint</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id311592355461144" role="tablecontent" xml-lang="en-US" >ACCRINTM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id861592355461144" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getAccrintm</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id731592355465193" role="tablecontent" xml-lang="en-US" >AMORDEGRC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id261592355465193" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getAmordegrc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id361592355471024" role="tablecontent" xml-lang="en-US" >AMORLINC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211592355471024" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getAmorlinc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id11592355475920" role="tablecontent" xml-lang="en-US" >BESSELI</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461592355475920" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBesseli</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id841592355481243" role="tablecontent" xml-lang="en-US" >BESSELJ</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id641592355481243" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBesselj</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id781592355488489" role="tablecontent" xml-lang="en-US" >BESSELK</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id691592355488489" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBesselk</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id751592355494321" role="tablecontent" xml-lang="en-US" >BESSELY</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id561592355494321" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBessely</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id661592355500416" role="tablecontent" xml-lang="en-US" >BIN2DEC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id621592355500417" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBin2Dec</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id331592355505769" role="tablecontent" xml-lang="en-US" >BIN2HEX</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421592355505769" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBin2Hex</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id691592355510409" role="tablecontent" xml-lang="en-US" >BIN2OCT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id401592355510409" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getBin2Oct</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1001592355515562" role="tablecontent" xml-lang="en-US" >COMPLEX</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id821592355515562" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getComplex</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id661592355519833" role="tablecontent" xml-lang="en-US" >CONVERT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id421592355519833" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getConvert</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id501592355525049" role="tablecontent" xml-lang="en-US" >COUPDAYBS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771592355525049" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCoupdaybs</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id251592355529338" role="tablecontent" xml-lang="en-US" >COUPDAYS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id311592355529338" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCoupdays</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id681592355545522" role="tablecontent" xml-lang="en-US" >COUPDAYSNC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id331592355545522" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCoupdaysnc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id151592355550475" role="tablecontent" xml-lang="en-US" >COUPNCD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id351592355550475" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCoupncd</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id291592355554258" role="tablecontent" xml-lang="en-US" >COUPNUM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151592355554258" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCoupnum</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id361592355563155" role="tablecontent" xml-lang="en-US" >COUPPCD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001592355563155" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCouppcd</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id591592355570035" role="tablecontent" xml-lang="en-US" >CUMIPMT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91592355570035" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCumipmt</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id681592355573971" role="tablecontent" xml-lang="en-US" >CUMPRINC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id161592355573971" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getCumprinc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id591592355577411" role="tablecontent" xml-lang="en-US" >DEC2BIN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781592355577411" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDec2Bin</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id651592355580939" role="tablecontent" xml-lang="en-US" >DEC2HEX</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231592355580939" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDec2Hex</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id981592355585026" role="tablecontent" xml-lang="en-US" >DEC2OCT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id351592355585026" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDec2Oct</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id911592355588619" role="tablecontent" xml-lang="en-US" >DELTA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771592355588619" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDelta</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id931592355591947" role="tablecontent" xml-lang="en-US" >DISC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id921592355591947" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDisc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id281592355595627" role="tablecontent" xml-lang="en-US" >DOLLARDE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41592355595627" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDollarde</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id731592355599218" role="tablecontent" xml-lang="en-US" >DOLLARFR</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id181592355599218" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDollarfr</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451592355602770" role="tablecontent" xml-lang="en-US" >DURATION</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id251592355602770" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getDuration</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id261592355606039" role="tablecontent" xml-lang="en-US" >EDATE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111592355606039" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getEdate</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id221592355620084" role="tablecontent" xml-lang="en-US" >EFFECT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id221592355620084" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getEffect</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id721592355623964" role="tablecontent" xml-lang="en-US" >EOMONTH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741592355623964" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getEomonth</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id581592355627044" role="tablecontent" xml-lang="en-US" >ERF</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id841592355627044" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getErf</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id451592355631036" role="tablecontent" xml-lang="en-US" >ERFC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id701592355631036" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getErfc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id851592355634629" role="tablecontent" xml-lang="en-US" >FACTDOUBLE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451592355634629" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getFactdouble</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id731592355637900" role="tablecontent" xml-lang="en-US" >FVSCHEDULE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id211592355637900" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getFvschedule</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id431592355641084" role="tablecontent" xml-lang="en-US" >GCD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id601592355641084" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getGcd</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id461592355646844" role="tablecontent" xml-lang="en-US" >GESTEP</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id571592355646845" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getGestep</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id471592355650772" role="tablecontent" xml-lang="en-US" >HEX2BIN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id171592355650772" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getHex2Bin</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91592355654156" role="tablecontent" xml-lang="en-US" >HEX2DEC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id391592355654156" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getHex2Dec</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id401592355657388" role="tablecontent" xml-lang="en-US" >HEX2OCT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id771592355657388" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getHex2Oct</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id331592355660565" role="tablecontent" xml-lang="en-US" >IMABS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id241592355660565" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImabs</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id401592355663828" role="tablecontent" xml-lang="en-US" >IMAGINARY</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451592355663828" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImaginary</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id571592355667021" role="tablecontent" xml-lang="en-US" >IMARGUMENT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id61592355667021" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImargument</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id921592355670053" role="tablecontent" xml-lang="en-US" >IMCONJUGATE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id141592355670053" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImconjugate</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id171592355673117" role="tablecontent" xml-lang="en-US" >IMCOS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21592355673117" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImcos</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id701592355676365" role="tablecontent" xml-lang="en-US" >IMCOSH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451592355676365" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImcosh</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id601592355679652" role="tablecontent" xml-lang="en-US" >IMCOT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id81592355679652" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImcot</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id41592355682724" role="tablecontent" xml-lang="en-US" >IMCSC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id601592355682724" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImcsc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id61592355685899" role="tablecontent" xml-lang="en-US" >IMCSCH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id201592355685899" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImcsch</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id51592355688940" role="tablecontent" xml-lang="en-US" >IMDIV</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id51592355688940" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImdiv</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id611592355692012" role="tablecontent" xml-lang="en-US" >IMEXP</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id891592355692012" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImexp</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id381592355695069" role="tablecontent" xml-lang="en-US" >IMLN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id841592355695069" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImln</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231592355698892" role="tablecontent" xml-lang="en-US" >IMLOG10</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1001592355698892" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImlog10</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id581592355702180" role="tablecontent" xml-lang="en-US" >IMLOG2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id711592355702180" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImlog2</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id341592355705773" role="tablecontent" xml-lang="en-US" >IMPOWER</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101592355705773" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImpower</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id301592355708742" role="tablecontent" xml-lang="en-US" >IMPRODUCT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781592355708742" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImproduct</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id621592355711845" role="tablecontent" xml-lang="en-US" >IMREAL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id701592355711845" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImreal</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id821592355714852" role="tablecontent" xml-lang="en-US" >IMSEC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id111592355714853" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsec</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id871592355718533" role="tablecontent" xml-lang="en-US" >IMSECH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id311592355718534" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsech</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id871592355721957" role="tablecontent" xml-lang="en-US" >Imsin</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id271592355721957" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsin</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id681592355725045" role="tablecontent" xml-lang="en-US" >IMSINH</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id871592355725046" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsinh</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id801592355728022" role="tablecontent" xml-lang="en-US" >IMSQRT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id381592355728022" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsqrt</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id851592355731069" role="tablecontent" xml-lang="en-US" >IMSUB</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id21592355731069" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsub</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id131592355734118" role="tablecontent" xml-lang="en-US" >IMSUM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741592355734118" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImsum</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id761592355737109" role="tablecontent" xml-lang="en-US" >IMTAN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id591592355737109" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getImtan</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id91592355740301" role="tablecontent" xml-lang="en-US" >INTRATE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id41592355740301" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getIntrate</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id561592355743397" role="tablecontent" xml-lang="en-US" >ISEVEN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id781592355743397" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getIseven</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id481592355746477" role="tablecontent" xml-lang="en-US" >ISODD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id91592355746477" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getIsodd</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id621592355749526" role="tablecontent" xml-lang="en-US" >LCM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id801592355749526" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getLcm</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id381592355752413" role="tablecontent" xml-lang="en-US" >MDURATION</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id431592355752413" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getMduration</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id161592355755349" role="tablecontent" xml-lang="en-US" >MROUND</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id841592355755349" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getMround</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id601592355758534" role="tablecontent" xml-lang="en-US" >MULTINOMIAL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id851592355758534" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getMultinomial</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id241592355761822" role="tablecontent" xml-lang="en-US" >NETWORKDAYS</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id71592355761822" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getNetworkdays</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121592355764950" role="tablecontent" xml-lang="en-US" >NOMINAL</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id681592355764950" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getNominal</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id161592355767958" role="tablecontent" xml-lang="en-US" >OCT2BIN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id131592355767959" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOct2Bin</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id401592355770926" role="tablecontent" xml-lang="en-US" >OCT2DEC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id591592355770926" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOct2Dec</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id981592355773838" role="tablecontent" xml-lang="en-US" >OCT2HEX</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id131592355773838" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOct2Hex</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id51592355776830" role="tablecontent" xml-lang="en-US" >ODDFPRICE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id501592355776830" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOddfprice</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id581592355779822" role="tablecontent" xml-lang="en-US" >ODDFYIELD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id761592355779822" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOddfyield</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id251592355782710" role="tablecontent" xml-lang="en-US" >ODDLPRICE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151592355782710" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOddlprice</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id331592355785647" role="tablecontent" xml-lang="en-US" >ODDLYIELD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id691592355785647" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getOddlyield</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id471592355788791" role="tablecontent" xml-lang="en-US" >PRICE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151592355788791" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getPrice</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id141592355791678" role="tablecontent" xml-lang="en-US" >PRICEDISC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id691592355791678" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getPricedisc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id341592355794671" role="tablecontent" xml-lang="en-US" >PRICEMAT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id461592355794671" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getPricemat</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id681592355799718" role="tablecontent" xml-lang="en-US" >QUOTIENT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id411592355799718" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getQuotient</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id831592355803591" role="tablecontent" xml-lang="en-US" >RANDBETWEEN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id661592355803591" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getRandbetween</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id701592355807287" role="tablecontent" xml-lang="en-US" >RECEIVED</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id721592355807287" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getReceived</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id231592355810343" role="tablecontent" xml-lang="en-US" >SERIESSUM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id951592355810343" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getSeriessum</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id111592355816454" role="tablecontent" xml-lang="en-US" >SQRTPI</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id231592355816454" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getSqrtpi</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id521592355819614" role="tablecontent" xml-lang="en-US" >TBILLEQ</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id601592355819614" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getTbilleq</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id351592355822703" role="tablecontent" xml-lang="en-US" >TBILLPRICE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id491592355822703" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getTbillprice</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id921592355825694" role="tablecontent" xml-lang="en-US" >TBILLYIELD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id971592355825695" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getTbillyield</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id751592355828599" role="tablecontent" xml-lang="en-US" >WEEKNUM</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id201592355828599" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getWeeknum</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id851592355831471" role="tablecontent" xml-lang="en-US" >WORKDAY</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id451592355831472" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getWorkday</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id291592355834479" role="tablecontent" xml-lang="en-US" >XIRR</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id351592355834479" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getXirr</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id521592355837464" role="tablecontent" xml-lang="en-US" >XNPV</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id551592355837464" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getXnpv</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id201592355840359" role="tablecontent" xml-lang="en-US" >YEARFRAC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id101592355840359" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getYearfrac</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id281592355843559" role="tablecontent" xml-lang="en-US" >YIELD</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id741592355843559" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getYield</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id341592355846704" role="tablecontent" xml-lang="en-US" >YIELDDISC</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id651592355846704" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getYielddisc</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id181592355849664" role="tablecontent" xml-lang="en-US" >YIELDMAT</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id151592355849664" role="tablecontent" localize="false" >com.sun.star.sheet.addin.Analysis.getYieldmat</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+ <section id="relatedtopics">
+ <embed href="text/sbasic/shared/03131600.xhp#createunoserviceh1"/>
+</section>
+</body>
+</helpdocument>
diff --git a/source/text/scalc/01/04060115.xhp b/source/text/scalc/01/04060115.xhp
index f45c7a8..1e16911 100644
--- a/source/text/scalc/01/04060115.xhp
+++ b/source/text/scalc/01/04060115.xhp
@@ -32,9 +32,8 @@
<bookmark_value>analysis functions</bookmark_value>
</bookmark>
-
-<paragraph id="hd_id3152871" role="heading" level="1" xml-lang="en-US"><variable id="head_addin_analysis_one"><link href="text/scalc/01/04060115.xhp" name="Add-in Functions, List of Analysis Functions Part One">Add-in Functions, List of Analysis Functions Part One</link></variable></paragraph>
-
+<h1 id="hd_id3152871"><variable id="head_addin_analysis_one"><link href="text/scalc/01/04060115.xhp" name="Add-in Functions, List of Analysis Functions Part One">Add-in Functions, List of Analysis Functions Part One</link></variable></h1>
+<note id="par_id961592361784406">The Add-in functions are supplied by the <link href="text/sbasic/shared/calc_functions.xhp" name="addinanalysis">UNO <literal>com.sun.star.sheet.addin.Analysis</literal> service</link>.</note>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#addinana"/>
</section>
@@ -47,7 +46,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELI" id="bm_id3150435" localize="false"/>
-<paragraph id="hd_id3153334" role="heading" level="2" xml-lang="en-US">BESSELI</paragraph>
+<h2 id="hd_id3153334">BESSELI</h2>
<paragraph id="par_id3153960" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BESSELI">Calculates the modified Bessel function of the first kind In(x).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -64,7 +63,7 @@
<section id="besselj">
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELJ" id="bm_id3150539" localize="false"/>
-<paragraph id="hd_id3153027" role="heading" level="2" xml-lang="en-US">BESSELJ</paragraph>
+<h2 id="hd_id3153027">BESSELJ</h2>
<paragraph id="par_id3153015" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BESSELJ">Calculates the Bessel function of the first kind Jn(x) (cylinder function).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -81,7 +80,7 @@
<section id="besselk">
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELK" id="bm_id3147616" localize="false"/>
-<paragraph id="hd_id3149946" role="heading" level="2" xml-lang="en-US">BESSELK</paragraph>
+<h2 id="hd_id3149946">BESSELK</h2>
<paragraph id="par_id3159122" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BESSELK">Calculates the modified Bessel function of the second kind Kn(x).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -98,7 +97,7 @@
<section id="bessely">
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BESSELY" id="bm_id3150461" localize="false"/>
-<paragraph id="hd_id3145828" role="heading" level="2" xml-lang="en-US">BESSELY</paragraph>
+<h2 id="hd_id3145828">BESSELY</h2>
<paragraph id="par_id3146877" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BESSELY">Calculates the Bessel function of the second kind Yn(x).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -120,7 +119,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2DEC" id="bm_id3151230" localize="false"/>
-<paragraph id="hd_id3153034" role="heading" level="2" xml-lang="en-US">BIN2DEC</paragraph>
+<h2 id="hd_id3153034">BIN2DEC</h2>
<paragraph id="par_id3144744" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BIN2DEC">The result is the decimal number for the binary number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -139,7 +138,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2HEX" id="bm_id3149548" localize="false"/>
-<paragraph id="hd_id3149954" role="heading" level="2" xml-lang="en-US">BIN2HEX</paragraph>
+<h2 id="hd_id3149954">BIN2HEX</h2>
<paragraph id="par_id3148585" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BIN2HEX">The result is the hexadecimal number for the binary number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -159,7 +158,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_BIN2OCT" id="bm_id3146848" localize="false"/>
-<paragraph id="hd_id3153332" role="heading" level="2" xml-lang="en-US">BIN2OCT</paragraph>
+<h2 id="hd_id3153332">BIN2OCT</h2>
<paragraph id="par_id3155951" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_BIN2OCT"> The result is the octal number for the binary number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -179,7 +178,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DELTA" id="bm_id3149880" localize="false"/>
-<paragraph id="hd_id3150014" role="heading" level="2" xml-lang="en-US">DELTA</paragraph>
+<h2 id="hd_id3150014">DELTA</h2>
<paragraph id="par_id3148760" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_DELTA">The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0).</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -197,7 +196,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2BIN" id="bm_id3148389" localize="false"/>
-<paragraph id="hd_id3157971" role="heading" level="2" xml-lang="en-US">DEC2BIN</paragraph>
+<h2 id="hd_id3157971">DEC2BIN</h2>
<paragraph id="par_id3153043" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_DEC2BIN"> The result is the binary number for the decimal number entered between -512 and 511.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -217,7 +216,7 @@
<comment>mw added one entr</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2HEX" id="bm_id3155513" localize="false"/>
-<paragraph id="hd_id3149388" role="heading" level="2" xml-lang="en-US">DEC2HEX</paragraph>
+<h2 id="hd_id3149388">DEC2HEX</h2>
<paragraph id="par_id3149030" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_DEC2HEX">The result is the hexadecimal number for the decimal number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -237,7 +236,7 @@
<comment>mw added one entr</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_DEC2OCT" id="bm_id3156260" localize="false"/>
-<paragraph id="hd_id3154948" role="heading" level="2" xml-lang="en-US">DEC2OCT</paragraph>
+<h2 id="hd_id3154948">DEC2OCT</h2>
<paragraph id="par_id3153920" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_DEC2OCT">The result is the octal number for the decimal number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -257,7 +256,7 @@
<comment>mw added one entr</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ERF" id="bm_id3149823" localize="false"/>
-<paragraph id="hd_id3083446" role="heading" level="2" xml-lang="en-US">ERF</paragraph>
+<h2 id="hd_id3083446">ERF</h2>
<paragraph id="par_id3150381" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ERF">Returns values of the Gaussian error integral.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -277,7 +276,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERF_MS" id="bm_id2949823" localize="false"/>
-<paragraph id="hd_id2983446" role="heading" level="2" xml-lang="en-US">ERF.PRECISE</paragraph>
+<h2 id="hd_id2983446">ERF.PRECISE</h2>
<paragraph id="par_id2950381" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ERF_MS">Returns values of the Gaussian error integral between 0 and the given limit.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -295,7 +294,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ERFC" id="bm_id3156307" localize="false"/>
-<paragraph id="hd_id3145082" role="heading" level="2" xml-lang="en-US">ERFC</paragraph>
+<h2 id="hd_id3145082">ERFC</h2>
<paragraph id="par_id3149453" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_ERFC">Returns complementary values of the Gaussian error integral between x and infinity.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -313,7 +312,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERFC_MS" id="bm_id2956307" localize="false"/>
-<paragraph id="hd_id2945082" role="heading" level="2" xml-lang="en-US">ERFC.PRECISE</paragraph>
+<h2 id="hd_id2945082">ERFC.PRECISE</h2>
<paragraph id="par_id2949453" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ERFC_MS">Returns complementary values of the Gaussian error integral between x and infinity.</ahelp></paragraph>
<embed href="text/scalc/00/avail_release.xhp#4.3"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -332,7 +331,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GESTEP" id="bm_id3151182" localize="false"/>
-<paragraph id="hd_id3152927" role="heading" level="2" xml-lang="en-US">GESTEP</paragraph>
+<h2 id="hd_id3152927">GESTEP</h2>
<paragraph id="par_id3150763" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_GESTEP">The result is 1 if <item type="literal">Number</item> is greater than or equal to <item type="literal">Step</item>.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -350,7 +349,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2BIN" id="bm_id3145659" localize="false"/>
-<paragraph id="hd_id3147276" role="heading" level="2" xml-lang="en-US">HEX2BIN</paragraph>
+<h2 id="hd_id3147276">HEX2BIN</h2>
<paragraph id="par_id3150258" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_HEX2BIN">The result is the binary number for the hexadecimal number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -370,7 +369,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2DEC" id="bm_id3149978" localize="false"/>
-<paragraph id="hd_id3154742" role="heading" level="2" xml-lang="en-US">HEX2DEC</paragraph>
+<h2 id="hd_id3154742">HEX2DEC</h2>
<paragraph id="par_id3153626" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_HEX2DEC">The result is the decimal number for the hexadecimal number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -389,7 +388,7 @@
<comment>mw added one entry</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_HEX2OCT" id="bm_id3147487" localize="false"/>
-<paragraph id="hd_id3149750" role="heading" level="2" xml-lang="en-US">HEX2OCT</paragraph>
+<h2 id="hd_id3149750">HEX2OCT</h2>
<paragraph id="par_id3153983" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_HEX2OCT">The result is the octal number for the hexadecimal number entered.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
diff --git a/source/text/scalc/01/04060116.xhp b/source/text/scalc/01/04060116.xhp
index 9316d93..4f9abb4 100644
--- a/source/text/scalc/01/04060116.xhp
+++ b/source/text/scalc/01/04060116.xhp
@@ -31,6 +31,7 @@
<bookmark_value>complex numbers in analysis functions</bookmark_value>
</bookmark>
<h1 id="hd_id3154659"><variable id="head_addin_analysis_two"><link href="text/scalc/01/04060116.xhp" name="Add-in Functions, List of Analysis Functions Part Two">Add-in Functions, List of Analysis Functions Part Two</link></variable></h1>
+<note id="par_id961592361784406">The Add-in functions are supplied by the <link href="text/sbasic/shared/calc_functions.xhp" name="addinanalysis">UNO <literal>com.sun.star.sheet.addin.Analysis</literal> service</link>.</note>
<section id="howtoget">
<embed href="text/scalc/00/00000404.xhp#addinana"/>
</section>