Difference between revisions of "SUN Report Builder/Functions"
From Apache OpenOffice Wiki
m (Interwiki link) |
|||
Line 1: | Line 1: | ||
− | {{Database/Lang|Base/Reports/Functions}} | + | [[fr:FR/Documentation/Base/Rapports/Fonctions]] |
+ | {{Database/Lang|Base/Reports/Functions}} | ||
− | '''Date/Time'''<br> | + | '''Date/Time'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | + | |- | |
+ | | DATE | ||
+ | | Provides an internal number for the date given. | ||
+ | {| cellpadding="10" border="1" class="prettytable" | ||
|- | |- | ||
− | |||
− | |||
− | |||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | month | + | | month |
| An integer between 1 and 12 representing the month. | | An integer between 1 and 12 representing the month. | ||
|- | |- | ||
− | | day | + | | day |
| An integer between 1 and 31 representing the day of the month. | | An integer between 1 and 31 representing the day of the month. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | DATEDIF | + | | DATEDIF |
− | | Returns the number of years, months, or days between two dates. | + | | Returns the number of years, months, or days between two dates. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | EndDate | + | | EndDate |
| Second date. | | Second date. | ||
|- | |- | ||
− | | Format | + | | Format |
| Format code. | | Format code. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | DATEVALUE | + | | DATEVALUE |
− | | Returns an internal number for a text having a possible date format. | + | | Returns an internal number for a text having a possible date format. |
| | | | ||
− | |||
|- | |- | ||
− | | DAY | + | | DAY |
− | | Returns the sequential date of the month as an integer (1-31) in relation to the date value. | + | | Returns the sequential date of the month as an integer (1-31) in relation to the date value. |
| | | | ||
− | |||
|- | |- | ||
− | | DAYS | + | | DAYS |
− | | Calculates the number of days between two dates. | + | | Calculates the number of days between two dates. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | Date_1 | + | | Date_1 |
| The start date for calculating the difference in days. | | The start date for calculating the difference in days. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | HOUR | + | | HOUR |
− | | Determines the sequential number of the hour of the day (0-23) for the time value. | + | | Determines the sequential number of the hour of the day (0-23) for the time value. |
| | | | ||
− | |||
|- | |- | ||
− | | MINUTE | + | | MINUTE |
− | | Determines the sequential number for the minute of the hour (0-59) for the time value. | + | | Determines the sequential number for the minute of the hour (0-59) for the time value. |
| | | | ||
− | |||
|- | |- | ||
− | | MONTH | + | | MONTH |
− | | Determines the sequential number of a month of the year (1-12) for the date value. | + | | Determines the sequential number of a month of the year (1-12) for the date value. |
| | | | ||
− | |||
|- | |- | ||
− | | NOW | + | | NOW |
− | | Determines the current time of the computer. | + | | Determines the current time of the computer. |
| | | | ||
− | |||
|- | |- | ||
− | | SECOND | + | | SECOND |
− | | Determines the sequential number of the second of a minute (0-59) for the time value. | + | | Determines the sequential number of the second of a minute (0-59) for the time value. |
| | | | ||
− | |||
|- | |- | ||
− | | TIME | + | | TIME |
− | | Determines a time value from the details for hour, minute and second. | + | | Determines a time value from the details for hour, minute and second. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | minute | + | | minute |
| The integer for the minute. | | The integer for the minute. | ||
|- | |- | ||
− | | second | + | | second |
| The integer for the second. | | The integer for the second. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | TIMEVALUE | + | | TIMEVALUE |
− | | Returns a sequential number for a text shown in a possible time entry format. | + | | Returns a sequential number for a text shown in a possible time entry format. |
| | | | ||
− | |||
|- | |- | ||
− | | TODAY | + | | TODAY |
− | | Determines the current date of the computer. | + | | Determines the current date of the computer. |
| | | | ||
− | |||
|- | |- | ||
− | | WEEKDAY | + | | WEEKDAY |
− | | Returns the day of the week for the date value as an integer (1-7). | + | | Returns the day of the week for the date value as an integer (1-7). |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | Type | + | | Type |
| Fixes the beginning of the week and the type of calculation to be used.(1 = Sunday is the first day of the week, with value 1; Saturday has value 7, 2 = Monday is the first day of the week, with value 1; Sunday has value 7, 3 = Monday is the first day of the week, with value 0; Sunday has value 6) | | Fixes the beginning of the week and the type of calculation to be used.(1 = Sunday is the first day of the week, with value 1; Saturday has value 7, 2 = Monday is the first day of the week, with value 1; Sunday has value 7, 3 = Monday is the first day of the week, with value 0; Sunday has value 6) | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | YEAR | + | | YEAR |
− | | Returns the year of a date value as an integer. | + | | Returns the year of a date value as an integer. |
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''Mathematical'''<br> | + | <br> '''Mathematical'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | |||
|- | |- | ||
− | | ABS | + | | ABS |
− | | Absolute value of a number. | + | | Absolute value of a number. |
| | | | ||
− | |||
|- | |- | ||
− | | AVERAGE | + | | AVERAGE |
− | | Returns the average of a sample. | + | | Returns the average of a sample. |
| | | | ||
− | |||
|- | |- | ||
− | | AVERAGE | + | | AVERAGE |
− | | Returns the average of a sample. | + | | Returns the average of a sample. |
| | | | ||
− | |||
|- | |- | ||
− | | EVEN | + | | EVEN |
− | | Rounds a positive number up and negative number down to the nearest even integer. | + | | Rounds a positive number up and negative number down to the nearest even integer. |
| | | | ||
− | |||
|- | |- | ||
− | | MAX | + | | MAX |
− | | Returns the maximum value in a list of arguments. | + | | Returns the maximum value in a list of arguments. |
| | | | ||
− | |||
|- | |- | ||
− | | MAXA | + | | MAXA |
− | | Returns the maximum value in a list of arguments. Text is evaluated as zero. | + | | Returns the maximum value in a list of arguments. Text is evaluated as zero. |
| | | | ||
− | |||
|- | |- | ||
− | | MIN | + | | MIN |
− | | Returns the minimum value in a list of arguments. | + | | Returns the minimum value in a list of arguments. |
| | | | ||
− | |||
|- | |- | ||
− | | MINA | + | | MINA |
− | | Returns the smallest value in a list of arguments. Text is evaluated as zero. | + | | Returns the smallest value in a list of arguments. Text is evaluated as zero. |
| | | | ||
− | |||
|- | |- | ||
− | | MOD | + | | MOD |
− | | Calculates the remainder of a division. | + | | Calculates the remainder of a division. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | Divisor | + | | Divisor |
| The number by which the dividend is divided. | | The number by which the dividend is divided. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | ODD | + | | ODD |
− | | Rounds a positive number up and negative number down to the nearest odd integer. | + | | Rounds a positive number up and negative number down to the nearest odd integer. |
| | | | ||
− | |||
|- | |- | ||
− | | SUM | + | | SUM |
− | | Returns the sum of all arguments. | + | | Returns the sum of all arguments. |
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''Logical'''<br> | + | <br> '''Logical'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | |||
|- | |- | ||
− | | AND | + | | AND |
− | | Returns TRUE if all arguments are TRUE. | + | | Returns TRUE if all arguments are TRUE. |
| | | | ||
− | |||
|- | |- | ||
− | | FALSE | + | | FALSE |
− | | Defines the logical value as FALSE. | + | | Defines the logical value as FALSE. |
| | | | ||
− | |||
|- | |- | ||
− | | IF | + | | IF |
− | | Specifies a logical test to be performed. | + | | Specifies a logical test to be performed. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | Then_value | + | | Then_value |
| The result of the function if the logical test returns a TRUE. | | The result of the function if the logical test returns a TRUE. | ||
|- | |- | ||
− | | Otherwise_value | + | | Otherwise_value |
| The result of the function if the logical test returns FALSE. | | The result of the function if the logical test returns FALSE. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | NOT | + | | NOT |
− | | Reverses the value of the argument. | + | | Reverses the value of the argument. |
| | | | ||
− | |||
|- | |- | ||
− | | OR | + | | OR |
− | | Returns TRUE if an argument is TRUE. | + | | Returns TRUE if an argument is TRUE. |
| | | | ||
− | |||
|- | |- | ||
− | | TRUE | + | | TRUE |
− | | Returns the logical value TRUE. | + | | Returns the logical value TRUE. |
| | | | ||
− | |||
|- | |- | ||
− | | XOR | + | | XOR |
− | | Returns TRUE if a odd number of arguments are TRUE. | + | | Returns TRUE if a odd number of arguments are TRUE. |
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''Information'''<br> | + | <br> '''Information'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | + | |- | |
+ | | CHOOSE | ||
+ | | Selects a value from a list of up to 30 value arguments. | ||
+ | {| cellpadding="10" border="1" class="prettytable" | ||
|- | |- | ||
− | |||
− | |||
− | |||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | value | + | | value |
| Value 1, value 2,... The list of arguments from which a value is chosen. | | Value 1, value 2,... The list of arguments from which a value is chosen. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | COUNT | + | | COUNT |
− | | Counts how many numbers are in the list of arguments. | + | | Counts how many numbers are in the list of arguments. |
| | | | ||
− | |||
|- | |- | ||
− | | COUNTA | + | | COUNTA |
− | | Counts how many values are in the list of arguments. | + | | Counts how many values are in the list of arguments. |
| | | | ||
− | |||
|- | |- | ||
− | | COUNTBLANK | + | | COUNTBLANK |
− | | Counts the blank cells in a specified range. | + | | Counts the blank cells in a specified range. |
| | | | ||
− | |||
|- | |- | ||
− | | HASCHANGED | + | | HASCHANGED |
− | | Checks whether the columns specified by the given names has changed. | + | | Checks whether the columns specified by the given names has changed. |
| | | | ||
− | |||
|- | |- | ||
− | | ISBLANK | + | | ISBLANK |
− | | Returns TRUE if value refers to an empty cell. | + | | Returns TRUE if value refers to an empty cell. |
| | | | ||
− | |||
|- | |- | ||
− | | ISERR | + | | ISERR |
− | | Returns TRUE if the value is an error value not equal to #N/A. | + | | Returns TRUE if the value is an error value not equal to #N/A. |
| | | | ||
− | |||
|- | |- | ||
− | | ISERROR | + | | ISERROR |
− | | Returns TRUE if the value is an error value. | + | | Returns TRUE if the value is an error value. |
| | | | ||
− | |||
|- | |- | ||
− | | ISEVEN | + | | ISEVEN |
− | | Returns TRUE if value is an even integer. | + | | Returns TRUE if value is an even integer. |
| | | | ||
− | |||
|- | |- | ||
− | | ISLOGICAL | + | | ISLOGICAL |
− | | Returns TRUE if the value carries a logical number format. | + | | Returns TRUE if the value carries a logical number format. |
| | | | ||
− | |||
|- | |- | ||
− | | ISNA | + | | ISNA |
− | | Returns TRUE if value equals #N/A. | + | | Returns TRUE if value equals #N/A. |
| | | | ||
− | |||
|- | |- | ||
− | | ISNONTEXT | + | | ISNONTEXT |
− | | Returns TRUE if the value is not text. | + | | Returns TRUE if the value is not text. |
| | | | ||
− | |||
|- | |- | ||
− | | ISNUMBER | + | | ISNUMBER |
− | | Returns TRUE if value is a number. | + | | Returns TRUE if value is a number. |
| | | | ||
− | |||
|- | |- | ||
− | | ISODD | + | | ISODD |
− | | Returns TRUE if value is an odd integer. | + | | Returns TRUE if value is an odd integer. |
| | | | ||
− | |||
|- | |- | ||
− | | ISREF | + | | ISREF |
− | | Returns TRUE if value is a reference. | + | | Returns TRUE if value is a reference. |
| | | | ||
− | |||
|- | |- | ||
− | | ISTEXT | + | | ISTEXT |
− | | Returns TRUE if value is text. | + | | Returns TRUE if value is text. |
| | | | ||
− | |||
|- | |- | ||
− | | NA | + | | NA |
− | | Not available. Returns the error value #N/A. | + | | Not available. Returns the error value #N/A. |
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''User-Defined'''<br> | + | <br> '''User-Defined'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | |||
|- | |- | ||
− | | NULL | + | | NULL |
− | | Returns a NULL-Value | + | | Returns a NULL-Value |
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''Text'''<br> | + | <br> '''Text'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | + | |- | |
+ | | EXACT | ||
+ | | Specifies whether two texts are identical. | ||
+ | {| cellpadding="10" border="1" class="prettytable" | ||
|- | |- | ||
− | |||
− | |||
− | |||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | text_2 | + | | text_2 |
| The second text for comparing texts. | | The second text for comparing texts. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | FIND | + | | FIND |
− | | Looks for a string of text within another (case sensitive) | + | | Looks for a string of text within another (case sensitive) |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | text | + | | text |
| The text in which a search is to be made. | | The text in which a search is to be made. | ||
|- | |- | ||
− | | position | + | | position |
| The position in the text from which the search starts. | | The position in the text from which the search starts. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | LEFT | + | | LEFT |
− | | Returns the first character or characters of a text. | + | | Returns the first character or characters of a text. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | number | + | | number |
| The number of characters for the start text. | | The number of characters for the start text. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | LEN | + | | LEN |
− | | Calculates length of a text string. | + | | Calculates length of a text string. |
| | | | ||
− | |||
|- | |- | ||
− | | LOWER | + | | LOWER |
− | | Converts text to lowercase. | + | | Converts text to lowercase. |
| | | | ||
− | |||
|- | |- | ||
− | | MID | + | | MID |
− | | Returns a partial text string of a text. | + | | Returns a partial text string of a text. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | start | + | | start |
| The position from which the part word is to be determined. | | The position from which the part word is to be determined. | ||
|- | |- | ||
− | | number | + | | number |
| The number of characters for the text. | | The number of characters for the text. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | REPLACE | + | | REPLACE |
− | | Replaces characters within a text string with a different text string. | + | | Replaces characters within a text string with a different text string. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | position | + | | position |
| The character position from which text is to be replaced. | | The character position from which text is to be replaced. | ||
|- | |- | ||
− | | length | + | | length |
| The number of characters to be replaced. | | The number of characters to be replaced. | ||
|- | |- | ||
− | | new text | + | | new text |
| The text to be inserted. | | The text to be inserted. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | REPT | + | | REPT |
− | | Repeats text a given number of times. | + | | Repeats text a given number of times. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | number | + | | number |
| The number of times the text is to be repeated. | | The number of times the text is to be repeated. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | RIGHT | + | | RIGHT |
− | | Returns the last character or characters of a text. | + | | Returns the last character or characters of a text. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | number | + | | number |
| The number of characters for the end text. | | The number of characters for the end text. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | SUBSTITUTE | + | | SUBSTITUTE |
− | | Substitutes new text for old text in a string. | + | | Substitutes new text for old text in a string. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | search_text | + | | search_text |
| The partial string to be (repeatedly) replaced. | | The partial string to be (repeatedly) replaced. | ||
|- | |- | ||
− | | new text | + | | new text |
| The text which is to replace the text string. | | The text which is to replace the text string. | ||
|- | |- | ||
− | | occurrence | + | | occurrence |
| Which occurence of the old text is to be replaced. | | Which occurence of the old text is to be replaced. | ||
|} | |} | ||
| | | | ||
− | |||
|- | |- | ||
− | | T | + | | T |
− | | Converts a value into text. | + | | Converts a value into text. |
| | | | ||
− | |||
|- | |- | ||
− | | TEXT | + | | TEXT |
− | | Converts a number to text according to a given format. | + | | Converts a number to text according to a given format. |
| | | | ||
− | |||
|- | |- | ||
− | | TRIM | + | | TRIM |
− | | Removes extra spaces from text. | + | | Removes extra spaces from text. |
| | | | ||
− | |||
|- | |- | ||
− | | UNICHAR | + | | UNICHAR |
− | | Converts a code number into a Unicode character or letter. | + | | Converts a code number into a Unicode character or letter. |
| | | | ||
− | |||
|- | |- | ||
− | | UNICODE | + | | UNICODE |
− | | Returns the numeric code for the first Unicode character in a text string. | + | | Returns the numeric code for the first Unicode character in a text string. |
| | | | ||
− | |||
|- | |- | ||
− | | UPPER | + | | UPPER |
− | | Converts text to uppercase. | + | | Converts text to uppercase. |
| | | | ||
− | |||
|- | |- | ||
− | | URLENCODE | + | | URLENCODE |
− | | Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed. | + | | Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed. |
− | {| | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
| '''''Parameter Name''''' | | '''''Parameter Name''''' | ||
− | | '''''Parameter Description''''' | + | | '''''Parameter Description''''' |
− | |||
|- | |- | ||
− | | Encoding | + | | Encoding |
| The Encoding to be used. | | The Encoding to be used. | ||
|} | |} | ||
Line 565: | Line 510: | ||
| | | | ||
|} | |} | ||
− | <br> | + | |
− | '''Rounding'''<br> | + | <br> '''Rounding'''<br> |
− | {| | + | |
− | | '''''Function Name''''' | + | {| cellpadding="10" border="1" class="prettytable" |
+ | |- | ||
+ | | '''''Function Name''''' | ||
| '''''Description''''' | | '''''Description''''' | ||
− | | '''''Example ''''' | + | | '''''Example''''' |
− | |||
|- | |- | ||
− | | INT | + | | INT |
− | | Rounds a number down to the nearest integer. | + | | Rounds a number down to the nearest integer. |
| | | | ||
|} | |} | ||
+ | |||
<br> | <br> |
Revision as of 08:31, 30 May 2009
Date/Time
Function Name | Description | Example | ||||||
DATE | Provides an internal number for the date given.
|
|||||||
DATEDIF | Returns the number of years, months, or days between two dates.
|
|||||||
DATEVALUE | Returns an internal number for a text having a possible date format. | |||||||
DAY | Returns the sequential date of the month as an integer (1-31) in relation to the date value. | |||||||
DAYS | Calculates the number of days between two dates.
|
|||||||
HOUR | Determines the sequential number of the hour of the day (0-23) for the time value. | |||||||
MINUTE | Determines the sequential number for the minute of the hour (0-59) for the time value. | |||||||
MONTH | Determines the sequential number of a month of the year (1-12) for the date value. | |||||||
NOW | Determines the current time of the computer. | |||||||
SECOND | Determines the sequential number of the second of a minute (0-59) for the time value. | |||||||
TIME | Determines a time value from the details for hour, minute and second.
|
|||||||
TIMEVALUE | Returns a sequential number for a text shown in a possible time entry format. | |||||||
TODAY | Determines the current date of the computer. | |||||||
WEEKDAY | Returns the day of the week for the date value as an integer (1-7).
|
|||||||
YEAR | Returns the year of a date value as an integer. |
Mathematical
Function Name | Description | Example | ||||
ABS | Absolute value of a number. | |||||
AVERAGE | Returns the average of a sample. | |||||
AVERAGE | Returns the average of a sample. | |||||
EVEN | Rounds a positive number up and negative number down to the nearest even integer. | |||||
MAX | Returns the maximum value in a list of arguments. | |||||
MAXA | Returns the maximum value in a list of arguments. Text is evaluated as zero. | |||||
MIN | Returns the minimum value in a list of arguments. | |||||
MINA | Returns the smallest value in a list of arguments. Text is evaluated as zero. | |||||
MOD | Calculates the remainder of a division.
|
|||||
ODD | Rounds a positive number up and negative number down to the nearest odd integer. | |||||
SUM | Returns the sum of all arguments. |
Logical
Function Name | Description | Example | ||||||
AND | Returns TRUE if all arguments are TRUE. | |||||||
FALSE | Defines the logical value as FALSE. | |||||||
IF | Specifies a logical test to be performed.
|
|||||||
NOT | Reverses the value of the argument. | |||||||
OR | Returns TRUE if an argument is TRUE. | |||||||
TRUE | Returns the logical value TRUE. | |||||||
XOR | Returns TRUE if a odd number of arguments are TRUE. |
Information
Function Name | Description | Example | ||||
CHOOSE | Selects a value from a list of up to 30 value arguments.
|
|||||
COUNT | Counts how many numbers are in the list of arguments. | |||||
COUNTA | Counts how many values are in the list of arguments. | |||||
COUNTBLANK | Counts the blank cells in a specified range. | |||||
HASCHANGED | Checks whether the columns specified by the given names has changed. | |||||
ISBLANK | Returns TRUE if value refers to an empty cell. | |||||
ISERR | Returns TRUE if the value is an error value not equal to #N/A. | |||||
ISERROR | Returns TRUE if the value is an error value. | |||||
ISEVEN | Returns TRUE if value is an even integer. | |||||
ISLOGICAL | Returns TRUE if the value carries a logical number format. | |||||
ISNA | Returns TRUE if value equals #N/A. | |||||
ISNONTEXT | Returns TRUE if the value is not text. | |||||
ISNUMBER | Returns TRUE if value is a number. | |||||
ISODD | Returns TRUE if value is an odd integer. | |||||
ISREF | Returns TRUE if value is a reference. | |||||
ISTEXT | Returns TRUE if value is text. | |||||
NA | Not available. Returns the error value #N/A. |
User-Defined
Function Name | Description | Example |
NULL | Returns a NULL-Value |
Text
Function Name | Description | Example | ||||||||
EXACT | Specifies whether two texts are identical.
|
|||||||||
FIND | Looks for a string of text within another (case sensitive)
|
|||||||||
LEFT | Returns the first character or characters of a text.
|
|||||||||
LEN | Calculates length of a text string. | |||||||||
LOWER | Converts text to lowercase. | |||||||||
MID | Returns a partial text string of a text.
|
|||||||||
REPLACE | Replaces characters within a text string with a different text string.
|
|||||||||
REPT | Repeats text a given number of times.
|
|||||||||
RIGHT | Returns the last character or characters of a text.
|
|||||||||
SUBSTITUTE | Substitutes new text for old text in a string.
|
|||||||||
T | Converts a value into text. | |||||||||
TEXT | Converts a number to text according to a given format. | |||||||||
TRIM | Removes extra spaces from text. | |||||||||
UNICHAR | Converts a code number into a Unicode character or letter. | |||||||||
UNICODE | Returns the numeric code for the first Unicode character in a text string. | |||||||||
UPPER | Converts text to uppercase. | |||||||||
URLENCODE | Applies URL-Encoding to a text given in the first parameter using the encoding specified in the second parameter. If no encoding is given, ISO-8859-1 is assumed.
|
Rounding
Function Name | Description | Example |
INT | Rounds a number down to the nearest integer. |