Version

Infragistics.WebUI.CalcEngine Namespace (Infragistics.WebUI.UltraWebCalcManager)

Classes
 ClassDescription
ClassBuiltInFunctionBase Base class for the built in functions.
ClassFormulaErrorBaseEventArgs  
ClassUCEventQueue Summary description for UCEventQueue.
ClassUCFunctionFactory This class manages the list of formula functions available in UltraCalc as well as methods to locate and instaniate function classes.
ClassUltraCalcBinaryOperatorBase Abstract base class for binary operator functions.
ClassUltraCalcFunction Base class for formula functions.
ClassUltraCalcFunctionAbs Calculates a number's absolute value.
ClassUltraCalcFunctionACos Returns the angle (measured in radians) having the specified value of the trigonometric cosine function.
ClassUltraCalcFunctionACosh Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function.
ClassUltraCalcFunctionAnd 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.
ClassUltraCalcFunctionASin Returns the angle (measured in radians) having the specified value of the trigonometric sine function.
ClassUltraCalcFunctionASinh Returns the angle (measured in radians) having the specified value of it's hyperbolic sine function.
ClassUltraCalcFunctionATan Calculates the normalized angle (measured in radians) which has the specified tangent function value.
ClassUltraCalcFunctionATan2 Calculates the angle made with the x-axis on a Cartesian coordinate plane by the specified (x, y) coordinates.
ClassUltraCalcFunctionATanh Calculates the hyperbolic tangent of a specified angle measured in radians.
ClassUltraCalcFunctionAveDev Returns the average deviation from the average of all numeric values.
ClassUltraCalcFunctionAverage Calculates an average (arithmetic mean) for a series of numbers.
ClassUltraCalcFunctionBin2Dec Returns the decimal value of a string representation of a number in a binary system.
ClassUltraCalcFunctionBin2Hex Converts a string representing a binary number to a string representing the same number in the hexadecimal number system.
ClassUltraCalcFunctionBin2Oct Converts a string representing a binary number to a string representing the same number in the octal number system.
ClassUltraCalcFunctionBinomDist Returns the individual term binomial distribution probability.
ClassUltraCalcFunctionCeiling Returns the smallest whole number greater than or equal to the given number
ClassUltraCalcFunctionChar Returns the character specified by the code number from the character set for your computer.
ClassUltraCalcFunctionChoose The CHOOSE function returns one of the values provided in its arguments based on the number in the first argument.
ClassUltraCalcFunctionCode Gives you the numeric code corresponding the the first character in a specific text string.
ClassUltraCalcFunctionCombin Returns the number of possible combinations given a set of items and a number of chosen items from that set.
ClassUltraCalcFunctionCombina Returns the number of possible combinations (with repetitions) given a set of items and a number of chosen items from that set.
ClassUltraCalcFunctionComplex Returns a complex number represented as a string in the format "x + yi" or "x + yj" by comining a real and imaginary number.
ClassUltraCalcFunctionConcat '&' formula operator used to concatenate two strings. ("First" & "Second")
ClassUltraCalcFunctionConcatenate Combines two or more text values into a single text string.
ClassUltraCalcFunctionConvert Converts a value from one system of measurement to another. For example, meters to inches or hours to seconds.
ClassUltraCalcFunctionCos Calculates the trigonometric cosine of a specified angle (measured in radians).
ClassUltraCalcFunctionCosh Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function.
ClassUltraCalcFunctionCount Counts how many cells have numeric or date/time values.
ClassUltraCalcFunctionCountA Counts how many cells are not blank.
ClassUltraCalcFunctionCritBinom Returns the the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
ClassUltraCalcFunctionDate Returns the .NET DateTime ticks number that represents a particular date
ClassUltraCalcFunctionDateAdd Returns a System.DateTime value resulting from adding a specified interval to a DateTime.
ClassUltraCalcFunctionDateDiff Returns a value specifying the number of time intervals between two DateTime values.
ClassUltraCalcFunctionDateValue Returns the .NET DateTime of the time represented by date formated in a string
ClassUltraCalcFunctionDay Returns the day of a date value
ClassUltraCalcFunctionDays360 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.
ClassUltraCalcFunctionDB Calculates an asset's depreciation using the fixed declining balance (DB) method over a specified term.
ClassUltraCalcFunctionDBNull Returns DBNull
ClassUltraCalcFunctionDDB Calculates an asset's depreciation using the double declining balance (DDB) or another weighted factor method over a specified term.
ClassUltraCalcFunctionDec2Bin Returns a string representing the specified decimal value as a binary number.
ClassUltraCalcFunctionDec2Hex Returns a string representing the specified decimal value as a hexadecimal number.
ClassUltraCalcFunctionDec2Oct Returns a string representing the specified decimal value as a octal number.
ClassUltraCalcFunctionDec2XBase Returns a string representing the specified decimal value in the specified base number scheme.
ClassUltraCalcFunctionDegrees Converts radians to degrees.
ClassUltraCalcFunctionDelta Compares two numbers and returns 1 if they are equal or 0 if they are not.
ClassUltraCalcFunctionDescriptor Describes a function table entry and provides methods to access information about the function's arguments.
ClassUltraCalcFunctionDivide '/' Division formula operator (3/2)
ClassUltraCalcFunctionDollarDe Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction.
ClassUltraCalcFunctionDollarFr Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction.
ClassUltraCalcFunctionEDate Returns a date that is the specified number of months before or after the start date.
ClassUltraCalcFunctionEOMonth Returns a date that is at the end of the month which is the specified number of months before or after the start date.
ClassUltraCalcFunctionEqual '=' Equality formula operator (Price = 200)
ClassUltraCalcFunctionErrorType When an error value is returned, the ERRORTYPE function returns a numeric value corresponding to the UltraCalcErrorCode enumeration.
ClassUltraCalcFunctionEven Rounds a positive number up and a negative number down to the nearest even integer.
ClassUltraCalcFunctionExp Calculates the mathematical constant, e, raised to the specified power.
ClassUltraCalcFunctionExpon "^" Exponentiation formula operator (3^2)
ClassUltraCalcFunctionFact Returns the factorial of a number.
ClassUltraCalcFunctionFactDouble Returns the double factorial of a number.
ClassUltraCalcFunctionFactory Class used to manage the stock and user defined UltraCalcFunction instances
ClassUltraCalcFunctionFalse A constant function always returning the FALSE value of Boolean logic.
ClassUltraCalcFunctionFind Finds one piece of text within another piece of text.
ClassUltraCalcFunctionFixed Formats a numeric value rounded to a specified number of decimal places and with optional thousands separators.
ClassUltraCalcFunctionFloor Calculates the next lesser whole number for a specified numeric value.
ClassUltraCalcFunctionFV Calculates the future value of an annuity having fixed payments and assuming a fixed interest rate or rate of return.
ClassUltraCalcFunctionGcd Returns the greatest common divisor of integer values.
ClassUltraCalcFunctionGE ">=" Greater than or equal formula operator (Price >= 200)
ClassUltraCalcFunctionGeStep Compares two numbers and returns 1 the first number is greater than or equal to the second or returns 0 if not.
ClassUltraCalcFunctionGT ">" Greater than formula operator (Price > 200)
ClassUltraCalcFunctionHex2Bin Converts a string representing an hexadecimal number to a string representing the same number in the binary number system.
ClassUltraCalcFunctionHex2Dec Returns the decimal value of a string representation of a number in a hexadecimal system.
ClassUltraCalcFunctionHex2Oct Converts a string representing an hexadecimal number to a string representing the same number in the octal number system.
ClassUltraCalcFunctionHour Returns the hour of a time value
ClassUltraCalcFunctionIf 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.
ClassUltraCalcFunctionIfError Returns one of two values depending on whether or not the first value is an error or not.
ClassUltraCalcFunctionImAbs Returns the absolute value of a complex number.
ClassUltraCalcFunctionImaginary Returns the imaginary coefficient of a complex number.
ClassUltraCalcFunctionImArgument Returns the argument theta, and angle expressed in radians.
ClassUltraCalcFunctionImConjugate Returns the conjugate of a complex number.
ClassUltraCalcFunctionImCos Returns the cosine of a complex number.
ClassUltraCalcFunctionImDiv Returns the quotient of two complex numbers.
ClassUltraCalcFunctionImExp Returns the exponential of a complex number.
ClassUltraCalcFunctionImLn Returns the natural logarithm of a complex number.
ClassUltraCalcFunctionImLog10 Returns the base-10 logarithm of a complex number.
ClassUltraCalcFunctionImLog2 Returns the base-2 logarithm of a complex number.
ClassUltraCalcFunctionImPower Returns the complex number raised to the specified power.
ClassUltraCalcFunctionImProduct Returns the product of 1 to n complex numbers.
ClassUltraCalcFunctionImReal Returns the real coefficient of a complex number.
ClassUltraCalcFunctionImSin Returns the sine of a complex number.
ClassUltraCalcFunctionImSqrt Returns the square root of a complex number.
ClassUltraCalcFunctionImSub Returns the difference between two complex numbers.
ClassUltraCalcFunctionImSum Returns the sum of 1 to n complex numbers.
ClassUltraCalcFunctionInfo Returns information about the current operating environment.
ClassUltraCalcFunctionInt Converts a real numeric value (which may have a fractional part) into a whole number.
ClassUltraCalcFunctionIntRate Calculates the interest rate yielded by a security investment redeemable at a future date, such as a zero coupon bond.
ClassUltraCalcFunctionIPmt Calculates the interest portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest.
ClassUltraCalcFunctionIRR Calculates an internal rate of return for a given series of cash flows represented by either positive (incoming) or negative (outgoing) numeric values.
ClassUltraCalcFunctionIsBlank Returns TRUE if the specified value is blank.
ClassUltraCalcFunctionIsDBNull Returns a boolean indicating if the value is DBNull.
ClassUltraCalcFunctionIsErr Returns TRUE if the specified value is any error value, except #N/A!
ClassUltraCalcFunctionIsError Returns TRUE if the specified value is any error value without exception.
ClassUltraCalcFunctionIsEven Returns TRUE if the specified value is an even number.
ClassUltraCalcFunctionIsLogical Returns TRUE if the specified value refers to a two-state logic or Boolean value.
ClassUltraCalcFunctionIsNa Returns TRUE if an error value is #N/A (not applicable.)
ClassUltraCalcFunctionIsNonText Returns TRUE if the specified value refers to any not-text value.
ClassUltraCalcFunctionIsNull Returns a boolean indicating if the value is null (Nothing in VB).
ClassUltraCalcFunctionIsNumber Returns TRUE if the specified value refers to a numeric value.
ClassUltraCalcFunctionIsOdd Returns TRUE if the specified value is an odd number.
ClassUltraCalcFunctionIsRef Returns TRUE if the specified value is an UltraCalc reference.
ClassUltraCalcFunctionIsText Returns TRUE if the specified value refers to a text (or string) value.
ClassUltraCalcFunctionLcm Returns the least common multiple of integer values.
ClassUltraCalcFunctionLE "<=" Less than or equal formula operator (Price <= 200)
ClassUltraCalcFunctionLeft Gets the leftmost characters from a text value, up to the specified number of characters.
ClassUltraCalcFunctionLen Counts the number of characters in a text value.
ClassUltraCalcFunctionLn Calculates the natural logarithm of a specified numeric value.
ClassUltraCalcFunctionLog Calculates a logarithm for a specified numeric value to the specified base.
ClassUltraCalcFunctionLog10 Calculates the logarithm (base 10) of a specified numeric value.
ClassUltraCalcFunctionLower Converts a text value to all lowercase letters.
ClassUltraCalcFunctionLT '<' Less than formula operator (Price < 200)
ClassUltraCalcFunctionMax Gives you the largest numeric value out of a series.
ClassUltraCalcFunctionMedian Calculates the median value of a specified list of numeric values.
ClassUltraCalcFunctionMid Gets a specified number of characters from the middle of a text string, starting from a specified position in that string.
ClassUltraCalcFunctionMin Gives you the smallest numeric value out of a series.
ClassUltraCalcFunctionMinus '-' Subtraction formula operator (3-2)
ClassUltraCalcFunctionMinute Returns the minute of a time value
ClassUltraCalcFunctionMod Gets the remainder following integer division of two numbers.
ClassUltraCalcFunctionMonth Returns the month of a date value
ClassUltraCalcFunctionMRound Rounds a number to the nearest multiple of another number.
ClassUltraCalcFunctionMultinomial Returns the multinomial of a set of numbers.
ClassUltraCalcFunctionMultiply '*' Multiplication formula operator (2*3)
ClassUltraCalcFunctionN Converts a value to a number.
ClassUltraCalcFunctionNa Returns #N/A!, the error value representing a not applicable result.
ClassUltraCalcFunctionNE "<>" Inequality formula operator (Price <> 200)
ClassUltraCalcFunctionNetWorkDays Returns the total number of whole work days between the specified dates, excluding any specified holidays.
ClassUltraCalcFunctionNot Logical-NOT returns the inverse boolean value of it's argument.
ClassUltraCalcFunctionNow Returns a .NET DateTime ticks value of the current day and time
ClassUltraCalcFunctionNPer Calculates an investment's number of payment periods when the payment frequency, amount, and interest rate are held steady.
ClassUltraCalcFunctionNPV 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).
ClassUltraCalcFunctionNull Returns a null value (Nothing in VB)
ClassUltraCalcFunctionOct2Bin Converts a string representing an octal number to a string representing the same number in the binary number system.
ClassUltraCalcFunctionOct2Dec Returns the decimal value of a string representation of a number in a octal system.
ClassUltraCalcFunctionOct2Hex Converts a string representing an octal number to a string representing the same number in the hexadecimal number system.
ClassUltraCalcFunctionOdd Rounds a positive number up and a negative number down to the nearest odd integer.
ClassUltraCalcFunctionOr 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.
ClassUltraCalcFunctionPercent '%' Percent formula operator (20%)
ClassUltraCalcFunctionPi Returns the mathematical constant for the Greek letter, pi.
ClassUltraCalcFunctionPlus '+' Addition formula operator (1+2)
ClassUltraCalcFunctionPmt Calculates what the payment amount should be on a loan at a fixed interest rate requiring a fixed number of payments.
ClassUltraCalcFunctionPower Raises the specific number to a power.
ClassUltraCalcFunctionPPmt Calculates the principal portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest.
ClassUltraCalcFunctionProduct Multiplies a series of numbers to return their total product.
ClassUltraCalcFunctionPV Calculates an investment's present value by discounting what a series of fixed future payments is worth at a specified interest rate.
ClassUltraCalcFunctionQuotient Performs integer division on two numbers disregarding any remainder.
ClassUltraCalcFunctionRadians Converts degrees to radians.
ClassUltraCalcFunctionRand Generates a pseudorandom number from zero up to (but not including) one.
ClassUltraCalcFunctionRandBetween Generates a pseudorandom integer between two specified numbers.
ClassUltraCalcFunctionRate Calculates the per-period interest rate for a series of cash flows (an annuity).
ClassUltraCalcFunctionReplace 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.
ClassUltraCalcFunctionRept Repeats text a specific number of times.
ClassUltraCalcFunctionRight Gets the rightmost characters from a text value, up to the specified number of characters.
ClassUltraCalcFunctionRoman Converts a number into a roman number as a string.
ClassUltraCalcFunctionRound Rounds the fractional portion of a numeric value up or down to produce an integer.
ClassUltraCalcFunctionRoundDown Rounds a number to down to the specified number of digits.
ClassUltraCalcFunctionRoundUp Rounds a number to up to the specified number of digits.
ClassUltraCalcFunctionSearch Returns the 1-based index of one string within another, searching case insensitively.
ClassUltraCalcFunctionSearchB Returns the 1-based index of one string within another, searching case insensitively.
ClassUltraCalcFunctionSecond Returns the second of a time value
ClassUltraCalcFunctionSeriesSum Returns the sum of a power series.
ClassUltraCalcFunctionSign Returns the sign of a number. (-1, 0, or 1)
ClassUltraCalcFunctionSin Calculates the trigonometric sine of a specified angle (measured in radians).
ClassUltraCalcFunctionSinh Calculates the hyperbolic sine of a specified angle measured in radians.
ClassUltraCalcFunctionSLN Calculates what the straight-line depreciation of an asset should be per period.
ClassUltraCalcFunctionSqrt Calculates the square root of a number.
ClassUltraCalcFunctionSqrtPi Returns the square root of the specified number times Pi.
ClassUltraCalcFunctionStdev Calculates an approximate standard deviation of a specified sampling of numeric values.
ClassUltraCalcFunctionSubtotal Calculates the subtotal in one of more references.
ClassUltraCalcFunctionSum Adds a series of numbers to obtain a total amount.
ClassUltraCalcFunctionSYD Calculates depreciation of an asset using the sum of years' digits (SYD) calculation method.
ClassUltraCalcFunctionTan Calculates the trigonometric tangent of a specified angle (measured in radians).
ClassUltraCalcFunctionTanh Calculates the hyperbolic tangent of a specified angle measured in radians.
ClassUltraCalcFunctionText Converts the value to text based on the specified format.
ClassUltraCalcFunctionTime Returns the .NET DateTime ticks value that represents a particular time
ClassUltraCalcFunctionTimeValue Returns the .Net DateTime of the time represented by time formated in a string
ClassUltraCalcFunctionToday Gets the host's current date.
ClassUltraCalcFunctionTrim Removes any leading or trailing spaces from a text value, and normalizes runs of whitespace within a text value.
ClassUltraCalcFunctionTrue A constant function always returning the TRUE value of Boolean logic.
ClassUltraCalcFunctionTrunc Truncates the fractional portion of a numeric value to produce an integer.
ClassUltraCalcFunctionType Returns the underlying UltraCalc data type for the specified value.
ClassUltraCalcFunctionUnaryMinus '-' Negation formula operator (-20)
ClassUltraCalcFunctionUnaryPlus '+' Unary plus formula operator (+20)
ClassUltraCalcFunctionUpper Converts all lowercase letters in a text string to uppercase.
ClassUltraCalcFunctionValue Retrieves the numeric value of a piece of text that is supposed to represent either a number or a currency.
ClassUltraCalcFunctionVar Calculates the estimated variance for a specified sampling of numeric values.
ClassUltraCalcFunctionWeekDay Returns a number representing the day of the week of the specified date.
ClassUltraCalcFunctionWeekNum Returns the number of the week into which the specified date falls.
ClassUltraCalcFunctionWorkDay Returns a work day the specified number of days from the specified date, excluding any specified holidays.
ClassUltraCalcFunctionXBase2Dec Returns the decimal value of a string representation of a number in a non-decimal number system.
ClassUltraCalcFunctionXBase2XBase Converts a string representing a number in a non-decimal number system to a number in another non-decimal number system.
ClassUltraCalcFunctionYear Returns the year of a date value
ClassUltraCalcNumberStack Stack of UltraCalcValue instances used to evaluate formulas.
ClassUltraCalcReferenceCollection Manages a collection of IUltraCalcReference objects
ClassUltraCalcUserDefinedFunction Abstract base class used to extend fomula function table with user defined functions.
ClassUltraCalcUserDefinedFunctionFactory This class manages the list of user defined formula functions available in UltraCalc as well as methods to locate and instaniate function classes.
See Also