SUN Report Builder/Functions
From Apache OpenOffice Wiki
The Sun Report Builder supplies the following functions:
Datetime
| Function Name | Description | Example |
| Date | ||
| Datetime | ||
| Day | ||
| Hour | ||
| Month | ||
| Now | ||
| Year | ||
| Today | ||
| Weekday | ||
| Time |
Financial
| Function Name | Description | Example |
| Financial |
Information
| Function Name | Description | Example |
| Choose | ||
| HasChanged | ||
| Information | ||
| IsBlank | ||
| IsErr | ||
| IsError | ||
| IsEven | ||
| IsLogical | ||
| IsNA | ||
| IsNonText | ||
| IsNumber | ||
| IsOdd | ||
| IsRef | ||
| IsText | ||
| Na |
Logical
| Function Name | Description | Example |
| And | ||
| False | ||
| If | ||
| Not | ||
| Or | ||
| True | ||
| Xor |
Math
| Function Name | Description | Example |
| Abs | ||
| Average | ||
| Even | ||
| Odd | ||
| Sum |
Rounding
| Function Name | Description | Example |
| Int |
Text
| Function Name | Description | Example |
| Exact | ||
| Find | ||
| Left | ||
| Len | ||
| Lower | ||
| Mid | ||
| Replace | ||
| Rept | ||
| Right | ||
| Substitute | ||
| Text | ||
| T | ||
| Trim | ||
| Upper | ||
| URL |
Userdefined
| Function Name | Description | Example |
| Mapped | ||
| Null |
