-You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in %PRODUCTNAME - PreferencesTools - Options - Language Settings - Languages. In Basic format codes, the decimal point (.) is always used as placeholder for the decimal separator defined in your locale and will be replaced by the corresponding character. +You can set the locale used for controlling the formatting numbers, dates and currencies in $[officename] Basic in %PRODUCTNAME - Preferences +Tools - Options - Language Settings - Languages. In Basic format codes, the decimal point (.) is always used as placeholder for the decimal separator defined in your locale and will be replaced by the corresponding character. 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.

ChrW function @@ -38,22 +38,18 @@ Returns the Unicode character that corresponds to the specified character code.

- -Syntax: +

ChrW(Expression As Integer) - -Return value: +

String - -Parameters: +

Expression: 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.

- -Example: +

Sub ExampleChrW ' This example inserts the greek letter Alpha and Omega in a string. diff --git a/source/text/sbasic/shared/03120411.xhp b/source/text/sbasic/shared/03120411.xhp index c0ab1daada..0e1e7c004f 100644 --- a/source/text/sbasic/shared/03120411.xhp +++ b/source/text/sbasic/shared/03120411.xhp @@ -28,7 +28,7 @@ -

InStrRev function @@ -39,16 +39,13 @@

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. - -Syntax: +

InStrRev (Text1 As String, Text2 As String [,Start As Long] [, Compare As Integer]) - -Return value: +

Long - -Parameters: +

Text1: The string expression that you want to search. Text2: The string expression that you want to search for. Start: Optional numeric expression that marks the position from the left 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. @@ -58,8 +55,7 @@ To avoid a run-time error, do not set the Compare parameter if the first return parameter is omitted.

- -Example: +

Sub ExamplePosition Dim sInput As String @@ -77,4 +73,4 @@

- \ No newline at end of file + diff --git a/source/text/sbasic/shared/03120412.xhp b/source/text/sbasic/shared/03120412.xhp index 11c69947d2..71ba4e6142 100644 --- a/source/text/sbasic/shared/03120412.xhp +++ b/source/text/sbasic/shared/03120412.xhp @@ -28,31 +28,27 @@ -

StrReverse function -StrReverse Function [Runtime - VBA] +StrReverse Function [Runtime - VBA] Returns the string with the character order reversed.

- -Syntax: +

StrReverse (Text1 As String) - -Return value: +

String - -Parameters: +

Text1: The string expression that you want to reverse the character order.

- -Example: +

Sub ExampleReverse Print StrReverse("ABCdefGH") ' return "HGfedCBA" @@ -60,4 +56,4 @@ - \ No newline at end of file + diff --git a/source/text/sbasic/shared/03140000.xhp b/source/text/sbasic/shared/03140000.xhp index 97cace90d2..10c2bcf03e 100644 --- a/source/text/sbasic/shared/03140000.xhp +++ b/source/text/sbasic/shared/03140000.xhp @@ -38,16 +38,13 @@ Returns the depreciation of an asset for a specified period using the arithmetic-declining method.

- - +

-DDB (Cost As Double, Salvage As Double, Life as Double, Period as Double, [Factor as Variant]) +DDB(Cost As Double, Salvage As Double, Life as Double, Period as Double, [Factor as Variant]) - - +

Double - - +

Cost fixes the initial cost of an asset. Salvage fixes the value of an asset at the end of its life. Life is the number of periods (for example, years or months) defining how long the asset is to be used. @@ -56,8 +53,7 @@ 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.

- - +

Sub ExampleDDB Dim ddb_yr1 As Double @@ -68,7 +64,7 @@

DDB function in CALC -VBA financial functions +

diff --git a/source/text/sbasic/shared/03140001.xhp b/source/text/sbasic/shared/03140001.xhp index 8246842a67..ce856be59e 100644 --- a/source/text/sbasic/shared/03140001.xhp +++ b/source/text/sbasic/shared/03140001.xhp @@ -38,16 +38,13 @@ Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).