Difference between revisions of "SUN Report Builder/Functions"
From Apache OpenOffice Wiki
m (Interwiki link) |
|||
(2 intermediate revisions by 2 users not shown) | |||
Line 270: | Line 270: | ||
|- | |- | ||
| HASCHANGED | | HASCHANGED | ||
− | | Checks whether the columns specified by the given names has changed. | + | | Checks whether the columns specified by the given names has changed. Place a column name between double quotes. |
| | | | ||
|- | |- | ||
Line 510: | Line 510: | ||
| | | | ||
|} | |} | ||
+ | |||
+ | CONCAT or CONCATENATE functions not supported, but you can use [Textfieldname]&" "&[Textfieldname] to concatenate text fields. | ||
<br> '''Rounding'''<br> | <br> '''Rounding'''<br> | ||
Line 525: | Line 527: | ||
<br> | <br> | ||
+ | [[Category:Database]] [[Category:Extensions]] |
Latest revision as of 11:50, 11 May 2010
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. Place a column name between double quotes. | |||||
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.
|
CONCAT or CONCATENATE functions not supported, but you can use [Textfieldname]&" "&[Textfieldname] to concatenate text fields.
Rounding
Function Name | Description | Example |
INT | Rounds a number down to the nearest integer. |