Difference between revisions of "Documentation/How Tos/Calc: CODE function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(6 intermediate revisions by 4 users not shown)
Line 1: Line 1:
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|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]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_CONCATENATE_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_CLEAN_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Statistical_functions
 +
|ShowNextPart=block|NextPart=Documentation/Reference/Calc_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
 
 +
* [[Documentation/How_Tos/Calc:_BASE_function|<div style="font-size: 120%;">Base]]
 +
* [[Documentation/How_Tos/Calc:_CHAR_function|<div style="font-size: 120%;">Char]]
 +
* [[Documentation/How_Tos/Calc:_CLEAN_function|<div style="font-size: 120%;">Clean]]
 +
* [[Documentation/How_Tos/Calc:_CODE_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Code]]
 +
* [[Documentation/How_Tos/Calc:_CONCATENATE_function|<div style="font-size: 120%;">Concatenate]]
 +
* [[Documentation/How_Tos/Calc:_DECIMAL_function|<div style="font-size: 120%;">Decimal]]
 +
* [[Documentation/How_Tos/Calc:_DOLLAR_function|<div style="font-size: 120%;">Dollar]]
 +
* [[Documentation/How_Tos/Calc:_EXACT_function|<div style="font-size: 120%;">Exact]]
 +
* [[Documentation/How_Tos/Calc:_FIND_function|<div style="font-size: 120%;">Find]]
 +
* [[Documentation/How_Tos/Calc:_FIXED_function|<div style="font-size: 120%;">Fixed]]
 +
* [[Documentation/How_Tos/Calc:_LEFT_function|<div style="font-size: 120%;">Left]]
 +
* [[Documentation/How_Tos/Calc:_LEN_function|<div style="font-size: 120%;">Len]]
 +
* [[Documentation/How_Tos/Calc:_LOWER_function|<div style="font-size: 120%;">Lower]]
 +
* [[Documentation/How_Tos/Calc:_MID_function|<div style="font-size: 120%;">Mid]]
 +
* [[Documentation/How_Tos/Calc:_PROPER_function|<div style="font-size: 120%;">Proper]]
 +
* [[Documentation/How_Tos/Calc:_REPLACE_function|<div style="font-size: 120%;">Replace]]
 +
* [[Documentation/How_Tos/Calc:_REPT_function|<div style="font-size: 120%;">Rept]]
 +
* [[Documentation/How_Tos/Calc:_RIGHT_function|<div style="font-size: 120%;">Right]]
 +
* [[Documentation/How_Tos/Calc:_SEARCH_function|<div style="font-size: 120%;">Search]]
 +
* [[Documentation/How_Tos/Calc:_SUBSTITUTE_function|<div style="font-size: 120%;">Substitute]]
 +
* [[Documentation/How_Tos/Calc:_T_function|<div style="font-size: 120%;">T]]
 +
* [[Documentation/How_Tos/Calc:_TEXT_function|<div style="font-size: 120%;">Text]]
 +
* [[Documentation/How_Tos/Calc:_TRIM_function|<div style="font-size: 120%;">Trim]]
 +
* [[Documentation/How_Tos/Calc:_UPPER_function|<div style="font-size: 120%;">Upper]]
 +
* [[Documentation/How_Tos/Calc:_VALUE_function|<div style="font-size: 120%;">Value]]
 +
}}__TOC__
  
 
== CODE ==
 
== CODE ==
Line 17: Line 52:
 
: also returns <tt>'''72'''</tt>.
 
: also returns <tt>'''72'''</tt>.
  
{{Documentation/Note|The international standard ODFF will introduce the more versatile functions <tt>'''UNICODE'''</tt> and <tt>'''UNICHAR'''</tt>, which will be implemented in Calc.}}
+
{{Note|The international standard ODFF will introduce the more versatile functions <tt>'''UNICODE'''</tt> and <tt>'''UNICHAR'''</tt>, which will be implemented in Calc.}}
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: CHAR function|CHAR]]
 
* [[Documentation/How_Tos/Calc: CHAR function|CHAR]]
  
Line 26: Line 61:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Text functions]]

Revision as of 07:55, 17 July 2018


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.
Documentation note.png The international standard ODFF will introduce the more versatile functions UNICODE and UNICHAR, which will be implemented in Calc.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_CODE_function&oldid=243419"
Views
Personal tools
Navigation
Tools