Difference between revisions of "Documentation/How Tos/Calc: Text functions"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Issues:)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{Documentation/CalcFunc TextTOC
−
|bookid=1234'''
+
|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>
 
|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
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_BASE_function
+
|parttitle=[[Documentation/How_Tos/Calc:_Text_functions|<div style="font-size: 140%;">Text Functions]]
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_SMALL_function
+
|ShowPrevPart=block
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Statistical_functions
+
|PrevPart=Documentation/How_Tos/Calc:_Statistical_functions
−
|ShowNextPart=block|NextPart=Documentation/Reference/Calc_functions
+
|ShowNextPart=none
 +
|NextPart=none
 
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 
|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%;">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]]
 
 
}}__NOTOC__
 
}}__NOTOC__
  
−
==List of Calc Text functions==
+
[[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 42: 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 86: 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 142: 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 156: Line 152:
  
 
==Issues: ==
 
==Issues: ==
−
The forthcoming ODFF standard lists these text functions which are not yet available in Calc:
+
The ODFF standard lists these text functions, which are available in Calc:
−
ASC, JIS, UNICHAR, UNICODE
+
ASC, JIS
  
 
{{SeeAlso|EN|
 
{{SeeAlso|EN|
−
* [[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]]
 
[[Category: Documentation/Reference/Calc]]

Latest revision as of 12:45, 3 February 2024



Open.jpg

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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Text_functions&oldid=260135"
Views
Personal tools
Navigation
Print/export
Tools