From 55fb7f4908d0c2f8eeb4d6df54a070cd27fa1a38 Mon Sep 17 00:00:00 2001 From: Steve Fanning Date: Sat, 30 May 2020 15:41:45 +0200 Subject: (04060110.xhp) General updates to function syntax statements in Help file, to include square brackets indicating optional parameters. Also updated example for PROPER() function to reflect more appropriate sample string! Change-Id: I42f485f3e312c2d870059b60b3dcdc7d8921a0d8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95195 Tested-by: Jenkins Reviewed-by: Olivier Hallot (cherry picked from commit 4bafa9e1d40f614b8d23637ce7fe49c0460f6553) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95716 Reviewed-by: Ilmari Lauhakangas --- source/text/scalc/01/04060110.xhp | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'source') diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 5f0bbc9c52..0c8859a615 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -107,7 +107,7 @@ Converts a positive integer to a specified base into a text from the numbering system. The digits 0-9 and the letters A-Z are used. -BASE(Number; Radix; [MinimumLength]) +BASE(Number; Radix [; MinimumLength]) Number is the positive integer to be converted. Radix indicates the base of the number system. It may be any positive integer between 2 and 36. MinimumLength (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string. @@ -233,7 +233,7 @@ You set the currency format in your system settings. -DOLLAR(Value; Decimals) +DOLLAR(Value [; Decimals]) Value is a number, a reference to a cell containing a number, or a formula which returns a number. Decimals is the optional number of decimal places. @@ -272,7 +272,7 @@ Returns the position of a string of text within another string.You can also define where to begin the search. The search term can be a number or any string of characters. The search is case-sensitive. -FIND("FindText"; "Text"; Position) +FIND("FindText"; "Text" [; Position]) FindText refers to the text to be found. Text is the text where the search takes place. Position (optional) is the position in the text from which the search starts. @@ -292,7 +292,7 @@ Returns a number as text with a specified number of decimal places and optional thousands separators. -FIXED(Number; Decimals; NoThousandsSeparators) +FIXED(Number; Decimals [; NoThousandsSeparators]) Number refers to the number to be formatted. Decimals refers to the number of decimal places to be displayed. NoThousandsSeparators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed. @@ -330,7 +330,7 @@ Returns the first character or characters of a text. -LEFT("Text"; Number) +LEFT("Text" [; Number]) Text is the text where the initial partial words are to be determined. Number (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned. @@ -349,7 +349,7 @@ Returns the first characters of a DBCS text. -LEFTB("Text"; Number_bytes) +LEFTB("Text" [; Number_bytes]) Text is the text where the initial partial words are to be determined. Number_bytes (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned. @@ -485,7 +485,7 @@ Text refers to the text to be converted. - =PROPER("open office") returns Open Office. + =PROPER("the document foundation") returns The Document Foundation.
@@ -545,7 +545,7 @@ Returns the last character or characters of a text. -RIGHT("Text"; Number) +RIGHT("Text" [; Number]) Text is the text of which the right part is to be determined. Number (optional) is the number of characters from the right part of the text. @@ -564,7 +564,7 @@ Returns the last character or characters of a text with double bytes characters sets (DBCS). -RIGHTB("Text"; Number_bytes) +RIGHTB("Text" [; Number_bytes]) Text is the text of which the right part is to be determined. Number_bytes (optional) specifies the number of characters you want RIGHTB to extract, based on bytes. @@ -587,7 +587,7 @@ Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. -ROMAN(Number; Mode) +ROMAN(Number [; Mode]) Number is the number that is to be converted into a Roman numeral. Mode (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number. @@ -611,7 +611,7 @@ Returns the position of a text segment within a character string. You can set the start of the search as an option. The search text can be a number or any sequence of characters. The search is not case-sensitive. If the text is not found, returns error 519 (#VALUE). -SEARCH("FindText"; "Text"; Position) +SEARCH("FindText"; "Text" [; Position]) FindText is the text to be searched for. Text is the text where the search will take place. Position (optional) is the position in the text where the search is to start. @@ -631,7 +631,7 @@ Substitutes new text for old text in a string. -SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence) +SUBSTITUTE("Text"; "SearchText"; "NewText" [; Occurrence]) Text is the text in which text segments are to be exchanged. SearchText is the text segment that is to be replaced (a number of times). NewText is the text that is to replace the text segment. -- cgit