Difference between revisions of "Documentation/How Tos/Calc: Text functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
Javier Lopez (Talk | contribs) |
||
Line 1: | Line 1: | ||
+ | {{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:_BASE_function | ||
+ | |ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_SMALL_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> | ||
+ | |||
+ | <div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Spreadsheet Lookup 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]] | ||
+ | }}__TOC__ | ||
+ | |||
==List of Calc Text functions== | ==List of Calc Text functions== | ||
Revision as of 19:47, 1 June 2013
CALC FUNCTIONS
- Text FunctionsSpreadsheet Lookup functions
- BaseCharCleanCodeConcatenateDecimalDollarExactFindFixedLeftLenLowerMidProperReplaceReptRightSearchSubstituteTText
Contents
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
Template:Documentation/SeeAlso
-