Difference between revisions of "Documentation/How Tos/Calc: Text functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (talk | contribs) |
Javier Lopez (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{Documentation/MasterTOC | {{Documentation/MasterTOC | ||
|bookid=1234''' | |bookid=1234''' | ||
| − | |booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div> | + | |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]] | |ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Text_functions|<div style="font-size: 140%;">Text Functions]] | ||
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_BASE_function | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_BASE_function | ||
| Line 34: | Line 34: | ||
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | * [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]] | ||
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] | * [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]] | ||
| − | }} | + | }}__NOTOC__ |
==List of Calc Text functions== | ==List of Calc Text functions== | ||
Revision as of 05:52, 7 June 2013
List of Calc Text functions
| ARABIC | returns an Arabic number (eg 14), given a Roman number (eg XIV) |
| 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. |
| 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. |
| UPPER | converts a text string to uppercase. |
| VALUE | returns a number, given a text representation. |
Issues:
The forthcoming ODFF standard lists these text functions which are not yet available in Calc: ASC, JIS, UNICHAR, UNICODE
