Modifier and Type | Method | Description |
---|---|---|
Function |
DefaultFunctionRegistry.createFunction(java.lang.String name) |
|
Function |
FunctionRegistry.createFunction(java.lang.String name) |
|
Function[] |
DefaultFunctionRegistry.getFunctions() |
|
Function[] |
FunctionRegistry.getFunctions() |
|
Function[] |
DefaultFunctionRegistry.getFunctionsByCategory(FunctionCategory category) |
|
Function[] |
FunctionRegistry.getFunctionsByCategory(FunctionCategory category) |
Modifier and Type | Class | Description |
---|---|---|
class |
DateDifFunction |
This function returns the number of years, months, or days between two date
numbers.
|
class |
DateFunction |
Creation-Date: 04.11.2006, 18:59:11
|
class |
DateValueFunction |
This function returns
|
class |
DayFunction |
This function extracts the day from a date.
|
class |
DaysFunction |
This is the same as DATEDIFF(date_1, date_2, "d");
|
class |
HourFunction |
This function extracts the hour (0 through 23) from a time.
|
class |
MinuteFunction |
This function extracts the minute (0 through 59) from a time.
|
class |
MonthFunction |
This function extracts the month from a date.
|
class |
NowFunction |
Return the serial number of the current date and time.
|
class |
SecondFunction |
This function extracts the minute (0 through 59) from a time.
|
class |
TimeFunction |
This fonction constructs a time from hours, minutes, and seconds.
|
class |
TimeValueFunction |
This fonction constructs a time from hours, minutes, and seconds.
|
class |
TodayFunction |
Todo: Document me!
|
class |
WeekDayFunction |
This function extracts the day of week from a date.
|
class |
YearFunction |
This function extracts the year from a date.
|
Modifier and Type | Class | Description |
---|---|---|
class |
ChooseFunction |
This function uses an index to return a value from a list of values.
|
class |
CountAFunction |
This function counts the number of non-empty values in the list of AnySequences provided.
|
class |
CountBlankFunction |
This function counts the number of blank cells in the Reference provided.
|
class |
CountFunction |
This function counts the numbers in the list of NumberSequences provided.
|
class |
HasChangedFunction |
Creation-Date: 24.11.2006, 13:02:41
|
class |
IndexFunction |
Todo: Document me!
|
class |
IsBlankFunction |
Document me!
|
class |
IsErrFunction |
This function returns true if the parameter is of error and not of error type NA.
|
class |
IsErrorFunction |
This function returns true if the parameter is of error.
|
class |
IsEvenFunction |
This function retruns true if the given value is an even number.
|
class |
IsLogicalFunction |
This function checks whatever the given value is of Logical type.
|
class |
IsNaFunction |
This function returns true if the parameter is of error type NA.
|
class |
IsNonTextFunction |
This function retruns false if the given value is of type Text.
|
class |
IsNumberFunction |
This function retruns true if the given value is of type Number.
|
class |
IsOddFunction |
This function retruns true if the given value is an odd number.
|
class |
IsRefFunction |
This function retruns true if the given value is reference.
|
class |
IsTextFunction |
This function retruns true if the given value is of type Text.
|
class |
NaFunction |
This function class represents the constant error NA.
|
class |
ValueFunction |
This function returns the number value of a text string.
|
Modifier and Type | Class | Description |
---|---|---|
class |
AndFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
FalseFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
IfFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
NotFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
OrFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
TrueFunction |
Creation-Date: 04.11.2006, 18:28:15
|
class |
XorFunction |
Creation-Date: 04.11.2006, 18:28:15
|
Modifier and Type | Class | Description |
---|---|---|
class |
AbsFunction |
This function returns the absolute (nonnegative) of the value.
|
class |
AcosFunction |
This function returns the acos of the value.
|
class |
AcoshFunction |
This function returns the acos of the value.
|
class |
AsinFunction |
This function returns the acos of the value.
|
class |
Atan2Function |
This function returns the acos of the value.
|
class |
AtanFunction |
This function returns the acos of the value.
|
class |
AverageAFunction |
This function returns the average of the number sequence.
|
class |
AverageFunction |
This function returns the average of the number sequence.
|
class |
CosFunction |
This function returns the acos of the value.
|
class |
EvenFunction |
This function returns the rounding of a number up to the nearest even
integer.
|
class |
ExpFunction |
This function returns the acos of the value.
|
class |
LnFunction |
This function returns the acos of the value.
|
class |
Log10Function |
This function returns the acos of the value.
|
class |
LogFunction |
This function returns the acos of the value.
|
class |
MaxAFunction |
This function returns the maximum from a set of numbers.
|
class |
MaxFunction |
This function returns the maximum from a set of numbers.
|
class |
MinAFunction |
This function returns the minimum from a set of numbers.
|
class |
MinFunction |
This function returns the minimum from a set of numbers.
|
class |
ModFunction |
This function returns the remainder when one number is divided by another number.
|
class |
OddFunction |
This function returns the rounding a number up to the nearest odd integer,
where "up" means "away from 0".
|
class |
PiFunction |
This function returns the acos of the value.
|
class |
PowerFunction |
This function returns the value of one number raised to the power of another number.
|
class |
SinFunction |
This function returns the acos of the value.
|
class |
SqrtFunction |
This function returns the sqrt of the value.
|
class |
SumAFunction |
Creation-Date: 31.10.2006, 17:39:19
|
class |
SumFunction |
Creation-Date: 31.10.2006, 17:39:19
|
class |
VarFunction |
This function returns the acos of the value.
|
Modifier and Type | Class | Description |
---|---|---|
class |
IntFunction |
This function returns a number down to the nearest integer.
|
Modifier and Type | Class | Description |
---|---|---|
class |
ExactFunction |
This function reports if two given text values are exactly equal using a case-sensitive comparison.
|
class |
FindFunction |
This function returns the starting position of a given text in the given text.
|
class |
LeftFunction |
This function returns a selected number of text characters from the left.
This function depends on MidFunction . |
class |
LenFunction |
This function returns the lengh in characters of the given value.
|
class |
LowerFunction |
This function returns the given text in lower case.
|
class |
MessageFunction |
Todo: Document me!
|
class |
MidFunction |
This function returns extracted text, given an original text, starting position, and length.
|
class |
ReplaceFunction |
This function returns text where an old text is substituted with a new text.
|
class |
ReptFunction |
This function returns text repeated Count times.
|
class |
RightFunction |
This function returns a selected number of text characters from the right.
This function depends on MidFunction . |
class |
SubstituteFunction |
This function returns text where an old text is substituted with a new text.
|
class |
TextFunction |
This function returns the given value as text.
|
class |
TFunction |
This function returns the given text value or a zero lenght string for non text type.
|
class |
TrimFunction |
This function returns the given text free of leading spaces.
|
class |
UnicharFunction |
This function returns the given value as text.
|
class |
UnicodeFunction |
This function returns the given value as text.
|
class |
UpperFunction |
This function returns the given text in upper case.
|
class |
URLEncodeFunction |
This function encodes a given text using the URL-Encoding schema.
|
Modifier and Type | Class | Description |
---|---|---|
class |
CsvArrayFunction |
Todo: Document me!
|
class |
CsvTextFunction |
Todo: Document me!
|
class |
NormalizeArrayFunction |
Todo: Document me!
|
class |
NullFunction |
Creation-Date: Dec 18, 2006, 12:54:55 PM
|
Modifier and Type | Method | Description |
---|---|---|
Function |
FormulaFunction.getFunction() |
Returns the initialized function.
|