source/text/sbasic/shared/00000003.xhp | 30 ++++++++++---
source/text/sbasic/shared/03120111.xhp | 18 +++-----
source/text/sbasic/shared/03120112.xhp | 14 ++----
source/text/sbasic/shared/03120411.xhp | 16 ++-----
source/text/sbasic/shared/03120412.xhp | 18 +++-----
source/text/sbasic/shared/03140000.xhp | 16 ++-----
source/text/sbasic/shared/03140001.xhp | 16 ++-----
source/text/sbasic/shared/03140002.xhp | 14 ++----
source/text/sbasic/shared/03140003.xhp | 14 ++----
source/text/sbasic/shared/03140004.xhp | 14 ++----
source/text/sbasic/shared/03140005.xhp | 14 ++----
source/text/sbasic/shared/special_vba_func.xhp | 56 +++++++------------------
12 files changed, 98 insertions(+), 142 deletions(-)
New commits:
commit c2bea45cca3f5afa702b8b92ad744e0c9f8320db
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Thu Jun 22 22:41:41 2017 -0300
Rearrange help page for VBA functions
Save work for translators.
Change-Id: I2072d85443ba32f10235123f3ba2b681182127d2
Reviewed-on: https://gerrit.libreoffice.org/39139
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
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
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
