Modifier and Type | Method and 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 and Description |
---|---|
class |
DateDifFunction
This function returns the number of years, months, or days between two date
numbers.
The Format is a code from the following table, entered as text, that specifies the format you want: format Returns the number of y Years m Months. |
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 and 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!
Date: 02.07.2009
Time: 20:11:37
|
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 and 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 and 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 and Description |
---|---|
class |
IntFunction
This function returns a number down to the nearest integer.
|
Modifier and Type | Class and 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!
Date: 11.11.2009
Time: 13:02:29
|
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 and Description |
---|---|
class |
CsvArrayFunction
Todo: Document me!
Date: 02.07.2009
Time: 20:20:37
|
class |
CsvTextFunction
Todo: Document me!
Date: 02.07.2009
Time: 20:20:37
|
class |
NormalizeArrayFunction
Todo: Document me!
Date: 23.10.2009
Time: 11:43:28
|
class |
NullFunction
Creation-Date: Dec 18, 2006, 12:54:55 PM
|
Modifier and Type | Method and Description |
---|---|
Function |
FormulaFunction.getFunction()
Returns the initialized function.
|