summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2017-06-22 22:41:41 -0300
committerOlivier Hallot <olivier.hallot@edx.srv.br>2017-07-06 15:01:40 +0200
commitc2bea45cca3f5afa702b8b92ad744e0c9f8320db (patch)
tree4ec7e43725de737b8874f110e7472a39d72cbf88
parent61c61f1181927a3dd78447cd36581682395ccf2d (diff)
Rearrange help page for VBA functionslibreoffice-5-4
Save work for translators. Change-Id: I2072d85443ba32f10235123f3ba2b681182127d2 Reviewed-on: https://gerrit.libreoffice.org/39139 Reviewed-by: Olivier Hallot <olivier.hallot@edx.srv.br> Tested-by: Olivier Hallot <olivier.hallot@edx.srv.br>
-rw-r--r--source/text/sbasic/shared/00000003.xhp30
-rw-r--r--source/text/sbasic/shared/03120111.xhp18
-rw-r--r--source/text/sbasic/shared/03120112.xhp14
-rw-r--r--source/text/sbasic/shared/03120411.xhp16
-rw-r--r--source/text/sbasic/shared/03120412.xhp18
-rw-r--r--source/text/sbasic/shared/03140000.xhp16
-rw-r--r--source/text/sbasic/shared/03140001.xhp16
-rw-r--r--source/text/sbasic/shared/03140002.xhp14
-rw-r--r--source/text/sbasic/shared/03140003.xhp14
-rw-r--r--source/text/sbasic/shared/03140004.xhp14
-rw-r--r--source/text/sbasic/shared/03140005.xhp14
-rw-r--r--source/text/sbasic/shared/special_vba_func.xhp56
12 files changed, 98 insertions, 142 deletions
diff --git a/source/text/sbasic/shared/00000003.xhp b/source/text/sbasic/shared/00000003.xhp
index bd3a2810d..cebb51745 100644
--- a/source/text/sbasic/shared/00000003.xhp
+++ b/source/text/sbasic/shared/00000003.xhp
@@ -31,7 +31,8 @@
<paragraph id="hd_id3148550" role="heading" level="1" xml-lang="en-US">Information</paragraph>
<section id="languageformat">
-<paragraph id="par_id3153381" role="paragraph" xml-lang="en-US">You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character.</paragraph>
+<paragraph id="par_id3153381" role="paragraph" xml-lang="en-US">You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph>
+</caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Language Settings - Languages</emph>. In Basic format codes, the decimal point (<emph>.</emph>) is always used as <emph>placeholder</emph> for the decimal separator defined in your locale and will be replaced by the corresponding character.</paragraph>
<paragraph id="par_id3150870" role="paragraph" xml-lang="en-US">The same applies to the locale settings for date, time and currency formats. The Basic format code will be interpreted and displayed according to your locale setting.</paragraph>
</section>
@@ -183,11 +184,28 @@
<paragraph id="par_id051920171018124524" role="warning" xml-lang="en-US">This function is enabled with the statement <item type="literal">Option VBASupport 1</item> placed before the executable program code in a module.</paragraph>
</section>
+<section id="functsyntax">
+
+<paragraph id="hd_id061420171139089682" role="heading" level="2" xml-lang="en-US"><variable id="functsyntax">Syntax:</variable></paragraph>
+</section>
+
<section id="functdefterm">
-<paragraph id="hd_id061420171139089682" role="paragraph" xml-lang="en-US"><variable id="functsyntax">Syntax:</variable></paragraph>
-<paragraph id="hd_id061420171139087480" role="paragraph" xml-lang="en-US"><variable id="functvalue">Return value:</variable></paragraph>
-<paragraph id="hd_id061420171139084157" role="paragraph" xml-lang="en-US"><variable id="functparameters">Parameters:</variable></paragraph>
-<paragraph id="hd_id061420171139088233" role="paragraph" xml-lang="en-US"><variable id="functexample">Example:</variable></paragraph>
+
+<section id="functvalue">
+
+<paragraph id="hd_id061420171139087480" role="heading" level="2" xml-lang="en-US"><variable id="functvalue">Return value:</variable></paragraph>
+</section>
+
+<section id="functparameters">
+
+<paragraph id="hd_id061420171139084157" role="heading" level="2" xml-lang="en-US"><variable id="functparameters">Parameters:</variable></paragraph>
+</section>
+
+<section id="functexample">
+
+<paragraph id="hd_id061420171139088233" role="heading" level="2" xml-lang="en-US"><variable id="functexample">Example:</variable></paragraph>
+</section>
+<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><variable id="VBA-Financial"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></variable></paragraph>
</section>
<section id="errorcode">
@@ -320,4 +338,4 @@
</section>
</body>
-</helpdocument>
+</helpdocument> \ No newline at end of file
diff --git a/source/text/sbasic/shared/03120111.xhp b/source/text/sbasic/shared/03120111.xhp
index d220006ba..38f10a577 100644
--- a/source/text/sbasic/shared/03120111.xhp
+++ b/source/text/sbasic/shared/03120111.xhp
@@ -28,7 +28,7 @@
<body>
-<section id="asc">
+<section id="ascw">
<bookmark xml-lang="en-US" branch="index" id="bm_id3150499">
<bookmark_value>AscW function</bookmark_value>
</bookmark>
@@ -38,22 +38,18 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Returns the Unicode value of the first character in a string expression.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id3155555" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
-<paragraph id="par_id3143267" role="bascode" xml-lang="en-US">AscW (Text As String)</paragraph>
+<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">AscW (Text As String)</paragraph>
</bascode>
-
-<paragraph id="hd_id3147242" role="heading" level="2" xml-lang="en-US">Return value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" xml-lang="en-US">Integer</paragraph>
-
-<paragraph id="hd_id3148473" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3149415" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any valid string expression. Only the first character in the string is relevant.</paragraph>
<paragraph id="par_id3145609" role="paragraph" xml-lang="en-US">Use the AscW function to replace keys with Unicode values. If the AscW function encounters a blank string, %PRODUCTNAME Basic reports a run-time error. Returned values are between 0 and 65535.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id3159413" role="heading" level="2" xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341586960" role="bascode" localize="false" xml-lang="en-US">Sub ExampleAscW</paragraph>
<paragraph id="par_id3150792" role="bascode" xml-lang="en-US"> Print AscW("A") ' returns 65</paragraph>
@@ -69,4 +65,4 @@
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120112.xhp b/source/text/sbasic/shared/03120112.xhp
index ee0c9828b..056275222 100644
--- a/source/text/sbasic/shared/03120112.xhp
+++ b/source/text/sbasic/shared/03120112.xhp
@@ -28,7 +28,7 @@
<body>
-<section id="chr">
+<section id="chrw">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149205">
<bookmark_value>ChrW function</bookmark_value>
</bookmark>
@@ -38,22 +38,18 @@
<paragraph id="par_id3153311" role="paragraph" xml-lang="en-US">Returns the Unicode character that corresponds to the specified character code.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id3149514" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3150669" role="bascode" xml-lang="en-US">ChrW(Expression As Integer)</paragraph>
</bascode>
-
-<paragraph id="hd_id3143228" role="heading" level="2" xml-lang="en-US">Return value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3153824" role="paragraph" xml-lang="en-US">String</paragraph>
-
-<paragraph id="hd_id3148944" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3149295" role="paragraph" xml-lang="en-US"> <emph>Expression:</emph> Numeric variables that represent a valid 16 bit Unicode value (0-65535). An empty value returns error code 5. A value out of the range [0,65535] returns error code 6.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
<embed href="text/sbasic/shared/00000003.xhp#err6"/>
-
-<paragraph id="hd_id3154366" role="heading" level="2" xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341138080" role="bascode" localize="false" xml-lang="en-US">Sub ExampleChrW</paragraph>
<paragraph id="par_id3154909" role="bascode" xml-lang="en-US"> ' This example inserts the greek letter Alpha and Omega in a string.</paragraph>
diff --git a/source/text/sbasic/shared/03120411.xhp b/source/text/sbasic/shared/03120411.xhp
index c0ab1daad..0e1e7c004 100644
--- a/source/text/sbasic/shared/03120411.xhp
+++ b/source/text/sbasic/shared/03120411.xhp
@@ -28,7 +28,7 @@
<body>
-<section id="instr">
+<section id="instrrev">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155934">
<bookmark_value>InStrRev function</bookmark_value>
</bookmark>
@@ -39,16 +39,13 @@
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
<paragraph id="par_id3147303" role="paragraph" xml-lang="en-US">The InStrRev function returns the position at which the match was found, from the right. If the string was not found, the function returns 0.</paragraph>
-
-<paragraph id="hd_id3145090" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3146957" role="bascode" xml-lang="en-US">InStrRev (Text1 As String, Text2 As String [,Start As Long] [, Compare As Integer])</paragraph>
</bascode>
-
-<paragraph id="hd_id3148538" role="heading" level="2" xml-lang="en-US">Return value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3149763" role="paragraph" xml-lang="en-US">Long</paragraph>
-
-<paragraph id="hd_id3148473" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3145609" role="paragraph" xml-lang="en-US"> <emph>Text1:</emph> The string expression that you want to search.</paragraph>
<paragraph id="par_id3147559" role="paragraph" xml-lang="en-US"> <emph>Text2:</emph> The string expression that you want to search for.</paragraph>
<paragraph id="par_id3153126" role="paragraph" xml-lang="en-US"> <emph>Start: </emph>Optional numeric expression that marks the position <emph>from the left </emph>in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the last character of the string. The maximum allowed value is 65535.</paragraph>
@@ -58,8 +55,7 @@
<paragraph id="par_id3153361" role="paragraph" xml-lang="en-US">To avoid a run-time error, do not set the Compare parameter if the first return parameter is omitted.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id3154366" role="heading" level="2" xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341612352" role="bascode" localize="false" xml-lang="en-US">Sub ExamplePosition</paragraph>
<paragraph id="par_idm1341611120" role="bascode" localize="false" xml-lang="en-US">Dim sInput As String</paragraph>
@@ -77,4 +73,4 @@
</section>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120412.xhp b/source/text/sbasic/shared/03120412.xhp
index 11c69947d..71ba4e614 100644
--- a/source/text/sbasic/shared/03120412.xhp
+++ b/source/text/sbasic/shared/03120412.xhp
@@ -28,31 +28,27 @@
<body>
-<section id="instr">
+<section id="strreverse">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155934">
<bookmark_value>StrReverse function</bookmark_value>
</bookmark>
-<paragraph id="hd_id3155934" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120412.xhp" name="InStrRev Function [Runtime]">StrReverse Function [Runtime - VBA]</link></paragraph>
+<paragraph id="hd_id3155934" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120412.xhp" name="StrReverse Function [Runtime]">StrReverse Function [Runtime - VBA]</link></paragraph>
<paragraph id="par_id3153990" role="paragraph" xml-lang="en-US">Returns the string with the character order reversed.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id3145090" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3146957" role="bascode" xml-lang="en-US">StrReverse (Text1 As String)</paragraph>
</bascode>
-
-<paragraph id="hd_id3148538" role="heading" level="2" xml-lang="en-US">Return value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3149763" role="paragraph" xml-lang="en-US">String</paragraph>
-
-<paragraph id="hd_id3148473" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3145609" role="paragraph" xml-lang="en-US"> <emph>Text1:</emph> The string expression that you want to reverse the character order.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id3154366" role="heading" level="2" xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341612352" role="bascode" localize="false" xml-lang="en-US">Sub ExampleReverse</paragraph>
<paragraph id="par_idm1341605120" role="bascode" localize="false" xml-lang="en-US"> Print StrReverse("ABCdefGH") ' return "HGfedCBA"</paragraph>
@@ -60,4 +56,4 @@
</bascode>
</body>
-</helpdocument> \ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03140000.xhp b/source/text/sbasic/shared/03140000.xhp
index 97cace90d..10c2bcf03 100644
--- a/source/text/sbasic/shared/03140000.xhp
+++ b/source/text/sbasic/shared/03140000.xhp
@@ -38,16 +38,13 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Returns the depreciation of an asset for a specified period using the arithmetic-declining method.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
-<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">DDB (Cost As Double, Salvage As Double, Life as Double, Period as Double, [Factor as Variant])</paragraph>
+<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">DDB(Cost As Double, Salvage As Double, Life as Double, Period as Double, [Factor as Variant])</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id061420170142332738" role="paragraph" xml-lang="en-US"><emph>Cost</emph> fixes the initial cost of an asset.</paragraph>
<paragraph id="par_id061420170142331999" role="paragraph" xml-lang="en-US"><emph>Salvage</emph> fixes the value of an asset at the end of its life.</paragraph>
<paragraph id="par_id061420170142338147" role="paragraph" xml-lang="en-US"><emph>Life</emph> is the number of periods (for example, years or months) defining how long the asset is to be used.</paragraph>
@@ -56,8 +53,7 @@
<paragraph id="par_id3145609" role="paragraph" xml-lang="en-US">Use this form of depreciation if you require a higher initial depreciation value as opposed to linear depreciation. The depreciation value gets less with each period and is usually used for assets whose value loss is higher shortly after purchase (for example, vehicles, computers). Please note that the book value will never reach zero under this calculation type.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id061420170142119551" role="bascode" localize="false" xml-lang="en-US">Sub ExampleDDB</paragraph>
<paragraph id="par_id061420170142169416" role="bascode" localize="false" xml-lang="en-US"> Dim ddb_yr1 As Double</paragraph>
@@ -68,7 +64,7 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060103.xhp#bm_id3149998">DDB function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
diff --git a/source/text/sbasic/shared/03140001.xhp b/source/text/sbasic/shared/03140001.xhp
index 8246842a6..ce856be59 100644
--- a/source/text/sbasic/shared/03140001.xhp
+++ b/source/text/sbasic/shared/03140001.xhp
@@ -38,16 +38,13 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">FV(Rate as Double, NPer as Double, Pmt as Double, [PV as Variant], [Due as Variant])</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id06142017042024114" role="paragraph" xml-lang="en-US"><emph>Rate</emph> is the periodic interest rate.</paragraph>
<paragraph id="par_id061420170420241668" role="paragraph" xml-lang="en-US"><emph>NPer</emph> is the total number of periods (payment period).</paragraph>
<paragraph id="par_id061420170420248911" role="paragraph" xml-lang="en-US"><emph>Pmt</emph> is the annuity paid regularly per period.</paragraph>
@@ -57,8 +54,7 @@
<paragraph id="par_id061420170429263061" role="paragraph" xml-lang="en-US">1 - the payment is due at the beginning of the period.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id061420170142119551" role="bascode" localize="false" xml-lang="en-US">Sub ExampleFV</paragraph>
<paragraph id="par_id061420170142169416" role="bascode" localize="false" xml-lang="en-US"> Dim myFV As Double</paragraph>
@@ -69,8 +65,8 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060118.xhp#bm_id3151205">FV function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
-</helpdocument>
+</helpdocument> \ No newline at end of file
diff --git a/source/text/sbasic/shared/03140002.xhp b/source/text/sbasic/shared/03140002.xhp
index a4ebc9cb3..169dca197 100644
--- a/source/text/sbasic/shared/03140002.xhp
+++ b/source/text/sbasic/shared/03140002.xhp
@@ -38,16 +38,13 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Calculates the periodic amortizement for an investment with regular payments and a constant interest rate.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">IPmt(Rate as Double, Per as Double, NPer as Double, PV as Double, [FV as Variant], [Due as Variant])</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id061420170730135034" role="paragraph" xml-lang="en-US"><emph>Rate</emph> is the periodic interest rate.</paragraph>
<paragraph id="par_id061420170730137782" role="paragraph" xml-lang="en-US"><emph>Per</emph> is the period, for which the compound interest is calculated. Period=NPER if compound interest for the last period is calculated.</paragraph>
<paragraph id="par_id061420170730134582" role="paragraph" xml-lang="en-US"><emph>NPer</emph> is the total number of periods, during which annuity is paid.</paragraph>
@@ -58,8 +55,7 @@
<paragraph id="par_id061420170429263061" role="paragraph" xml-lang="en-US">1 - the payment is due at the beginning of the period.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id061420170142119551" role="bascode" localize="false" xml-lang="en-US">Sub ExampleIPmt</paragraph>
<paragraph id="par_id061420170142169416" role="bascode" localize="false" xml-lang="en-US"> Dim myIPmt As Double</paragraph>
@@ -70,7 +66,7 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060118.xhp#bm_id3149339">IPMT function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
diff --git a/source/text/sbasic/shared/03140003.xhp b/source/text/sbasic/shared/03140003.xhp
index cd5fc6f75..14b7c10ea 100644
--- a/source/text/sbasic/shared/03140003.xhp
+++ b/source/text/sbasic/shared/03140003.xhp
@@ -38,22 +38,18 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Calculates the internal rate of return for an investment.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">IRR(Values() as Double , [Guess as Variant])</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id061420170730135034" role="paragraph" xml-lang="en-US"><emph>Values(): </emph>The array of values of the cash-flow. The values represent cash flow values at regular intervals, at least one value must be negative (payments), and at least one value must be positive (income).</paragraph>
<paragraph id="par_id061420170730137782" role="paragraph" xml-lang="en-US"><emph>Guess</emph> An initial estimate at what the IRR will be.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id06162017021753974" role="bascode" localize="false" xml-lang="en-US">REM ***** BASIC *****</paragraph>
<paragraph id="par_id061620170217534991" role="bascode" localize="false" xml-lang="en-US">Option VBASupport 1</paragraph>
@@ -70,7 +66,7 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060103.xhp#bm_id3153948">IRR function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
diff --git a/source/text/sbasic/shared/03140004.xhp b/source/text/sbasic/shared/03140004.xhp
index 710b834ca..bd4567248 100644
--- a/source/text/sbasic/shared/03140004.xhp
+++ b/source/text/sbasic/shared/03140004.xhp
@@ -38,23 +38,19 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Calculates the modified internal rate of return of a series of investments.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">MIRR(Values() as Double, Investment as Double, ReinvestRate as Double)</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id061420170730135034" role="paragraph" xml-lang="en-US"><emph>Values(): </emph>An array of cash flows, representing a series of payments and income, where negative values are treated as payments and positive values are treated as income. This array must contain at least one negative and at least one positive value.</paragraph>
<paragraph id="par_id061620170513518949" role="paragraph" xml-lang="en-US"><emph>Investment</emph>: is the rate of interest of the investments (the negative values of the array).</paragraph>
<paragraph id="par_id061420170730137782" role="paragraph" xml-lang="en-US"><emph>ReinvestRate:</emph> the rate of interest of the reinvestment (the positive values of the array).</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id06162017021753974" role="bascode" localize="false" xml-lang="en-US">REM ***** BASIC *****</paragraph>
<paragraph id="par_id061620170217534991" role="bascode" localize="false" xml-lang="en-US">Option VBASupport 1</paragraph>
@@ -71,7 +67,7 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060119.xhp#bm_id3148974">MIRR function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
diff --git a/source/text/sbasic/shared/03140005.xhp b/source/text/sbasic/shared/03140005.xhp
index e46c2b9c4..036124f20 100644
--- a/source/text/sbasic/shared/03140005.xhp
+++ b/source/text/sbasic/shared/03140005.xhp
@@ -38,16 +38,13 @@
<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Calculates the number of periods for a loan or investment.</paragraph>
</section>
<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-
-<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">NPer (Rate as Double, Pmt as Double, PV as Double, [FV as Variant], [Due as Variant])</paragraph>
</bascode>
-
-<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph>
-
-<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id06142017042024114" role="paragraph" xml-lang="en-US"><emph>Rate</emph> is the periodic interest rate.</paragraph>
<paragraph id="par_id061420170420248911" role="paragraph" xml-lang="en-US"><emph>Pmt</emph> is the annuity paid regularly per period.</paragraph>
<paragraph id="par_id061420170420246794" role="paragraph" xml-lang="en-US"><emph>PV</emph> is the (present) cash value of an investment.</paragraph>
@@ -57,8 +54,7 @@
<paragraph id="par_id061420170429263061" role="paragraph" xml-lang="en-US">1 - the payment is due at the beginning of the period.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-
-<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_id06162017021753974" role="bascode" localize="false" xml-lang="en-US">REM ***** BASIC *****</paragraph>
<paragraph id="par_id061620170217534991" role="bascode" localize="false" xml-lang="en-US">Option VBASupport 1</paragraph>
@@ -71,7 +67,7 @@
<section id="relatedtopics">
<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060118.xhp#bm_id3156435">NPER function in CALC</link></paragraph>
-<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#VBA-Financial"/>
</section>
</body>
diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp
index 550395d4c..b87c1adcc 100644
--- a/source/text/sbasic/shared/special_vba_func.xhp
+++ b/source/text/sbasic/shared/special_vba_func.xhp
@@ -43,48 +43,26 @@
</bookmark>
-<paragraph id="par_id051820170355592834" role="heading" level="3" xml-lang="en-US">Text functions</paragraph>
-
-<list type="unordered">
- <listitem>
- <paragraph id="par_id051820170314431250" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03120111.xhp">AscW</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170331279953" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03120112.xhp">ChrW</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170331274373" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03120411.xhp">InStrRev</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170335291322" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03120412.xhp">StrReverse</link></paragraph>
- </listitem></list>
+<paragraph id="par_id051820170355592834" role="heading" level="2" xml-lang="en-US">Text functions</paragraph>
+<embed href="text/sbasic/shared/03120111.xhp#ascw"/>
+<embed href="text/sbasic/shared/03120112.xhp#chrw"/>
+<embed href="text/sbasic/shared/03120411.xhp#instrrev"/>
+<embed href="text/sbasic/shared/03120412.xhp#strreverse"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id051920170357078705">
<bookmark_value>VBA Functions;Financial Functions</bookmark_value>
</bookmark>
-<paragraph id="par_id051820170355592581" role="heading" level="3" xml-lang="en-US">Financial functions</paragraph>
+<paragraph id="par_id051820170355592581" role="heading" level="2" xml-lang="en-US">Financial functions</paragraph>
+<embed href="text/sbasic/shared/03140000.xhp#ddb"/>
+<embed href="text/sbasic/shared/03140001.xhp#fv"/>
+<embed href="text/sbasic/shared/03140002.xhp#ipmt"/>
+<embed href="text/sbasic/shared/03140003.xhp#irr"/>
+<embed href="text/sbasic/shared/03140004.xhp#mirr"/>
+<embed href="text/sbasic/shared/03140005.xhp#nper"/>
<list type="unordered">
<listitem>
- <paragraph id="par_id051820170331271603" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140000.xhp">DDB</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170331278736" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140001.xhp">FV</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170331278779" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140002.xhp">IPmt</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170335282035" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140003.xhp">IRR</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170335284205" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140004.xhp">MIRR</link></paragraph>
- </listitem>
- <listitem>
- <paragraph id="par_id051820170335297182" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140005.xhp">NPer</link></paragraph>
- </listitem>
- <listitem>
<paragraph id="par_id051820170335299474" role="paragraph" localize="false" xml-lang="en-US">NPV</paragraph>
</listitem>
<listitem>
@@ -110,7 +88,7 @@
</bookmark>
-<paragraph id="par_id051820170356005357" role="heading" level="3" xml-lang="en-US">Date and time functions</paragraph>
+<paragraph id="par_id051820170356005357" role="heading" level="2" xml-lang="en-US">Date and time functions</paragraph>
<list type="unordered">
<listitem>
@@ -124,7 +102,7 @@
</bookmark>
-<paragraph id="par_id051820170356006501" role="heading" level="3" xml-lang="en-US">I/O Functions</paragraph>
+<paragraph id="par_id051820170356006501" role="heading" level="2" xml-lang="en-US">I/O Functions</paragraph>
<list type="unordered">
<listitem>
@@ -135,7 +113,7 @@
</bookmark>
-<paragraph id="par_id051820170356005221" role="heading" level="3" xml-lang="en-US">Mathematical Functions</paragraph>
+<paragraph id="par_id051820170356005221" role="heading" level="2" xml-lang="en-US">Mathematical Functions</paragraph>
<list type="unordered">
<listitem>
@@ -146,7 +124,7 @@
</bookmark>
-<paragraph id="hd_id051920170347039686" role="heading" level="3" xml-lang="en-US">Object Functions</paragraph>
+<paragraph id="hd_id051920170347039686" role="heading" level="2" xml-lang="en-US">Object Functions</paragraph>
<list type="unordered">
<listitem>
@@ -157,4 +135,4 @@
</listitem></list>
</body>
-</helpdocument>
+</helpdocument> \ No newline at end of file