Difference between revisions of "Documentation/How Tos/Calc: Text functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Issues:) |
|||
| (12 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | ==List of Calc Text functions== | + | {{Documentation/CalcFunc TextTOC |
| + | |ShowPrevPage={{{ShowPrevPage}}} | ||
| + | |PrevPage={{{PrevPage}}} | ||
| + | |ShowNextPage={{{ShowNextPage}}} | ||
| + | |NextPage={{{NextPage}}} | ||
| + | |bookid=CalcFunctions | ||
| + | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">[[Documentation/Reference/Calc_functions|CALC FUNCTIONS]]</div> | ||
| + | |ShowParttitle=block | ||
| + | |parttitle=[[Documentation/How_Tos/Calc:_Text_functions|<div style="font-size: 140%;">Text Functions]] | ||
| + | |ShowPrevPart=block | ||
| + | |PrevPart=Documentation/How_Tos/Calc:_Statistical_functions | ||
| + | |ShowNextPart=none | ||
| + | |NextPart=none | ||
| + | |toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div> | ||
| + | }}__NOTOC__ | ||
| + | |||
| + | [[File:open.jpg]] | ||
| + | ==<big> List of Calc Text functions</big> == | ||
{| border="0" cellpadding="0" cellspacing="10" align="left" | {| border="0" cellpadding="0" cellspacing="10" align="left" | ||
| Line 5: | Line 22: | ||
|[[Documentation/How_Tos/Calc: ARABIC function|'''ARABIC''']] | |[[Documentation/How_Tos/Calc: ARABIC function|'''ARABIC''']] | ||
|returns an Arabic number (eg 14), given a Roman number (eg XIV) | |returns an Arabic number (eg 14), given a Roman number (eg XIV) | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: ASC function|'''ASC''']] | ||
| + | |converts full-width to half-width ASCII and katakana characters. | ||
|-valign="top" | |-valign="top" | ||
| Line 49: | Line 70: | ||
|[[Documentation/How_Tos/Calc: FIXED function|'''FIXED''']] | |[[Documentation/How_Tos/Calc: FIXED function|'''FIXED''']] | ||
|returns a number as text with a specified format. | |returns a number as text with a specified format. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: JIS function|'''JIS''']] | ||
| + | |converts half-width to full-width ASCII and katakana characters. | ||
|-valign="top" | |-valign="top" | ||
| Line 105: | Line 130: | ||
|[[Documentation/How_Tos/Calc: TRIM function|'''TRIM''']] | |[[Documentation/How_Tos/Calc: TRIM function|'''TRIM''']] | ||
|removes excess spaces from a text string. | |removes excess spaces from a text string. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: UNICHAR function|'''UNICHAR ''']] | ||
| + | |converts a code number into a Unicode character or letter. | ||
| + | |||
| + | |-valign="top" | ||
| + | |[[Documentation/How_Tos/Calc: UNICODE function|'''UNICODE ''']] | ||
| + | |returns the numeric code for Unicode for the first character in a text string. | ||
|-valign="top" | |-valign="top" | ||
| Line 118: | Line 151: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
| + | ==Issues: == | ||
| + | The ODFF standard lists these text functions, which are available in Calc: | ||
| + | ASC, JIS | ||
| − | + | {{SeeAlso|EN| | |
| − | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | }} |
| − | + | [[Category: Documentation/Reference/Calc]] | |
| − | |||
| − | |||
| − | |||
Latest revision as of 12:45, 3 February 2024
List of Calc Text functions
| ARABIC | returns an Arabic number (eg 14), given a Roman number (eg XIV) |
| ASC | converts full-width to half-width ASCII and katakana characters. |
| BAHTTEXT | returns Thai text, given a number |
| BASE | returns a text representation of a number, in a specified base radix. |
| CHAR | returns a single text character, given a character code. |
| CLEAN | returns a text string with non-printing characters removed. |
| CODE | returns the numeric code for the first character in a text string. |
| CONCATENATE | combines several text strings into one string. |
| DECIMAL | returns a decimal number, given a text representation and its base radix. |
| DOLLAR | returns text representing a number in your local currency format. |
| EXACT | returns TRUE if two text strings are identical |
| FIND | returns the position of a string of text within another string. |
| FIXED | returns a number as text with a specified format. |
| JIS | converts half-width to full-width ASCII and katakana characters. |
| LEFT | returns text from the beginning of a text string. |
| LEN | returns the length of a text string. |
| LOWER | converts a text string to lowercase. |
| MID | returns text from the middle of a text string. |
| PROPER | returns text with words in lowercase after a capitalised first letter. |
| REPLACE | replaces part of a text string with a different text string. |
| REPT | returns a text string comprised of copies of another text string. |
| RIGHT | returns text from the end of a text string. |
| ROMAN | returns a Roman numeral (eg XIV), given a number. |
| SEARCH | returns the position of a text segment within a text string. |
| SUBSTITUTE | substitutes new text for old text in a text string. |
| T | returns the given text, or an empty text string if the target is not text. |
| TEXT | converts a number into text according to a given format. |
| TRIM | removes excess spaces from a text string. |
| UNICHAR | converts a code number into a Unicode character or letter. |
| UNICODE | returns the numeric code for Unicode for the first character in a text string. |
| UPPER | converts a text string to uppercase. |
| VALUE | returns a number, given a text representation. |
Issues:
The ODFF standard lists these text functions, which are available in Calc: ASC, JIS
See Also
