source/text/sbasic/shared/00000003.xhp | 6 +++
source/text/sbasic/shared/01020100.xhp | 53 ++++++++++++++++-----------------
source/text/sbasic/shared/03120201.xhp | 4 +-
source/text/sbasic/shared/03120202.xhp | 14 ++++----
source/text/sbasic/shared/03120301.xhp | 16 +++++----
source/text/sbasic/shared/03120302.xhp | 5 ++-
source/text/sbasic/shared/03120303.xhp | 18 ++++++-----
source/text/sbasic/shared/03120304.xhp | 13 ++++----
source/text/sbasic/shared/03120305.xhp | 15 +++++----
source/text/sbasic/shared/03120306.xhp | 20 ++++++------
source/text/sbasic/shared/03120307.xhp | 15 +++++----
source/text/sbasic/shared/03120308.xhp | 13 ++++----
source/text/sbasic/shared/03120309.xhp | 15 +++++----
source/text/sbasic/shared/03120310.xhp | 5 ++-
source/text/sbasic/shared/03120311.xhp | 15 +++++----
source/text/sbasic/shared/03120312.xhp | 15 ++++-----
source/text/sbasic/shared/03120313.xhp | 13 ++++----
source/text/sbasic/shared/03120314.xhp | 15 +++++----
source/text/sbasic/shared/03120315.xhp | 16 ++++-----
source/text/sbasic/shared/03120401.xhp | 12 +++----
source/text/sbasic/shared/replace.xhp | 3 +
21 files changed, 172 insertions(+), 129 deletions(-)
New commits:
commit 1476465fc35ec2162a513ebc668fed82ed77397b
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Sep 2 19:31:21 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Sep 3 01:41:54 2020 +0200
tdf#136213 Basic string functions update
Change-Id: I86ce4fe20c1947bc1742c9ed6c9726d73b8cbbf8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101984
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/sbasic/shared/00000003.xhp
b/source/text/sbasic/shared/00000003.xhp
index 5c675002e..c525575f0 100644
--- a/source/text/sbasic/shared/00000003.xhp
+++ b/source/text/sbasic/shared/00000003.xhp
@@ -181,7 +181,7 @@
<section id="dialoglibhowtoget">
<paragraph role="paragraph" id="par_id631529990528928"
xml-lang="en-US">Open <item type="menuitem">Tools - Macros - Organize
dialogs...</item> and select <item type="menuitem">%PRODUCTNAME Dialogs</item>
container.</paragraph>
-</section>
+</section>
<section id="basiclibhowtoget">
<paragraph role="paragraph" id="par_id631529000528928"
xml-lang="en-US">Open <item type="menuitem">Tools - Macros - %PRODUCTNAME Basic
- Edit</item> and select <item type="menuitem">%PRODUCTNAME Macros</item>
container.</paragraph>
</section>
@@ -212,6 +212,10 @@
<h2 id="hd_id061420171139088233"><variable
id="functexample">Example:</variable></h2>
</section>
+
+<paragraph role="paragraph" id="par_id161599082457466"><variable
id="stringfunctions"><link href="text/sbasic/shared/03120300.xhp" name="string
functions">String functions</link></variable></paragraph>
+
+
<paragraph id="par_id06142017015837916" role="paragraph"
xml-lang="en-US"><variable id="VBA-Financial"><link
href="text/sbasic/shared/special_vba_func.xhp#VBAFinancial">VBA financial
functions</link></variable></paragraph>
<paragraph id="par_id06142017016837917" role="paragraph"
xml-lang="en-US"><variable id="VBATimeAndDate"><link
href="text/sbasic/shared/special_vba_func.xhp#VBADateTime">VBA Time and Date
functions</link></variable></paragraph>
<paragraph id="par_id06142017016837918" role="paragraph"
xml-lang="en-US"><variable id="VBAIO"><link
href="text/sbasic/shared/special_vba_func.xhp#VBAIO">VBA I/O
functions</link></variable></paragraph>
diff --git a/source/text/sbasic/shared/01020100.xhp
b/source/text/sbasic/shared/01020100.xhp
index 8b777f7ba..7a769d70e 100644
--- a/source/text/sbasic/shared/01020100.xhp
+++ b/source/text/sbasic/shared/01020100.xhp
@@ -47,11 +47,11 @@
</bookmark>
-<paragraph id="hd_id3149346" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/01020100.xhp" name="Using Variables">Using
Variables</link></paragraph>
+<h1 id="hd_id3149346"><link href="text/sbasic/shared/01020100.xhp" name="Using
Variables">Using Variables</link></h1>
<paragraph id="par_id3154346" role="paragraph" xml-lang="en-US">The following
describes the basic use of variables in $[officename] Basic.</paragraph>
</section>
-<paragraph id="hd_id3153361" role="heading" level="2" xml-lang="en-US">Naming
Conventions for Variable Identifiers</paragraph>
+<h2 id="hd_id3153361">Naming Conventions for Variable Identifiers</h2>
<paragraph id="par_id3148797" role="paragraph" xml-lang="en-US">A variable
name can consist of a maximum of 255 characters. The first character of a
variable name <emph>must</emph> be a letter A-Z or a-z. Numbers can also be
used in a variable name, but punctuation symbols and special characters are not
permitted, with exception of the underscore character ("_"). In $[officename]
Basic variable identifiers are not case-sensitive. Variable names may contain
spaces but must be enclosed in square brackets if they do.</paragraph>
<paragraph id="par_id3156422" role="paragraph" xml-lang="en-US">Examples for
variable identifiers:</paragraph>
@@ -66,7 +66,7 @@
<paragraph id="par_idm1341234704" role="bascode">Number,Mine=12 'Not
valid, punctuation marks are not allowed'</paragraph>
</bascode>
-<paragraph id="hd_id3146317" role="heading" level="2"
xml-lang="en-US">Declaring Variables</paragraph>
+<h2 id="hd_id3146317">Declaring Variables</h2>
<paragraph id="par_id3150299" role="paragraph" xml-lang="en-US">In
$[officename] Basic you don't need to declare variables explicitly. A variable
declaration can be performed with the <emph>Dim</emph> statement. You can
declare more than one variable at a time by separating the names with a comma.
To define the variable type, use either a type-declaration sign after the name,
or the appropriate key word. </paragraph>
<paragraph id="par_id3154118" role="paragraph" xml-lang="en-US">Examples for
variable declarations:</paragraph>
@@ -77,16 +77,16 @@
<paragraph id="par_idm1341205936" role="bascode">Dim c As Boolean
'Declares c as a Boolean variable that can be TRUE or FALSE'</paragraph>
</bascode>
-<paragraph id="par_id3144770" role="warning" xml-lang="en-US">Once you have
declared a variable as a certain type, you cannot declare the variable under
the same name again as a different type!</paragraph>
+<warning id="par_id3144770">Once you have declared a variable as a certain
type, you cannot declare the variable under the same name again as a different
type!</warning>
-<paragraph id="hd_id3149331" role="heading" level="3" xml-lang="en-US">Forcing
Variable Declarations</paragraph>
+<h3 id="hd_id3149331">Forcing Variable Declarations</h3>
<paragraph id="par_id3149443" role="paragraph" xml-lang="en-US">To force
declaration of variables, use the following command:</paragraph>
<bascode>
<paragraph id="par_idm1341182432" role="bascode" localize="false"
xml-lang="en-US">Option Explicit</paragraph>
</bascode>
<paragraph id="par_id3155072" role="paragraph" xml-lang="en-US">The
<emph>Option Explicit</emph> statement has to be the first line in the module,
before the first SUB. Generally, only arrays need to be declared explicitly.
All other variables are declared according to the type-declaration character,
or - if omitted - as the default type <emph>Single</emph>.</paragraph>
-<paragraph id="hd_id3154614" role="heading" level="2"
xml-lang="en-US">Variable Types</paragraph>
+<h2 id="hd_id3154614">Variable Types</h2>
<paragraph id="par_id3155383" role="paragraph" xml-lang="en-US">$[officename]
Basic supports four variable classes:</paragraph>
<list type="unordered">
@@ -103,40 +103,40 @@
<paragraph id="par_id3154762" role="listitem" xml-lang="en-US">
<emph>Object</emph> variables can store objects of various types, like tables
and documents within a document.</paragraph>
</listitem></list>
-<paragraph id="hd_id3153805" role="heading" level="3" xml-lang="en-US">Integer
Variables</paragraph>
+<h3 id="hd_id3153805">Integer Variables</h3>
<paragraph id="par_id3146966" role="paragraph" xml-lang="en-US">Integer
variables range from -32768 to 32767. If you assign a floating-point value to
an integer variable, the decimal places are rounded to the next integer.
Integer variables are rapidly calculated in procedures and are suitable for
counter variables in loops. An integer variable only requires two bytes of
memory. "%" is the type-declaration character.</paragraph>
<bascode>
<paragraph id="par_idm1341159200" role="bascode" localize="false"
xml-lang="en-US">Dim Variable%</paragraph>
<paragraph id="par_idm1341157968" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Integer</paragraph>
</bascode>
-<paragraph id="hd_id3147546" role="heading" level="3" xml-lang="en-US">Long
Integer Variables</paragraph>
+<h3 id="hd_id3147546">Long Integer Variables</h3>
<paragraph id="par_id3151193" role="paragraph" xml-lang="en-US">Long integer
variables range from -2147483648 to 2147483647. If you assign a floating-point
value to a long integer variable, the decimal places are rounded to the next
integer. Long integer variables are rapidly calculated in procedures and are
suitable for counter variables in loops for large values. A long integer
variable requires four bytes of memory. "&" is the type-declaration
character.</paragraph>
<bascode>
<paragraph id="par_idm1341151984" role="bascode" localize="false"
xml-lang="en-US">Dim Variable&</paragraph>
<paragraph id="par_idm1341150736" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Long</paragraph>
</bascode>
-<paragraph id="hd_id7596972" role="heading" level="3" xml-lang="en-US">Decimal
Variables<comment>see i64349</comment></paragraph>
+<h3 id="hd_id7596972">Decimal Variables<comment>see i64349</comment></h3>
<paragraph id="par_id2649311" role="paragraph" xml-lang="en-US">Decimal
variables can take positive or negative numbers or zero. Accuracy is up to 29
digits.</paragraph><comment>i85284</comment>
<paragraph id="par_id7617114" role="paragraph" xml-lang="en-US">You can use
plus (+) or minus (-) signs as prefixes for decimal numbers (with or without
spaces).</paragraph>
<paragraph id="par_id1593676" role="paragraph" xml-lang="en-US">If a decimal
number is assigned to an integer variable, %PRODUCTNAME Basic rounds the figure
up or down.<comment>information from "Programming Guide for BASIC" about
decimal variables</comment></paragraph>
-<paragraph id="hd_id3147500" role="heading" level="3" xml-lang="en-US">Single
Variables</paragraph>
+<h3 id="hd_id3147500">Single Variables</h3>
<paragraph id="par_id3153070" role="paragraph" xml-lang="en-US">Single
variables can take positive or negative values ranging from 3.402823 x 10E38 to
1.401298 x 10E-45. Single variables are floating-point variables, in which the
decimal precision decreases as the non-decimal part of the number increases.
Single variables are suitable for mathematical calculations of average
precision. Calculations require more time than for Integer variables, but are
faster than calculations with Double variables. A Single variable requires 4
bytes of memory. The type-declaration character is "!".</paragraph>
<bascode>
<paragraph id="par_idm1341137456" role="bascode" localize="false"
xml-lang="en-US">Dim Variable!</paragraph>
<paragraph id="par_idm1341136224" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Single</paragraph>
</bascode>
-<paragraph id="hd_id3155753" role="heading" level="3" xml-lang="en-US">Double
Variables</paragraph>
+<h3 id="hd_id3155753">Double Variables</h3>
<paragraph id="par_id3150953" role="paragraph" xml-lang="en-US">Double
variables can take positive or negative values ranging from 1.79769313486232 x
10E308 to 4.94065645841247 x 10E-324. Double variables are floating-point
variables, in which the decimal precision decreases as the non-decimal part of
the number increases. Double variables are suitable for precise calculations.
Calculations require more time than for Single variables. A Double variable
requires 8 bytes of memory. The type-declaration character is "#".</paragraph>
<bascode>
-<paragraph id="par_idm1341130144" role="bascode" xml-lang="en-US">Dim
Variable#</paragraph>
+<paragraph id="par_idm1341130144" role="bascode" xml-lang="en-US">Dim
Variable#</paragraph>
<paragraph id="par_idm1341128912" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Double</paragraph>
</bascode>
-<paragraph id="hd_id3155747" role="heading" level="3"
xml-lang="en-US">Currency Variables</paragraph>
+<h3 id="hd_id3155747">Currency Variables</h3>
<paragraph id="par_id3153337" role="paragraph" xml-lang="en-US">Currency
variables are internally stored as 64-bit numbers (8 Bytes) and displayed as a
fixed-decimal number with 15 non-decimal and 4 decimal places. The values range
from -922337203685477.5808 to +922337203685477.5807. Currency variables are
used to calculate currency values with a high precision. The type-declaration
character is "@".</paragraph>
<bascode>
<paragraph id="par_idm1341123216" role="bascode" localize="false"
xml-lang="en-US">Dim Variable@</paragraph>
@@ -146,40 +146,41 @@
<h3 id="hd_id301576839713868">Literals for integers</h3>
<paragraph role="paragraph" id="par_id1001576839723156">Numbers can be encoded
using octal and hexadecimal forms.</paragraph>
<bascode>
- <paragraph role="bascode" id="bas_id331576850637825" localize="false">xi =
&o13 ' 8 + 3</paragraph>
- <paragraph role="bascode" id="bas_id761576850640144" localize="false">ci =
&h65 ' 6*16 + 5</paragraph>
- <paragraph role="bascode" id="bas_id511576850640336"
localize="false">MAX_Integer = &o77777 ' 32767 =
&h7FFF</paragraph>
- <paragraph role="bascode" id="bas_id571576850640536"
localize="false">MIN_Integer = &o100000 ' -32768 =
&h8000</paragraph>
- <paragraph role="bascode" id="bas_id541576850641922"
localize="false">MAX_Long = &h7fffffff ' 2147483647 =
&o17777777777</paragraph>
- <paragraph role="bascode" id="bas_id481576850564801"
localize="false">MIN_Long = &h80000000 ' -2147483648 =
&o20000000000</paragraph>
+ <paragraph role="bascode" id="bas_id331576850637825" localize="false">xi =
&o13 ' 8 + 3</paragraph>
+ <paragraph role="bascode" id="bas_id761576850640144" localize="false">ci =
&h65 ' 6*16 + 5</paragraph>
+ <paragraph role="bascode" id="bas_id511576850640336"
localize="false">MAX_Integer = &o77777 ' 32767 = &h7FFF</paragraph>
+ <paragraph role="bascode" id="bas_id571576850640536"
localize="false">MIN_Integer = &o100000 ' -32768 = &h8000</paragraph>
+ <paragraph role="bascode" id="bas_id541576850641922"
localize="false">MAX_Long = &h7fffffff ' 2147483647 =
&o17777777777</paragraph>
+ <paragraph role="bascode" id="bas_id481576850564801"
localize="false">MIN_Long = &h80000000 ' -2147483648 =
&o20000000000</paragraph>
</bascode>
-<paragraph id="hd_id3148742" role="heading" level="3" xml-lang="en-US">String
Variables</paragraph>
-<paragraph id="par_id3151393" role="paragraph" xml-lang="en-US">String
variables can hold character strings with up to 65,535 characters. Each
character is stored as the corresponding Unicode value. String variables are
suitable for word processing within programs and for temporary storage of any
non-printable character up to a maximum length of 64 Kbytes. The memory
required for storing string variables depends on the number of characters in
the variable. The type-declaration character is "$".</paragraph>
+<h3 id="hd_id3148742">String Variables</h3>
+<paragraph id="par_id3151393" role="paragraph" xml-lang="en-US">String
variables can hold character strings with up to 2,147,483,648 characters. Each
character is stored as the corresponding Unicode value. String variables are
suitable for word processing within programs and for temporary storage of any
non-printable character up to a maximum length of 2 Gbytes. The memory required
for storing string variables depends on the number of characters in the
variable. The type-declaration character is "$".</paragraph>
+<tip id="par_id381599081637549">In BASIC String functions, the first character
of the string has index 1.</tip>
<bascode>
<paragraph id="par_idm1341116176" role="bascode" localize="false"
xml-lang="en-US">Dim Variable$</paragraph>
<paragraph id="par_idm1341114944" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As String</paragraph>
</bascode>
-<paragraph id="hd_id3150534" role="heading" level="3" xml-lang="en-US">Boolean
Variables</paragraph>
+<h3 id="hd_id3150534">Boolean Variables</h3>
<paragraph id="par_id3145632" role="paragraph" xml-lang="en-US">Boolean
variables store only one of two values: TRUE or FALSE. A number 0 evaluates to
FALSE, every other value evaluates to TRUE.</paragraph>
<bascode>
<paragraph id="par_idm1341109456" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Boolean</paragraph>
</bascode>
-<paragraph id="hd_id3149722" role="heading" level="3" xml-lang="en-US">Date
Variables</paragraph>
+<h3 id="hd_id3149722">Date Variables</h3>
<paragraph id="par_id3159116" role="paragraph" xml-lang="en-US">Date variables
can only contain dates and time values stored in an internal format. Values
assigned to Date variables with <link href="text/sbasic/shared/03030101.xhp"
name="Dateserial"><emph>Dateserial</emph></link>, <link
href="text/sbasic/shared/03030102.xhp"
name="Datevalue"><emph>Datevalue</emph></link>, <link
href="text/sbasic/shared/03030205.xhp"
name="Timeserial"><emph>Timeserial</emph></link> or <link
href="text/sbasic/shared/03030206.xhp"
name="Timevalue"><emph>Timevalue</emph></link> are automatically converted to
the internal format. Date-variables are converted to normal numbers by using
the <link href="text/sbasic/shared/03030103.xhp"
name="Day"><emph>Day</emph></link>, <link
href="text/sbasic/shared/03030104.xhp" name="Month"><emph>Month</emph></link>,
<link href="text/sbasic/shared/03030106.xhp"
name="Year"><emph>Year</emph></link> or the <link
href="text/sbasic/shared/03030201.xhp" name="Hour"><emph>Hou
r</emph></link>, <link href="text/sbasic/shared/03030202.xhp"
name="Minute"><emph>Minute</emph></link>, <link
href="text/sbasic/shared/03030204.xhp" name="Second"><emph>Second</emph></link>
function. The internal format enables a comparison of date/time values by
calculating the difference between two numbers. These variables can only be
declared with the key word <emph>Date</emph>.</paragraph>
<bascode>
<paragraph id="par_idm1341092144" role="bascode" localize="false"
xml-lang="en-US">Dim Variable As Date</paragraph>
</bascode>
-<paragraph id="hd_id3148732" role="heading" level="2" xml-lang="en-US">Initial
Variable Values</paragraph>
+<h2 id="hd_id3148732">Initial Variable Values</h2>
<paragraph id="par_id3154549" role="paragraph" xml-lang="en-US">As soon as the
variable has been declared, it is automatically set to the "Null" value. Note
the following conventions:</paragraph>
<paragraph id="par_id3143222" role="paragraph" xml-lang="en-US">
<emph>Numeric</emph> variables are automatically assigned the value "0" as soon
as they are declared.</paragraph>
<paragraph id="par_id3150693" role="paragraph" xml-lang="en-US"> <emph>Date
variables</emph> are assigned the value 0 internally; equivalent to converting
the value to "0" with the <link href="text/sbasic/shared/03030103.xhp"
name="Day"><emph>Day</emph></link>, <link
href="text/sbasic/shared/03030104.xhp" name="Month"><emph>Month</emph></link>,
<link href="text/sbasic/shared/03030106.xhp"
name="Year"><emph>Year</emph></link> or the <link
href="text/sbasic/shared/03030201.xhp" name="Hour"><emph>Hour</emph></link>,
<link href="text/sbasic/shared/03030202.xhp"
name="Minute"><emph>Minute</emph></link>, <link
href="text/sbasic/shared/03030204.xhp" name="Second"><emph>Second</emph></link>
function.</paragraph>
<paragraph id="par_id3154807" role="paragraph" xml-lang="en-US"> <emph>String
variables</emph> are assigned an empty-string ("") when they are
declared.</paragraph>
-<paragraph id="hd_id3153936" role="heading" level="2"
xml-lang="en-US">Arrays</paragraph>
+<h2 id="hd_id3153936">Arrays</h2>
<paragraph id="par_id3148736" role="paragraph" xml-lang="en-US">$[officename]
Basic knows one- or multi-dimensional arrays, defined by a specified variable
type. Arrays are suitable for editing lists and tables in programs. Individual
elements of an array can be addressed through a numeric index.</paragraph>
<paragraph id="par_id3149546" role="paragraph" xml-lang="en-US">Arrays
<emph>must</emph> be declared with the <emph>Dim</emph> statement. There are
several ways to define the index range of an array:</paragraph>
@@ -192,7 +193,7 @@
<paragraph id="par_id3153005" role="paragraph" xml-lang="en-US">The index
range can include positive as well as negative numbers.
<comment>i36558</comment></paragraph>
-<paragraph id="hd_id3154507" role="heading" level="2"
xml-lang="en-US">Constants</paragraph>
+<h2 id="hd_id3154507">Constants</h2>
<paragraph id="par_id3156357" role="paragraph" xml-lang="en-US">Constants have
a fixed value. They are only defined once in the program and cannot be
redefined later:</paragraph>
<bascode>
<paragraph id="par_idm1341038256" role="bascode" localize="false"
xml-lang="en-US">Const ConstName=Expression</paragraph>
diff --git a/source/text/sbasic/shared/03120201.xhp
b/source/text/sbasic/shared/03120201.xhp
index 815a840c7..9b60756d9 100644
--- a/source/text/sbasic/shared/03120201.xhp
+++ b/source/text/sbasic/shared/03120201.xhp
@@ -33,7 +33,7 @@
<bookmark_value>Spc function</bookmark_value>
</bookmark>
-<paragraph id="hd_id3150499" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120201.xhp" name="Space Function">Space and Spc
Functions</link></paragraph>
+<h1 id="hd_id3150499"><link href="text/sbasic/shared/03120201.xhp" name="Space
Function">Space and Spc Functions</link></h1>
<paragraph id="par_id3154927" role="paragraph" xml-lang="en-US">Returns a
string that consists of a specified amount of spaces.</paragraph>
</section>
<note id="par_id681546202842979">The Spc function works the same as the Space
function.</note>
@@ -46,7 +46,7 @@
<paragraph id="par_id3149233" role="paragraph"
xml-lang="en-US">String</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
-<paragraph id="par_id3143228" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that defines the number of spaces in the
string. The maximum allowed value of <emph>n</emph> is 65535.</paragraph>
+<paragraph id="par_id3143228" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that defines the number of spaces in the
string. The maximum allowed value of <emph>n</emph> is
2,147,483,648.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
diff --git a/source/text/sbasic/shared/03120202.xhp
b/source/text/sbasic/shared/03120202.xhp
index e088ee718..ff30d5ef9 100644
--- a/source/text/sbasic/shared/03120202.xhp
+++ b/source/text/sbasic/shared/03120202.xhp
@@ -34,26 +34,26 @@
</bookmark>
-<paragraph id="hd_id3147291" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120202.xhp" name="String Function">String
Function</link></paragraph>
+<h1 id="hd_id3147291"><link href="text/sbasic/shared/03120202.xhp"
name="String Function">String Function</link></h1>
<paragraph id="par_id3147242" role="paragraph" xml-lang="en-US">Creates a
string according to the specified character, or the first character of a string
expression that is passed to the function.</paragraph>
</section>
-<paragraph id="hd_id3149516" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3149233" role="bascode" xml-lang="en-US">String (n As
Long, {expression As Integer | character As String})</paragraph>
</bascode>
-<paragraph id="hd_id3143270" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3147530" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3154923" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
-<paragraph id="par_id3154347" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that indicates the number of characters to
return in the string. The maximum allowed value of n is 65535.</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
+<paragraph id="par_id3154347" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that indicates the number of characters to
return in the string. The maximum allowed value of n is
2,147,483,648.</paragraph>
<paragraph id="par_id3148664" role="paragraph" xml-lang="en-US">
<emph>Expression:</emph> Numeric expression that defines the ASCII code for the
character.</paragraph>
<paragraph id="par_id3150359" role="paragraph" xml-lang="en-US">
<emph>Character:</emph> Any single character used to build the return string,
or any string of which only the first character will be used.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3152920" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1340924160" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleString</paragraph>
<paragraph id="par_idm1340922928" role="bascode" localize="false"
xml-lang="en-US">Dim sText As String</paragraph>
@@ -65,4 +65,4 @@
</bascode>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120301.xhp
b/source/text/sbasic/shared/03120301.xhp
index 3f19ae6de..018e8ccc9 100644
--- a/source/text/sbasic/shared/03120301.xhp
+++ b/source/text/sbasic/shared/03120301.xhp
@@ -34,23 +34,23 @@
</bookmark>
-<paragraph id="hd_id3153539" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120301.xhp" name="Format Function">Format
Function</link></paragraph>
+<h1 id="hd_id3153539"><link href="text/sbasic/shared/03120301.xhp"
name="Format Function">Format Function</link></h1>
<paragraph id="par_id3156042" role="paragraph" xml-lang="en-US">Converts a
number to a string, and then formats it according to the format that you
specify.</paragraph>
</section>
-<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_id3153527" role="bascode" xml-lang="en-US">Format (Number
[, Format As String])</paragraph>
</bascode>
-<paragraph id="hd_id3149178" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3148474" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3159176" 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>Number:</emph> Numeric expression that you want to convert to a formatted
string.</paragraph>
<paragraph id="par_id3147531" role="paragraph" xml-lang="en-US">
<emph>Format:</emph> String that specifies the format code for the number. If
<emph>Format</emph> is omitted, the Format function works like the
<emph>Str</emph> function.</paragraph>
-<paragraph id="hd_id3147561" role="heading" level="2"
xml-lang="en-US">Formatting Codes</paragraph>
+<h2 id="hd_id3147561">Formatting Codes</h2>
<paragraph id="par_id3147265" role="paragraph" xml-lang="en-US">The following
list describes the codes that you can use for formatting a number:</paragraph>
<paragraph id="par_id3153380" role="paragraph" xml-lang="en-US">
<emph>0:</emph> If <emph>Number</emph> has a digit at the position of the 0 in
the format code, the digit is displayed, otherwise a zero is
displayed.</paragraph>
<paragraph id="par_id3151210" role="paragraph" xml-lang="en-US">If
<emph>Number</emph> has fewer digits than the number of zeros in the format
code, (on either side of the decimal), leading or trailing zeros are displayed.
If the number has more digits to the left of the decimal separator than the
amount of zeros in the format code, the additional digits are displayed without
formatting.</paragraph>
@@ -72,7 +72,7 @@
<paragraph id="par_id3145749" role="paragraph" xml-lang="en-US">You can also
use the following predefined number formats. Except for "General Number", all
of the predefined format codes return the number as a decimal number with two
decimal places.</paragraph>
<paragraph id="par_id3150113" role="paragraph" xml-lang="en-US">If you use
predefined formats, the name of the format must be enclosed in quotation
marks.</paragraph>
-<paragraph id="hd_id3149377" role="heading" level="2"
xml-lang="en-US">Predefined format</paragraph>
+<h2 id="hd_id3149377">Predefined format</h2>
<paragraph id="par_id3154730" role="paragraph" xml-lang="en-US"> <emph>General
Number:</emph> Numbers are displayed as entered.</paragraph>
<paragraph id="par_id3153158" role="paragraph" xml-lang="en-US">
<emph>Currency:</emph> Inserts a dollar sign in front of the number and
encloses negative numbers in brackets.</paragraph>
<paragraph id="par_id3154490" role="paragraph" xml-lang="en-US">
<emph>Fixed:</emph> Displays at least one digit in front of the decimal
separator.</paragraph>
@@ -84,7 +84,7 @@
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3149019" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341556320" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleFormat</paragraph>
<paragraph id="par_idm1341555088" role="bascode" localize="false"
xml-lang="en-US"> MsgBox Format(6328.2, "##,##0.00")</paragraph>
@@ -94,6 +94,8 @@
</bascode>
<section id="relatedtopics">
<paragraph role="paragraph" id="par_id381513082126889"
xml-lang="en-US"><link href="text/shared/01/05020301.xhp" name="number format
code">Number format codes</link></paragraph>
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
</section>
+
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120302.xhp
b/source/text/sbasic/shared/03120302.xhp
index 361545bfb..68c6f05ca 100644
--- a/source/text/sbasic/shared/03120302.xhp
+++ b/source/text/sbasic/shared/03120302.xhp
@@ -34,7 +34,7 @@
</bookmark>
-<paragraph id="hd_id3152363" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120302.xhp" name="LCase Function">LCase
Function</link></paragraph>
+<h1 id="hd_id3152363"><link href="text/sbasic/shared/03120302.xhp" name="LCase
Function">LCase Function</link></h1>
<paragraph id="par_id3145609" role="paragraph" xml-lang="en-US">Converts all
uppercase letters in a string to lowercase.</paragraph>
</section>
<paragraph id="par_id3154347" role="paragraph" xml-lang="en-US">See also:
<link href="text/sbasic/shared/03120310.xhp" name="UCase">UCase</link>
Function</paragraph>
@@ -59,6 +59,9 @@
<paragraph id="par_id3146986" role="bascode" xml-lang="en-US"> Print
UCase(sVar) ' Returns "LAS VEGAS"</paragraph>
<paragraph id="par_idm1341096336" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120303.xhp
b/source/text/sbasic/shared/03120303.xhp
index cc0b41a88..596b15faa 100644
--- a/source/text/sbasic/shared/03120303.xhp
+++ b/source/text/sbasic/shared/03120303.xhp
@@ -34,26 +34,26 @@
</bookmark>
-<paragraph id="hd_id3149346" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120303.xhp" name="Left Function">Left
Function</link></paragraph>
+<h1 id="hd_id3149346"><link href="text/sbasic/shared/03120303.xhp" name="Left
Function">Left Function</link></h1>
<paragraph id="par_id3147242" role="paragraph" xml-lang="en-US">Returns the
number of leftmost characters that you specify of a string
expression.</paragraph>
</section>
-<paragraph id="hd_id3156153" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3150771" role="bascode" xml-lang="en-US">Left (Text As
String, n As Long)</paragraph>
</bascode>
-<paragraph id="hd_id3153824" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3147530" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3148946" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3148552" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression that you want to return the leftmost
characters from.</paragraph>
-<paragraph id="par_id3149456" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that specifies the number of characters that
you want to return. If <emph>n</emph> = 0, a zero-length string is returned.
The maximum allowed value is 65535.</paragraph>
+<paragraph id="par_id3149456" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that specifies the number of characters that
you want to return. If <emph>n</emph> = 0, a zero-length string is returned.
The maximum allowed value is 2,147,483,648.</paragraph>
<paragraph id="par_id3150791" role="paragraph" xml-lang="en-US">The following
example converts a date in YYYY.MM.DD format to MM/DD/YYYY format.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3125863" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1340818096" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleUSDate</paragraph>
<paragraph id="par_idm1340816864" role="bascode" localize="false"
xml-lang="en-US">Dim sInput As String</paragraph>
@@ -67,6 +67,8 @@
<paragraph id="par_idm1340806272" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sUS_date</paragraph>
<paragraph id="par_idm1340805040" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120304.xhp
b/source/text/sbasic/shared/03120304.xhp
index 19e9d6450..54567d6a0 100644
--- a/source/text/sbasic/shared/03120304.xhp
+++ b/source/text/sbasic/shared/03120304.xhp
@@ -34,23 +34,23 @@
</bookmark>
-<paragraph id="hd_id3143268" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120304.xhp" name="LSet Statement">LSet
Statement</link></paragraph>
+<h1 id="hd_id3143268"><link href="text/sbasic/shared/03120304.xhp" name="LSet
Statement">LSet Statement</link></h1>
<paragraph id="par_id3155419" role="paragraph" xml-lang="en-US">Aligns a
string to the left of a string variable, or copies a variable of a user-defined
type to another variable of a different user-defined type.</paragraph>
</section>
-<paragraph id="hd_id3145317" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3150984" role="bascode" xml-lang="en-US">LSet Var As
String = Text or LSet Var1 = Var2</paragraph>
</bascode>
-<paragraph id="hd_id3143271" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3145610" role="paragraph" xml-lang="en-US">
<emph>Var:</emph> Any String variable that contains the string that you want
align to the left.</paragraph>
<paragraph id="par_id3154346" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> String that you want to align to the left of the string
variable.</paragraph>
<paragraph id="par_id3151054" role="paragraph" xml-lang="en-US">
<emph>Var1:</emph> Name of the user-defined type variable that you want to copy
to.</paragraph>
<paragraph id="par_id3153361" role="paragraph" xml-lang="en-US">
<emph>Var2:</emph> Name of the user-defined type variable that you want to copy
from.</paragraph>
<paragraph id="par_id3154686" role="paragraph" xml-lang="en-US">If the string
is shorter than the string variable, <emph>LSet</emph> left-aligns the string
within the string variable. Any remaining positions in the string variable are
replaced by spaces. If the string is longer than the string variable, only the
leftmost characters up to the length of the string variable are copied. With
the <emph>LSet</emph> statement, you can also copy a user-defined type variable
to another variable of the same type.</paragraph>
-<paragraph id="hd_id3156282" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341571792" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleRLSet</paragraph>
<paragraph id="par_idm1341570560" role="bascode" localize="false"
xml-lang="en-US">Dim sVar As String</paragraph>
@@ -76,6 +76,9 @@
<paragraph id="par_idm1341544208" role="bascode" localize="false"
xml-lang="en-US"> Print ">"; sVar; "<"</paragraph>
<paragraph id="par_idm1341542960" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120305.xhp
b/source/text/sbasic/shared/03120305.xhp
index 4cec0d7d7..b0cd811c4 100644
--- a/source/text/sbasic/shared/03120305.xhp
+++ b/source/text/sbasic/shared/03120305.xhp
@@ -34,25 +34,25 @@
</bookmark>
-<paragraph id="hd_id3147574" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120305.xhp" name="LTrim Function">LTrim
Function</link></paragraph>
+<h1 id="hd_id3147574"><link href="text/sbasic/shared/03120305.xhp" name="LTrim
Function">LTrim Function</link></h1>
<paragraph id="par_id3145316" role="paragraph" xml-lang="en-US">Removes all
leading spaces at the start of a string expression.</paragraph>
</section>
-<paragraph id="hd_id3154924" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3148552" role="bascode" xml-lang="en-US">LTrim (Text As
String)</paragraph>
</bascode>
-<paragraph id="hd_id3156344" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3151056" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3150543" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3150792" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression.</paragraph>
<paragraph id="par_id3125863" role="paragraph" xml-lang="en-US">Use this
function to remove spaces at the beginning of a string expression.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3145419" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1340839888" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleSpaces</paragraph>
<paragraph id="par_idm1340838656" role="bascode" localize="false"
xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph>
@@ -67,6 +67,9 @@
<paragraph id="par_idm1340827232" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sOut</paragraph>
<paragraph id="par_idm1340826000" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120306.xhp
b/source/text/sbasic/shared/03120306.xhp
index bc95904c3..d3f4efe7b 100644
--- a/source/text/sbasic/shared/03120306.xhp
+++ b/source/text/sbasic/shared/03120306.xhp
@@ -35,29 +35,29 @@
</bookmark>
-<paragraph id="hd_id3143268" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120306.xhp" name="Mid Function, Mid Statement">Mid
Function, Mid Statement</link></paragraph>
+<h1 id="hd_id3143268"><link href="text/sbasic/shared/03120306.xhp" name="Mid
Function, Mid Statement">Mid Function, Mid Statement</link></h1>
<paragraph id="par_id3148473" role="paragraph" xml-lang="en-US">Returns the
specified portion of a string expression (<emph>Mid function</emph>), or
replaces the portion of a string expression with another string (<emph>Mid
statement</emph>).</paragraph>
</section>
-<paragraph id="hd_id3154285" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3147530" role="bascode" xml-lang="en-US">Mid (Text As
String, Start As Long [, Length As Long]) or Mid (Text As String, Start As Long
, Length As Long, Text As String)</paragraph>
</bascode>
-<paragraph id="hd_id3145068" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3149295" role="paragraph" xml-lang="en-US">String (only
by Function)</paragraph>
-<paragraph id="hd_id3154347" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3148664" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression that you want to modify.</paragraph>
-<paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Start:
</emph>Numeric expression that indicates the character position within the
string where the string portion that you want to replace or to return begins.
The maximum allowed value is 65535.<comment>see i17928</comment></paragraph>
-<paragraph id="par_id3148451" role="paragraph" xml-lang="en-US">
<emph>Length:</emph> Numeric expression that returns the number of characters
that you want to replace or return. The maximum allowed value is
65535.</paragraph>
+<paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Start:
</emph>Numeric expression that indicates the character position within the
string where the string portion that you want to replace or to return begins.
The minimum allowed value is 1. The maximum allowed value is
2,147,483,648.<comment>see i17928</comment></paragraph>
+<paragraph id="par_id3148451" role="paragraph" xml-lang="en-US">
<emph>Length:</emph> Numeric expression that returns the number of characters
that you want to replace or return. The maximum allowed value is
2,147,483,648.</paragraph>
<paragraph id="par_id3125864" role="paragraph" xml-lang="en-US">If the Length
parameter in the <emph>Mid function</emph> is omitted, all characters in the
string expression from the start position to the end of the string are
returned.</paragraph>
<paragraph id="par_id3144762" role="paragraph" xml-lang="en-US">If the Length
parameter in the <emph>Mid statement</emph> is less than the length of the text
that you want to replace, the text is reduced to the specified
length.</paragraph>
<paragraph id="par_id3150769" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> The string to replace the string expression (<emph>Mid
statement</emph>).</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3149560" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341563264" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleUSDate</paragraph>
<paragraph id="par_idm1341562032" role="bascode" localize="false"
xml-lang="en-US">Dim sInput As String</paragraph>
@@ -71,6 +71,8 @@
<paragraph id="par_idm1341551488" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sUS_date</paragraph>
<paragraph id="par_idm1341550256" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120307.xhp
b/source/text/sbasic/shared/03120307.xhp
index 4b6a7af3a..e970b80a1 100644
--- a/source/text/sbasic/shared/03120307.xhp
+++ b/source/text/sbasic/shared/03120307.xhp
@@ -34,27 +34,27 @@
</bookmark>
-<paragraph id="hd_id3153311" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120307.xhp" name="Right Function">Right
Function</link></paragraph>
+<h1 id="hd_id3153311"><link href="text/sbasic/shared/03120307.xhp" name="Right
Function">Right Function</link></h1>
<paragraph id="par_id3150984" role="paragraph" xml-lang="en-US">Returns the
rightmost "n" characters of a string expression.</paragraph>
</section>
<paragraph id="par_id3149763" role="paragraph" xml-lang="en-US">See also:
<link href="text/sbasic/shared/03120303.xhp" name="Left Function">Left
Function</link>.</paragraph>
-<paragraph id="hd_id3145315" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3153061" role="bascode" xml-lang="en-US">Right (Text As
String, n As Long)</paragraph>
</bascode>
-<paragraph id="hd_id3145068" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3156344" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3146795" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3153526" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression that you want to return the rightmost
characters of.</paragraph>
-<paragraph id="par_id3151211" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that defines the number of characters that
you want to return. If <emph>n</emph> = 0, a zero-length string is returned.
The maximum allowed value is 65535.</paragraph>
+<paragraph id="par_id3151211" role="paragraph" xml-lang="en-US">
<emph>n:</emph> Numeric expression that defines the number of characters that
you want to return. If <emph>n</emph> = 0, a zero-length string is returned.
The maximum allowed value is 2,147,483,648.</paragraph>
<paragraph id="par_id3158410" role="paragraph" xml-lang="en-US">The following
example converts a date in YYYY-MM-DD format to the US date format
(MM/DD/YYYY).</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3156212" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341027360" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleUSDate</paragraph>
<paragraph id="par_idm1341026128" role="bascode" localize="false"
xml-lang="en-US">Dim sInput As String</paragraph>
@@ -68,6 +68,9 @@
<paragraph id="par_idm1341015584" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sUS_date</paragraph>
<paragraph id="par_idm1341014352" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120308.xhp
b/source/text/sbasic/shared/03120308.xhp
index 7ac77340e..e527399c5 100644
--- a/source/text/sbasic/shared/03120308.xhp
+++ b/source/text/sbasic/shared/03120308.xhp
@@ -34,16 +34,16 @@
</bookmark>
-<paragraph id="hd_id3153345" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120308.xhp" name="RSet Statement">RSet
Statement</link></paragraph>
+<h1 id="hd_id3153345"><link href="text/sbasic/shared/03120308.xhp" name="RSet
Statement">RSet Statement</link></h1>
<paragraph id="par_id3150503" role="paragraph" xml-lang="en-US">Right-aligns a
string within a string variable, or copies a user-defined variable type into
another.</paragraph>
</section>
-<paragraph id="hd_id3149234" 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">RSet Text As
String = Text or RSet Variable1 = Variable2</paragraph>
</bascode>
-<paragraph id="hd_id3156024" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3148552" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string variable.</paragraph>
<paragraph id="par_id3154924" role="paragraph" xml-lang="en-US">
<emph>Text</emph>: String that you want to right-align in the string
variable.</paragraph>
<paragraph id="par_id3149456" role="paragraph" xml-lang="en-US">
<emph>Variable1:</emph> User-defined variable that is the target for the copied
variable.</paragraph>
@@ -52,7 +52,7 @@
<paragraph id="par_id3149202" role="paragraph" xml-lang="en-US">You can also
use the <emph>RSet statement</emph> to assign variables of one user-defined
type to another.</paragraph>
<paragraph id="par_id3151042" role="paragraph" xml-lang="en-US">The following
example uses the <emph>RSet</emph> and <emph>LSet</emph> statements to modify
the left and right alignment of a string.</paragraph>
-<paragraph id="hd_id3154909" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341567472" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleRLSet</paragraph>
<paragraph id="par_idm1341566240" role="bascode" localize="false"
xml-lang="en-US">Dim sVar As String</paragraph>
@@ -78,6 +78,9 @@
<paragraph id="par_idm1341539968" role="bascode" localize="false"
xml-lang="en-US"> Print ">"; sVar; "<"</paragraph>
<paragraph id="par_idm1341538720" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120309.xhp
b/source/text/sbasic/shared/03120309.xhp
index ec7b1cb1c..5218fc61e 100644
--- a/source/text/sbasic/shared/03120309.xhp
+++ b/source/text/sbasic/shared/03120309.xhp
@@ -34,25 +34,25 @@
</bookmark>
-<paragraph id="hd_id3154286" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120309.xhp" name="RTrim Function">RTrim
Function</link></paragraph>
+<h1 id="hd_id3154286"><link href="text/sbasic/shared/03120309.xhp" name="RTrim
Function">RTrim Function</link></h1>
<paragraph id="par_id3153127" role="paragraph" xml-lang="en-US">Deletes the
spaces at the end of a string expression.</paragraph>
</section>
<paragraph id="par_id3153062" role="paragraph" xml-lang="en-US">See also:
<link href="text/sbasic/shared/03120305.xhp" name="LTrim Function">LTrim
Function</link></paragraph>
-<paragraph id="hd_id3154924" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3154347" role="bascode" xml-lang="en-US">RTrim (Text As
String)</paragraph>
</bascode>
-<paragraph id="hd_id3149457" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3153381" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3148798" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3151380" role="paragraph" xml-lang="en-US"> <emph>Text:
</emph>Any string expression.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3151041" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341574144" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleSpaces</paragraph>
<paragraph id="par_idm1341572912" role="bascode" localize="false"
xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph>
@@ -67,6 +67,9 @@
<paragraph id="par_idm1341561488" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sOut</paragraph>
<paragraph id="par_idm1341560256" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120310.xhp
b/source/text/sbasic/shared/03120310.xhp
index 5c052abd2..bf1eab43e 100644
--- a/source/text/sbasic/shared/03120310.xhp
+++ b/source/text/sbasic/shared/03120310.xhp
@@ -34,7 +34,7 @@
</bookmark>
-<paragraph id="hd_id3153527" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120310.xhp" name="UCase Function">UCase
Function</link></paragraph>
+<h1 id="hd_id3153527"><link href="text/sbasic/shared/03120310.xhp" name="UCase
Function">UCase Function</link></h1>
<paragraph id="par_id3155420" role="paragraph" xml-lang="en-US">Converts
lowercase characters in a string to uppercase.</paragraph>
</section>
<paragraph id="par_id3150771" role="paragraph" xml-lang="en-US">See also:
<link href="text/sbasic/shared/03120302.xhp" name="LCase Function">LCase
Function</link></paragraph>
@@ -57,6 +57,9 @@
<paragraph id="par_id3156280" role="bascode" xml-lang="en-US"> Print
UCase(sVar) ' returns "LAS VEGAS"</paragraph>
<paragraph id="par_idm1340871632" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120311.xhp
b/source/text/sbasic/shared/03120311.xhp
index 5dd60bae2..f8e175222 100644
--- a/source/text/sbasic/shared/03120311.xhp
+++ b/source/text/sbasic/shared/03120311.xhp
@@ -34,24 +34,24 @@
</bookmark>
-<paragraph id="hd_id3150616" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120311.xhp" name="Trim Function">Trim
Function</link></paragraph>
+<h1 id="hd_id3150616"><link href="text/sbasic/shared/03120311.xhp" name="Trim
Function">Trim Function</link></h1>
<paragraph id="par_id3149177" role="paragraph" xml-lang="en-US">Removes all
leading and trailing spaces from a string expression.</paragraph>
</section>
-<paragraph id="hd_id3159157" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3155341" role="bascode" xml-lang="en-US">Trim( Text As
String )</paragraph>
</bascode>
-<paragraph id="hd_id3155388" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3143228" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3145609" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3159414" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
-<paragraph id="hd_id3148663" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph id="par_idm1341576784" role="bascode" localize="false"
xml-lang="en-US">Sub ExampleSpaces</paragraph>
<paragraph id="par_idm1341575552" role="bascode" localize="false"
xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph>
@@ -66,6 +66,9 @@
<paragraph id="par_idm1341564128" role="bascode" localize="false"
xml-lang="en-US"> MsgBox sOut</paragraph>
<paragraph id="par_idm1341562896" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120312.xhp
b/source/text/sbasic/shared/03120312.xhp
index 3c17b560b..a6599480e 100644
--- a/source/text/sbasic/shared/03120312.xhp
+++ b/source/text/sbasic/shared/03120312.xhp
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textsbasicshared03120312xml" indexer="include" status="PUBLISH">
@@ -32,22 +30,22 @@
<section id="converttourl">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3152801"><bookmark_value>ConvertToURL function</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="1"><link
href="text/sbasic/shared/03120312.xhp" name="ConvertToURL
Function">ConvertToURL Function</link></paragraph>
+<h1 id="hd_id3152801"><link href="text/sbasic/shared/03120312.xhp"
name="ConvertToURL Function">ConvertToURL Function</link></h1>
<paragraph role="paragraph" id="par_id3148538" xml-lang="en-US">Converts a
system file name to a file URL.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3150669" xml-lang="en-US"
level="2">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph role="bascode" id="par_id3154285"
xml-lang="en-US">ConvertToURL(filename)</paragraph>
</bascode>
-<paragraph role="heading" id="hd_id3150984" xml-lang="en-US" level="2">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph role="paragraph" id="par_id3147530"
xml-lang="en-US">String</paragraph>
-<paragraph role="heading" id="hd_id3148550" xml-lang="en-US"
level="2">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph role="paragraph" id="par_id3148947" xml-lang="en-US">
<emph>Filename:</emph> A file name as string.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
<section id="exampleconverttofromurl">
-<paragraph role="heading" id="hd_id3153361" xml-lang="en-US"
level="2">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<bascode>
<paragraph role="bascode" id="par_id3150792" xml-lang="en-US">systemFile$
= "c:\folder\mytext.txt"</paragraph>
<paragraph role="bascode" localize="false" id="par_id3154365"
xml-lang="en-US">url$ = ConvertToURL( systemFile$ )</paragraph>
@@ -56,5 +54,8 @@
<paragraph role="bascode" localize="false" id="par_id3144762"
xml-lang="en-US">print systemFileAgain$</paragraph>
</bascode>
</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120313.xhp
b/source/text/sbasic/shared/03120313.xhp
index c9a98ce0a..0d8b57b2e 100644
--- a/source/text/sbasic/shared/03120313.xhp
+++ b/source/text/sbasic/shared/03120313.xhp
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textsbasicshared03120313xml" indexer="include" status="PUBLISH">
@@ -32,20 +30,23 @@
<section id="convertfromurl">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153894"><bookmark_value>ConvertFromURL function</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3153894" xml-lang="en-US" level="1"><link
href="text/sbasic/shared/03120313.xhp" name="ConvertFromURL
Function">ConvertFromURL Function</link></paragraph>
+<h1 id="hd_id3153894"><link href="text/sbasic/shared/03120313.xhp"
name="ConvertFromURL Function">ConvertFromURL Function</link></h1>
<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">Converts a
file URL to a system file name.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3143267" xml-lang="en-US"
level="2">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph role="bascode" id="par_id3154142"
xml-lang="en-US">ConvertFromURL(filename)</paragraph>
</bascode>
-<paragraph role="heading" id="hd_id3159157" xml-lang="en-US" level="2">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph role="paragraph" id="par_id3150669"
xml-lang="en-US">String</paragraph>
-<paragraph role="heading" id="hd_id3143270" xml-lang="en-US"
level="2">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US">
<emph>Filename:</emph> A file name as a string.</paragraph>
<embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
<embed href="text/sbasic/shared/00000003.xhp#err5"/>
<embed href="text/sbasic/shared/03120312.xhp#exampleconverttofromurl"/>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
diff --git a/source/text/sbasic/shared/03120314.xhp
b/source/text/sbasic/shared/03120314.xhp
index aae47d81c..23c8cc4d3 100644
--- a/source/text/sbasic/shared/03120314.xhp
+++ b/source/text/sbasic/shared/03120314.xhp
@@ -34,24 +34,24 @@
</bookmark>
-<paragraph id="hd_id3156027" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120314.xhp" name="Split Function">Split
Function</link></paragraph>
+<h1 id="hd_id3156027"><link href="text/sbasic/shared/03120314.xhp" name="Split
Function">Split Function</link></h1>
<paragraph id="par_id3155805" role="paragraph" xml-lang="en-US">Returns an
array of substrings from a string expression.</paragraph>
</section>
-<paragraph id="hd_id3149177" role="heading" level="2"
xml-lang="en-US">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph id="par_id3153824" role="bascode" xml-lang="en-US">Split (Text As
String, delimiter, number)</paragraph>
</bascode>
-<paragraph id="hd_id3149763" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph id="par_id3154285" role="paragraph"
xml-lang="en-US">String</paragraph>
-<paragraph id="hd_id3145315" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph id="par_id3156023" role="paragraph" xml-lang="en-US">
<emph>Text:</emph> Any string expression.</paragraph>
<paragraph id="par_id3147560" role="paragraph" xml-lang="en-US">
<emph>delimiter (optional):</emph> A string of one or more characters length
that is used to delimit the Text. The default is the space
character.</paragraph>
<paragraph id="par_id3145069" role="paragraph" xml-lang="en-US"> <emph>number
(optional):</emph> The number of substrings that you want to return.</paragraph>
-<paragraph id="hd_id3150398" role="heading" level="2"
xml-lang="en-US">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<section id="splitjoinex">
<bascode>
@@ -96,6 +96,9 @@
<paragraph id="par_idm1341238032" role="bascode" localize="false"
xml-lang="en-US">End Sub</paragraph>
</bascode>
</section>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
-</helpdocument>
\ No newline at end of file
+</helpdocument>
diff --git a/source/text/sbasic/shared/03120315.xhp
b/source/text/sbasic/shared/03120315.xhp
index 286c33e5d..361e666cc 100644
--- a/source/text/sbasic/shared/03120315.xhp
+++ b/source/text/sbasic/shared/03120315.xhp
@@ -1,5 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,7 +16,6 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<helpdocument version="1.0">
<meta>
<topic id="textsbasicshared03120315xml" indexer="include" status="PUBLISH">
@@ -32,22 +30,24 @@
<section id="join">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3149416"><bookmark_value>Join function</bookmark_value>
</bookmark>
-<paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="1"><link
href="text/sbasic/shared/03120315.xhp" name="Join Function">Join
Function</link></paragraph>
+<h1 id="hd_id3149416"><link href="text/sbasic/shared/03120315.xhp" name="Join
Function">Join Function</link></h1>
<paragraph role="paragraph" id="par_id3149670" xml-lang="en-US">Returns a
string from a number of substrings in a string array.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3159414" xml-lang="en-US"
level="2">Syntax:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
<bascode>
<paragraph role="bascode" id="par_id3156344" xml-lang="en-US">Join (Text As
String Array, delimiter)</paragraph>
</bascode>
-<paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="2">Return
value:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
<paragraph role="paragraph" id="par_id3150359"
xml-lang="en-US">String</paragraph>
-<paragraph role="heading" id="hd_id3148798" xml-lang="en-US"
level="2">Parameters:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US">
<emph>Text:</emph> A string array.</paragraph>
<paragraph role="paragraph" id="par_id3154908" xml-lang="en-US">
<emph>delimiter (optional):</emph> A string character that is used to separate
the substrings in the resulting string. The default delimiter is the space
character. If delimiter is a string of length zero "", the substrings are
joined without separator.</paragraph>
-<paragraph role="heading" id="hd_id3154218" xml-lang="en-US"
level="2">Example:</paragraph>
+<embed href="text/sbasic/shared/00000003.xhp#functexample"/>
<embed href="text/sbasic/shared/03120314.xhp#splitjoinex"/>
+<section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+</section>
</body>
</helpdocument>
-
diff --git a/source/text/sbasic/shared/03120401.xhp
b/source/text/sbasic/shared/03120401.xhp
index a1ccb0bf7..3bf471ea9 100644
--- a/source/text/sbasic/shared/03120401.xhp
+++ b/source/text/sbasic/shared/03120401.xhp
@@ -34,21 +34,21 @@
</bookmark>
-<paragraph id="hd_id3155934" role="heading" level="1" xml-lang="en-US"><link
href="text/sbasic/shared/03120401.xhp" name="InStr Function">InStr
Function</link></paragraph>
+<h1 id="hd_id3155934"><link href="text/sbasic/shared/03120401.xhp" name="InStr
Function">InStr Function</link></h1>
<paragraph id="par_id3153990" role="paragraph" xml-lang="en-US">Returns the
position of a string within another string.</paragraph>
</section>
<paragraph id="par_id3147303" role="paragraph" xml-lang="en-US">The Instr
function returns the position at which the match was found. 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>
+<h2 id="hd_id3145090">Syntax:</h2>
<bascode>
<paragraph id="par_id3146957" role="bascode" xml-lang="en-US">InStr ([Start As
Long,] Text1 As String, Text2 As String[, Compare])</paragraph>
</bascode>
-<paragraph id="hd_id3148538" role="heading" level="2" xml-lang="en-US">Return
value:</paragraph>
+<h2 id="hd_id3148538">Return value:</h2>
<paragraph id="par_id3149763" role="paragraph"
xml-lang="en-US">Integer</paragraph>
-<paragraph id="hd_id3148473" role="heading" level="2"
xml-lang="en-US">Parameters:</paragraph>
-<paragraph id="par_id3153126" role="paragraph" xml-lang="en-US"> <emph>Start:
</emph>A numeric expression that marks the position in a string where the
search for the specified substring starts. If you omit this parameter, the
search starts at the first character of the string. The maximum allowed value
is 65535.<comment>see i17928</comment></paragraph>
+<h2 id="hd_id3148473">Parameters:</h2>
+<paragraph id="par_id3153126" role="paragraph" xml-lang="en-US"> <emph>Start:
</emph>A numeric expression that marks the position in a string where the
search for the specified substring starts. If you omit this parameter, the
search starts at the first character of the string. The minimum allowed value
is 1. The maximum allowed value is 2,147,483,648.<comment>see
i17928</comment></paragraph>
<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_id3154758" role="paragraph" xml-lang="en-US">
<emph>Compare:</emph> Optional numeric expression that defines the type of
comparison. The value of this parameter can be 0 or 1. The default value of 1
specifies a text comparison that is not case-sensitive. The value of 0
specifies a binary comparison that is case-sensitive.<comment>fixes
i17929</comment></paragraph>
@@ -56,7 +56,7 @@
<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>
+<h2 id="hd_id3154366">Example:</h2>
<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>
diff --git a/source/text/sbasic/shared/replace.xhp
b/source/text/sbasic/shared/replace.xhp
index 7f4e825f1..7b8d819d9 100644
--- a/source/text/sbasic/shared/replace.xhp
+++ b/source/text/sbasic/shared/replace.xhp
@@ -50,5 +50,8 @@
<paragraph role="bascode" id="par_id501587778372566" xml-lang="en-US"
localize="false">msgbox replace ("ABCDEFGHI", "E", "*", 4)</paragraph>
<paragraph role="bascode" id="par_id861587778446685"
xml-lang="en-US">REM returns D*FGHI because the search starts at position 4,
which is also the start of the returned string.</paragraph>
</bascode>
+ <section id="relatedtopics">
+ <paragraph role="paragraph" id="par_id161599082457466"
localize="false"><embedvar
href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph>
+ </section>
</body>
</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
