| | Class | Description |
|---|
 | BuiltInFunctionBase | Base class for the built in functions. |
| FormulaErrorBaseEventArgs | |
| UCEventQueue | Summary description for UCEventQueue. |
| UCFunctionFactory | This class manages the list of formula functions available in UltraCalc as well as methods to locate and instaniate function classes. |
| UltraCalcBinaryOperatorBase | Abstract base class for binary operator functions. |
| UltraCalcFunction | Base class for formula functions. |
| UltraCalcFunctionAbs | Calculates a number's absolute value. |
| UltraCalcFunctionACos | Returns the angle (measured in radians) having the specified value of the trigonometric cosine function. |
| UltraCalcFunctionACosh | Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function. |
| UltraCalcFunctionAnd | Logical-AND returns the boolean value, FALSE, if at least one argument has a value of FALSE. When all arguments are TRUE, then this function returns TRUE. |
| UltraCalcFunctionASin | Returns the angle (measured in radians) having the specified value of the trigonometric sine function. |
| UltraCalcFunctionASinh | Returns the angle (measured in radians) having the specified value of it's hyperbolic sine function. |
| UltraCalcFunctionATan | Calculates the normalized angle (measured in radians) which has the specified tangent function value. |
| UltraCalcFunctionATan2 | Calculates the angle made with the x-axis on a Cartesian coordinate plane by the specified (x, y) coordinates. |
| UltraCalcFunctionATanh | Calculates the hyperbolic tangent of a specified angle measured in radians. |
| UltraCalcFunctionAveDev | Returns the average deviation from the average of all numeric values. |
| UltraCalcFunctionAverage | Calculates an average (arithmetic mean) for a series of numbers. |
| UltraCalcFunctionBin2Dec | Returns the decimal value of a string representation of a number in a binary system. |
| UltraCalcFunctionBin2Hex | Converts a string representing a binary number to a string representing the same number in the hexadecimal number system. |
| UltraCalcFunctionBin2Oct | Converts a string representing a binary number to a string representing the same number in the octal number system. |
| UltraCalcFunctionBinomDist | Returns the individual term binomial distribution probability. |
| UltraCalcFunctionCeiling | Returns the smallest whole number greater than or equal to the given number |
| UltraCalcFunctionChar | Returns the character specified by the code number from the character set for your computer. |
| UltraCalcFunctionChoose | The CHOOSE function returns one of the values provided in its arguments based on the number in the first argument. |
| UltraCalcFunctionCode | Gives you the numeric code corresponding the the first character in a specific text string. |
| UltraCalcFunctionCombin | Returns the number of possible combinations given a set of items and a number of chosen items from that set. |
| UltraCalcFunctionCombina | Returns the number of possible combinations (with repetitions) given a set of items and a number of chosen items from that set. |
| UltraCalcFunctionComplex | Returns a complex number represented as a string in the format "x + yi" or "x + yj" by comining a real and imaginary number. |
| UltraCalcFunctionConcat | '&' formula operator used to concatenate two strings. ("First" & "Second") |
| UltraCalcFunctionConcatenate | Combines two or more text values into a single text string. |
| UltraCalcFunctionConvert | Converts a value from one system of measurement to another. For example, meters to inches or hours to seconds. |
| UltraCalcFunctionCos | Calculates the trigonometric cosine of a specified angle (measured in radians). |
| UltraCalcFunctionCosh | Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function. |
| UltraCalcFunctionCount | Counts how many cells have numeric or date/time values. |
| UltraCalcFunctionCountA | Counts how many cells are not blank. |
| UltraCalcFunctionCritBinom | Returns the the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| UltraCalcFunctionDate | Returns the .NET DateTime ticks number that represents a particular date |
| UltraCalcFunctionDateAdd | Returns a System.DateTime value resulting from adding a specified interval to a DateTime. |
| UltraCalcFunctionDateDiff | Returns a value specifying the number of time intervals between two DateTime values. |
| UltraCalcFunctionDateValue | Returns the .NET DateTime of the time represented by date formated in a string |
| UltraCalcFunctionDay | Returns the day of a date value |
| UltraCalcFunctionDays360 | Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. |
| UltraCalcFunctionDB | Calculates an asset's depreciation using the fixed declining balance (DB) method over a specified term. |
| UltraCalcFunctionDBNull | Returns DBNull |
| UltraCalcFunctionDDB | Calculates an asset's depreciation using the double declining balance (DDB) or another weighted factor method over a specified term. |
| UltraCalcFunctionDec2Bin | Returns a string representing the specified decimal value as a binary number. |
| UltraCalcFunctionDec2Hex | Returns a string representing the specified decimal value as a hexadecimal number. |
| UltraCalcFunctionDec2Oct | Returns a string representing the specified decimal value as a octal number. |
| UltraCalcFunctionDec2XBase | Returns a string representing the specified decimal value in the specified base number scheme. |
| UltraCalcFunctionDegrees | Converts radians to degrees. |
| UltraCalcFunctionDelta | Compares two numbers and returns 1 if they are equal or 0 if they are not. |
| UltraCalcFunctionDescriptor | Describes a function table entry and provides methods to access information about the function's arguments. |
| UltraCalcFunctionDivide | '/' Division formula operator (3/2) |
| UltraCalcFunctionDollarDe | Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction. |
| UltraCalcFunctionDollarFr | Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction. |
| UltraCalcFunctionEDate | Returns a date that is the specified number of months before or after the start date. |
| UltraCalcFunctionEOMonth | Returns a date that is at the end of the month which is the specified number of months before or after the start date. |
| UltraCalcFunctionEqual | '=' Equality formula operator (Price = 200) |
| UltraCalcFunctionErrorType | When an error value is returned, the ERRORTYPE function returns a numeric value corresponding to the UltraCalcErrorCode enumeration. |
| UltraCalcFunctionEven | Rounds a positive number up and a negative number down to the nearest even integer. |
| UltraCalcFunctionExp | Calculates the mathematical constant, e, raised to the specified power. |
| UltraCalcFunctionExpon | "^" Exponentiation formula operator (3^2) |
| UltraCalcFunctionFact | Returns the factorial of a number. |
| UltraCalcFunctionFactDouble | Returns the double factorial of a number. |
| UltraCalcFunctionFactory | Class used to manage the stock and user defined UltraCalcFunction instances |
| UltraCalcFunctionFalse | A constant function always returning the FALSE value of Boolean logic. |
| UltraCalcFunctionFind | Finds one piece of text within another piece of text. |
| UltraCalcFunctionFixed | Formats a numeric value rounded to a specified number of decimal places and with optional thousands separators. |
| UltraCalcFunctionFloor | Calculates the next lesser whole number for a specified numeric value. |
| UltraCalcFunctionFV | Calculates the future value of an annuity having fixed payments and assuming a fixed interest rate or rate of return. |
| UltraCalcFunctionGcd | Returns the greatest common divisor of integer values. |
| UltraCalcFunctionGE | ">=" Greater than or equal formula operator (Price >= 200) |
| UltraCalcFunctionGeStep | Compares two numbers and returns 1 the first number is greater than or equal to the second or returns 0 if not. |
| UltraCalcFunctionGT | ">" Greater than formula operator (Price > 200) |
| UltraCalcFunctionHex2Bin | Converts a string representing an hexadecimal number to a string representing the same number in the binary number system. |
| UltraCalcFunctionHex2Dec | Returns the decimal value of a string representation of a number in a hexadecimal system. |
| UltraCalcFunctionHex2Oct | Converts a string representing an hexadecimal number to a string representing the same number in the octal number system. |
| UltraCalcFunctionHour | Returns the hour of a time value |
| UltraCalcFunctionIf | Chooses between two outcomes (or UltraCalc expressions to evaluate) based on the result of a logical test on a value or UltraCalc expression you specify. |
| UltraCalcFunctionIfError | Returns one of two values depending on whether or not the first value is an error or not. |
| UltraCalcFunctionImAbs | Returns the absolute value of a complex number. |
| UltraCalcFunctionImaginary | Returns the imaginary coefficient of a complex number. |
| UltraCalcFunctionImArgument | Returns the argument theta, and angle expressed in radians. |
| UltraCalcFunctionImConjugate | Returns the conjugate of a complex number. |
| UltraCalcFunctionImCos | Returns the cosine of a complex number. |
| UltraCalcFunctionImDiv | Returns the quotient of two complex numbers. |
| UltraCalcFunctionImExp | Returns the exponential of a complex number. |
| UltraCalcFunctionImLn | Returns the natural logarithm of a complex number. |
| UltraCalcFunctionImLog10 | Returns the base-10 logarithm of a complex number. |
| UltraCalcFunctionImLog2 | Returns the base-2 logarithm of a complex number. |
| UltraCalcFunctionImPower | Returns the complex number raised to the specified power. |
| UltraCalcFunctionImProduct | Returns the product of 1 to n complex numbers. |
| UltraCalcFunctionImReal | Returns the real coefficient of a complex number. |
| UltraCalcFunctionImSin | Returns the sine of a complex number. |
| UltraCalcFunctionImSqrt | Returns the square root of a complex number. |
| UltraCalcFunctionImSub | Returns the difference between two complex numbers. |
| UltraCalcFunctionImSum | Returns the sum of 1 to n complex numbers. |
| UltraCalcFunctionInfo | Returns information about the current operating environment. |
| UltraCalcFunctionInt | Converts a real numeric value (which may have a fractional part) into a whole number. |
| UltraCalcFunctionIntRate | Calculates the interest rate yielded by a security investment redeemable at a future date, such as a zero coupon bond. |
| UltraCalcFunctionIPmt | Calculates the interest portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest. |
| UltraCalcFunctionIRR | Calculates an internal rate of return for a given series of cash flows represented by either positive (incoming) or negative (outgoing) numeric values. |
| UltraCalcFunctionIsBlank | Returns TRUE if the specified value is blank. |
| UltraCalcFunctionIsDBNull | Returns a boolean indicating if the value is DBNull. |
| UltraCalcFunctionIsErr | Returns TRUE if the specified value is any error value, except #N/A! |
| UltraCalcFunctionIsError | Returns TRUE if the specified value is any error value without exception. |
| UltraCalcFunctionIsEven | Returns TRUE if the specified value is an even number. |
| UltraCalcFunctionIsLogical | Returns TRUE if the specified value refers to a two-state logic or Boolean value. |
| UltraCalcFunctionIsNa | Returns TRUE if an error value is #N/A (not applicable.) |
| UltraCalcFunctionIsNonText | Returns TRUE if the specified value refers to any not-text value. |
| UltraCalcFunctionIsNull | Returns a boolean indicating if the value is null (Nothing in VB). |
| UltraCalcFunctionIsNumber | Returns TRUE if the specified value refers to a numeric value. |
| UltraCalcFunctionIsOdd | Returns TRUE if the specified value is an odd number. |
| UltraCalcFunctionIsRef | Returns TRUE if the specified value is an UltraCalc reference. |
| UltraCalcFunctionIsText | Returns TRUE if the specified value refers to a text (or string) value. |
| UltraCalcFunctionLcm | Returns the least common multiple of integer values. |
| UltraCalcFunctionLE | "<=" Less than or equal formula operator (Price <= 200) |
| UltraCalcFunctionLeft | Gets the leftmost characters from a text value, up to the specified number of characters. |
| UltraCalcFunctionLen | Counts the number of characters in a text value. |
| UltraCalcFunctionLn | Calculates the natural logarithm of a specified numeric value. |
| UltraCalcFunctionLog | Calculates a logarithm for a specified numeric value to the specified base. |
| UltraCalcFunctionLog10 | Calculates the logarithm (base 10) of a specified numeric value. |
| UltraCalcFunctionLower | Converts a text value to all lowercase letters. |
| UltraCalcFunctionLT | '<' Less than formula operator (Price < 200) |
| UltraCalcFunctionMax | Gives you the largest numeric value out of a series. |
| UltraCalcFunctionMedian | Calculates the median value of a specified list of numeric values. |
| UltraCalcFunctionMid | Gets a specified number of characters from the middle of a text string, starting from a specified position in that string. |
| UltraCalcFunctionMin | Gives you the smallest numeric value out of a series. |
| UltraCalcFunctionMinus | '-' Subtraction formula operator (3-2) |
| UltraCalcFunctionMinute | Returns the minute of a time value |
| UltraCalcFunctionMod | Gets the remainder following integer division of two numbers. |
| UltraCalcFunctionMonth | Returns the month of a date value |
| UltraCalcFunctionMRound | Rounds a number to the nearest multiple of another number. |
| UltraCalcFunctionMultinomial | Returns the multinomial of a set of numbers. |
| UltraCalcFunctionMultiply | '*' Multiplication formula operator (2*3) |
| UltraCalcFunctionN | Converts a value to a number. |
| UltraCalcFunctionNa | Returns #N/A!, the error value representing a not applicable result. |
| UltraCalcFunctionNE | "<>" Inequality formula operator (Price <> 200) |
| UltraCalcFunctionNetWorkDays | Returns the total number of whole work days between the specified dates, excluding any specified holidays. |
| UltraCalcFunctionNot | Logical-NOT returns the inverse boolean value of it's argument. |
| UltraCalcFunctionNow | Returns a .NET DateTime ticks value of the current day and time |
| UltraCalcFunctionNPer | Calculates an investment's number of payment periods when the payment frequency, amount, and interest rate are held steady. |
| UltraCalcFunctionNPV | Calculates an investment's Net Present Value given it's expected rate or return and the cash flow represented as positive numeric values (income) and negative numeric values (payments). |
| UltraCalcFunctionNull | Returns a null value (Nothing in VB) |
| UltraCalcFunctionOct2Bin | Converts a string representing an octal number to a string representing the same number in the binary number system. |
| UltraCalcFunctionOct2Dec | Returns the decimal value of a string representation of a number in a octal system. |
| UltraCalcFunctionOct2Hex | Converts a string representing an octal number to a string representing the same number in the hexadecimal number system. |
| UltraCalcFunctionOdd | Rounds a positive number up and a negative number down to the nearest odd integer. |
| UltraCalcFunctionOr | Logical-OR returns the boolean value, TRUE, if at least one argument has a value of TRUE. When all arguments are FALSE, then this function returns FALSE. |
| UltraCalcFunctionPercent | '%' Percent formula operator (20%) |
| UltraCalcFunctionPi | Returns the mathematical constant for the Greek letter, pi. |
| UltraCalcFunctionPlus | '+' Addition formula operator (1+2) |
| UltraCalcFunctionPmt | Calculates what the payment amount should be on a loan at a fixed interest rate requiring a fixed number of payments. |
| UltraCalcFunctionPower | Raises the specific number to a power. |
| UltraCalcFunctionPPmt | Calculates the principal portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest. |
| UltraCalcFunctionProduct | Multiplies a series of numbers to return their total product. |
| UltraCalcFunctionPV | Calculates an investment's present value by discounting what a series of fixed future payments is worth at a specified interest rate. |
| UltraCalcFunctionQuotient | Performs integer division on two numbers disregarding any remainder. |
| UltraCalcFunctionRadians | Converts degrees to radians. |
| UltraCalcFunctionRand | Generates a pseudorandom number from zero up to (but not including) one. |
| UltraCalcFunctionRandBetween | Generates a pseudorandom integer between two specified numbers. |
| UltraCalcFunctionRate | Calculates the per-period interest rate for a series of cash flows (an annuity). |
| UltraCalcFunctionReplace | Replaces a substring of a text value with some new text. This substring is specified by giving it's starting point and it's length in characters, within the original text value. |
| UltraCalcFunctionRept | Repeats text a specific number of times. |
| UltraCalcFunctionRight | Gets the rightmost characters from a text value, up to the specified number of characters. |
| UltraCalcFunctionRoman | Converts a number into a roman number as a string. |
| UltraCalcFunctionRound | Rounds the fractional portion of a numeric value up or down to produce an integer. |
| UltraCalcFunctionRoundDown | Rounds a number to down to the specified number of digits. |
| UltraCalcFunctionRoundUp | Rounds a number to up to the specified number of digits. |
| UltraCalcFunctionSearch | Returns the 1-based index of one string within another, searching case insensitively. |
| UltraCalcFunctionSearchB | Returns the 1-based index of one string within another, searching case insensitively. |
| UltraCalcFunctionSecond | Returns the second of a time value |
| UltraCalcFunctionSeriesSum | Returns the sum of a power series. |
| UltraCalcFunctionSign | Returns the sign of a number. (-1, 0, or 1) |
| UltraCalcFunctionSin | Calculates the trigonometric sine of a specified angle (measured in radians). |
| UltraCalcFunctionSinh | Calculates the hyperbolic sine of a specified angle measured in radians. |
| UltraCalcFunctionSLN | Calculates what the straight-line depreciation of an asset should be per period. |
| UltraCalcFunctionSqrt | Calculates the square root of a number. |
| UltraCalcFunctionSqrtPi | Returns the square root of the specified number times Pi. |
| UltraCalcFunctionStdev | Calculates an approximate standard deviation of a specified sampling of numeric values. |
| UltraCalcFunctionSubtotal | Calculates the subtotal in one of more references. |
| UltraCalcFunctionSum | Adds a series of numbers to obtain a total amount. |
| UltraCalcFunctionSYD | Calculates depreciation of an asset using the sum of years' digits (SYD) calculation method. |
| UltraCalcFunctionTan | Calculates the trigonometric tangent of a specified angle (measured in radians). |
| UltraCalcFunctionTanh | Calculates the hyperbolic tangent of a specified angle measured in radians. |
| UltraCalcFunctionText | Converts the value to text based on the specified format. |
| UltraCalcFunctionTime | Returns the .NET DateTime ticks value that represents a particular time |
| UltraCalcFunctionTimeValue | Returns the .Net DateTime of the time represented by time formated in a string |
| UltraCalcFunctionToday | Gets the host's current date. |
| UltraCalcFunctionTrim | Removes any leading or trailing spaces from a text value, and normalizes runs of whitespace within a text value. |
| UltraCalcFunctionTrue | A constant function always returning the TRUE value of Boolean logic. |
| UltraCalcFunctionTrunc | Truncates the fractional portion of a numeric value to produce an integer. |
| UltraCalcFunctionType | Returns the underlying UltraCalc data type for the specified value. |
| UltraCalcFunctionUnaryMinus | '-' Negation formula operator (-20) |
| UltraCalcFunctionUnaryPlus | '+' Unary plus formula operator (+20) |
| UltraCalcFunctionUpper | Converts all lowercase letters in a text string to uppercase. |
| UltraCalcFunctionValue | Retrieves the numeric value of a piece of text that is supposed to represent either a number or a currency. |
| UltraCalcFunctionVar | Calculates the estimated variance for a specified sampling of numeric values. |
| UltraCalcFunctionWeekDay | Returns a number representing the day of the week of the specified date. |
| UltraCalcFunctionWeekNum | Returns the number of the week into which the specified date falls. |
| UltraCalcFunctionWorkDay | Returns a work day the specified number of days from the specified date, excluding any specified holidays. |
| UltraCalcFunctionXBase2Dec | Returns the decimal value of a string representation of a number in a non-decimal number system. |
| UltraCalcFunctionXBase2XBase | Converts a string representing a number in a non-decimal number system to a number in another non-decimal number system. |
| UltraCalcFunctionYear | Returns the year of a date value |
| UltraCalcNumberStack | Stack of UltraCalcValue instances used to evaluate formulas. |
| UltraCalcReferenceCollection | Manages a collection of IUltraCalcReference objects |
| UltraCalcUserDefinedFunction | Abstract base class used to extend fomula function table with user defined functions. |
| UltraCalcUserDefinedFunctionFactory | This class manages the list of user defined formula functions available in UltraCalc as well as methods to locate and instaniate function classes. |
