Difference between revisions of "Documentation/How Tos/Calc: CODE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Javier Lopez (Talk | contribs) |
Javier Lopez (Talk | contribs) |
||
| Line 3: | Line 3: | ||
|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;">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: | + | |ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CONCATENATE_function |
| − | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc: | + | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_CLEAN_function |
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Statistical_functions | |ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Statistical_functions | ||
|ShowNextPart=block|NextPart=Documentation/Reference/Calc_functions | |ShowNextPart=block|NextPart=Documentation/Reference/Calc_functions | ||
Revision as of 19:59, 1 June 2013
CALC FUNCTIONS
- Text Functions
- BaseCharCleanCodeConcatenateDecimalDollarExactFindFixedLeftLenLowerMidProperReplaceReptRightSearchSubstituteTText
Contents
CODE
returns the numeric code for the first character in a text string.
Syntax:
CODE(text)
- returns the numeric code for the first character of the text string text, in the range 0-255.
- Codes greater than 127 may depend on your system's character mapping (for example iso-8859-1, iso-8859-2, Windows-1252, Windows-1250), and hence may not be portable.
Example:
CODE("H")
- returns 72, the character code for "H".
CODE("Hello")
- also returns 72.
-
