Class GridFormulaEngine

Encapsulates the code required to parse and compute formulas. Hashtable properties maintain a Formula Library of functions as well as a list of dependent cells.

You can add and remove library functions.

Inheritance
System.Object
NonFinalizeDisposable
Disposable
GridFormulaEngine
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.Windows.Controls.Grid
Assembly: Syncfusion.Grid.Wpf.dll
Syntax
public class GridFormulaEngine : Disposable, IDisposable

Constructors

GridFormulaEngine(GridModel)

Constructor.

Declaration
public GridFormulaEngine(GridModel gridModel)
Parameters
Type Name Description
GridModel gridModel

The GridModel from the underlying grid.

Fields

ACC

Declaration
public double ACC
Field Value
Type Description
System.Double

BIGNI

Declaration
public double BIGNI
Field Value
Type Description
System.Double

BIGNO

Declaration
public double BIGNO
Field Value
Type Description
System.Double

cell

Declaration
public string cell
Field Value
Type Description
System.String

FormulaErrorStrings

String array that holds the strings used in error messages within the Formula Engine.

Declaration
public string[] FormulaErrorStrings
Field Value
Type Description
System.String[]
Remarks

If you want to change the error messages displayed within the Formula Engine, you can set the new strings into the appropriate position in the FormulaErrorStrings array. You should assign your new strings to the corresponding positions.

Examples

Here is the code that shows position of each string in FormulaErrorStrings:

	public string[] FormulaErrorStrings = new string[]
	{
		"binary operators cannot start an expression",	//0
		"cannot parse",									//1
		"bad library",									//2
		"invalid char in front of",						//3
		"number contains 2 decimal points",				//4
		"expression cannot end with an operator",		//5
		"invalid characters following an operator",		//6
		"invalid character in number",					//7
		"mismatched parentheses",						//8
		"unknown formula name",							//9
		"requires a single argument",					//10
		"requires 3 arguments",							//11
		"invalid Math argument",						//12
		"requires 2 arguments",							//13
		"bad index",									//14
		"too complex",									//15
		"circular reference: ",							//16
		"missing formula",								//17
		"improper formula",								//18
		"invalid expression",							//19
		"cell empty",									//20
		"bad formula",									//21
		"empty expression",								//22
		"Virtual Mode required - set UsesVirtualDataSource", //23
		"mismatched string quotes",                     //24
		"wrong number of arguments",                    //25
		"invalid arguments",							//26
		"iterations do not converge",                   //27
		"Control named '{0}' is already registered",    //28
        "Calculation overflow",							//29
        "missing operand"							    //30
	};

machineepsilon

Declaration
public const double machineepsilon = 5E-16
Field Value
Type Description
System.Double

maxrealnumber

Declaration
public const double maxrealnumber = 1E+300
Field Value
Type Description
System.Double

minrealnumber

Declaration
public const double minrealnumber = 1E-300
Field Value
Type Description
System.Double

ParseArgumentSeparator

Character recognized by the parsing code as the delimiter for arguments in a named formula's argument list.

Declaration
[ThreadStatic]
public static char ParseArgumentSeparator
Field Value
Type Description
System.Char

ParseDecimalSeparator

Character recognized by the parsing engine as decimal separator for numbers.

Declaration
[ThreadStatic]
public static char ParseDecimalSeparator
Field Value
Type Description
System.Char

Treat1900AsLeapYear

Specifies if 1900 should be treated as Leap Year (Excel Compatibility)

Declaration
public static bool Treat1900AsLeapYear
Field Value
Type Description
System.Boolean

ValidSheetChars

Declaration
[ThreadStatic]
public static string ValidSheetChars
Field Value
Type Description
System.String

Properties

ActiveFunctionName

Returns the function name of the active function call. Empty if not in a call.

Declaration
public string ActiveFunctionName { get; }
Property Value
Type Description
System.String

AllowShortCircuitIFs

Gets or sets whether IF function calculations should specifically avoid computing the non-used alternative.

Declaration
public bool AllowShortCircuitIFs { get; set; }
Property Value
Type Description
System.Boolean
Remarks

The default value is false for code legacy consistency. When AllowShortCircuitIFs
is set true, only the necessary alternative of an IF function is computed. To support this behavior, a change in how nested IF function calculations are done is necessary. The default way of calculating nested functions is inside-out, with the inner most functions being computed to a value before the next outer function is evaluated. To support short circuiting IF functions, nested IF functions need to be computed from the outside-in to know what alternative needs to be evaluated. This outside-in calculation pattern only applies to IF functions, and only when AllowShortCircuitIFs is true.

CalculatingSuspended

Indicates whether formulas are immediately calculated as dependent cells are changed.

Declaration
public bool CalculatingSuspended { get; set; }
Property Value
Type Description
System.Boolean
Remarks

Use this property to suspend calculations while a series of changes are made to dependent cells either by the user or programmatically. When the changes are complete, set this property to False, and then call Engine.RecalculateRange to recalculate the affected range. See the sample in GridCellFormulaModel.CalculatingSuspended.

CloneableFormulaTags

Gets / sets whether FormulaTags are cloned when setting one FormulaTag object equal to another.

Declaration
public static bool CloneableFormulaTags { get; set; }
Property Value
Type Description
System.Boolean
Remarks

This is by default set to False as normally the FormulaEngine expects to be working with referenced objects, and not clones of referenced objects.

CurrentRowNotationEnabled

Enables / disables using row = 0 in formulas to represent the current row.

Declaration
public bool CurrentRowNotationEnabled { get; set; }
Property Value
Type Description
System.Boolean
Remarks

When this property is set True, entering zero as a row in a formula is interpreted to be the current row. Using the current row notation allows you to sort a column in the grid and maintain the relative formula. After sorting, you do have to call engine.RecalculateRange to allow the relative formulas to reset themselves.

DependentCells

Contains a mapping between a cell and a list of formula cells that depend on it.

Declaration
public Hashtable DependentCells { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

The key is the given cell, and the value is a Hashtable of cells containing formulas that reference this cell.

Examples

Here is code that will list formula cells affected by changing the given cell.

public void DisplayAllAffectedCells()
{

	GridFormulaEngine engine = ((GridCellFormulaModel)this.gridControl1.Model.CellModels["FormulaCell"]).Engine;

	foreach(object o in engine.DependentCells.Keys)
	{
		string s1 = o as string;
		Console.Write(s1 + " affects ");
		Hashtable ht = (Hashtable) engine.DependentCells[s1];
		foreach(object o1 in ht.Keys)
		{
			string s2 = o1 as string;
			Console.Write(s2 + " ");
		}
		Console.WriteLine("");
	}
}
	Public Sub DisplayAllAffectedCells()
		Dim engine As GridFormulaEngine = CType(Me.gridControl1.Model.CellModels("FormulaCell"), GridCellFormulaModel).Engine
		Dim o As Object
		For Each o In  engine.DependentCells.Keys
			Dim s1 As String = CStr(o)
			Console.Write((s1 + " affects "))
			Dim ht As Hashtable = CType(engine.DependentCells(s1), Hashtable)
			Dim o1 As Object
			For Each o1 In  ht.Keys
				Dim s2 As String = CStr(o1)
				Console.Write((s2 + " "))
			Next o1
			Console.WriteLine("")
		Next o
	End Sub 'DisplayAllAffectedCells

DependentFormulaCells

Contains a mapping between a formula cell and a list of cells upon which it depends.

Declaration
public Hashtable DependentFormulaCells { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

The key is the given formula cell, and the value is a Hashtable of cells that this formula cell references.

Examples

Here is code that lists formula cells affected by changing a given cell:

	public void DisplayAllFormulaDependencies()
	{
		GridFormulaEngine engine = ((GridCellFormulaModel)this.gridControl1.Model.CellModels["FormulaCell"]).Engine;

		foreach(object o in engine.DependentFormulaCells.Keys)
		{
			string s1 = o as string;
			Console.Write(s1 + " depends upon ");
			Hashtable ht = (Hashtable) engine.DependentFormulaCells[s1];
			foreach(object o1 in ht.Keys)
			{
				string s2 = o1 as string;
				Console.Write(s2 + " ");
			}
			Console.WriteLine("");
		}
	}
	Public Sub DisplayAllFormulaDependencies()
		Dim engine As GridFormulaEngine = CType(Me.gridControl1.CellModels("FormulaCell"), GridCellFormulaModel).Engine

		Dim o As Object
		For Each o In  engine.DependentFormulaCells.Keys
			Dim s1 As String = CStr(o)
			Console.Write((s1 + " depends upon "))
			Dim ht As Hashtable = CType(engine.DependentFormulaCells(s1), Hashtable)
			Dim o1 As Object
			For Each o1 In  ht.Keys
				Dim s2 As String = CStr(o1) 
				Console.Write((s2 + " "))
			Next o1
			Console.WriteLine("")
		Next o
	End Sub 'DisplayAllFormulaDependencies

DependentNamedRangeCells

Holds hashtables containing cells that depend upon namedranges.

Declaration
public Hashtable DependentNamedRangeCells { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

The key properties in DependentNamedRangeCells are namedranges. The value properties are hashtables.

DoCircularCheckInValidating

Gets or sets whether circular references should be checked in the CurrentCell.Validating event.

Declaration
public bool DoCircularCheckInValidating { get; set; }
Property Value
Type Description
System.Boolean

EnsureIFCallDuringShortCircuit

Gets or sets whether the IF function implementation is called when AllowShortCircuitIFs is true. The default behavior is to not call the IF Function code in the library, but instead, work directly with the IF clauses.

Declaration
public bool EnsureIFCallDuringShortCircuit { get; set; }
Property Value
Type Description
System.Boolean

ErrorStrings

Declaration
public ArrayList ErrorStrings { get; set; }
Property Value
Type Description
System.Collections.ArrayList

FixedReferenceOnlyOnPaste

Determines whether fixed references should be adjusted on other than paste.

Declaration
public bool FixedReferenceOnlyOnPaste { get; set; }
Property Value
Type Description
System.Boolean

ForceParsingOfLibraryFunctionArguments

Gets or sets whether all function arguments are parsed using GridFormulaEngine.Parse.

Declaration
public bool ForceParsingOfLibraryFunctionArguments { get; set; }
Property Value
Type Description
System.Boolean
Remarks

If you are using NamedRanges or CurrentRowNotationEnabled inside function arguments, you should set this property to true to make sure the proper substitutions are done on the arguments.

FormulaContextCell

Gets or sets the cell (in the column-row notation of A1 or E21) whose formula is being parsed or computed.

Declaration
public string FormulaContextCell { get; set; }
Property Value
Type Description
System.String
Remarks

This property should be set only if you are directly parsing and computing formulas by calling the Parse or ComputedValue methods. In this case, you should set the property before calling either method. FormulaContextCell is used to provide support for CurrentRowNotation, circular calculation checks, and reference updating.

FunctionEngineContext

Gets the formula engine that holds the proper state information for LibraryFunction call.

Declaration
public static GridFormulaEngine FunctionEngineContext { get; }
Property Value
Type Description
GridFormulaEngine
Remarks

If you are adding your own custom library functions and need to access GridFormulaEngine members like GetCellsFromArgs or GetValueFromArg from your code, then you should use this static property to retrieve the proper GridFormulaEngine object. This only matters if you are using multiple grids that you have registered using RegisterGridAsSheet, and are adding your own custom formulas. Note that GridFormulaEngine.FunctionEngineContext is only defined within the scope of a library function call, and will be null at all other times.

Examples

Use GridFormulaEngine.FunctionEngineContext to retrieve the engine when writing custom functions.

public string ComputeSumPosNums(string args)
{
	GridFormulaEngine engine = GridFormulaEngine.FunctionEngineContext;
	string sum = "";
	foreach(string r in args.Split(new char[]{','}))
	{
		if(r.IndexOf(':') > -1) //is a cellrange
		{
			foreach(string s in engine.GetCellsFromArgs(r))
			{
				var s1 = engine.GetValueFromArg(s).Replace("'","");
				//... do some calculations to compute sum
			}
		}
	}	
	return sum.ToString();
}
Public Function ComputeSumPosNums(args As String) As String
   Dim engine As GridFormulaEngine = GridFormulaEngine.FunctionEngineContext
   Dim sum As String = ""
   Dim r As String
   For Each r In  args.Split(New Char() {","c})
		If r.IndexOf(":"c) > - 1 Then 'is a cellrange
			Dim s As String
			For Each s In  engine.GetCellsFromArgs(r)
				var s1 = engine.GetValueFromArg(s).Replace("'", "")
				'... do some calculations to compute sum
			Next s 
		End If
   Next r
   Return sum.ToString()
End Function 'ComputeSumPosNums

LibraryFunctions

Contains the current library functions.

Declaration
public Hashtable LibraryFunctions { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

This field gives you direct access to all Library Functions. The function name serves as the hash key, and the function delegate serves as the hash value.

MaximumCircularChecks

Gets / sets the number of recursive checks done for circular references.

Declaration
public int MaximumCircularChecks { get; set; }
Property Value
Type Description
System.Int32
Remarks

When you edit a cell, the engine parsing will attempt to flag circular references as an error. This value sets the number of dependent cells it will check before assuming there is no circular reference. Checking every reference can be time consuming depending upon the formulas being used. This property lets you decide how many recursions the engine will allow when looking for circular references. The default value is -1 meaning no checks are done as you type formula into the cell. Setting this property to int.MaxValue will make the engine check all dependent cells for a circular reference.

MaximumRecursiveCalls

Specifies the maximum number of recursive calls that can be used to compute a cellvalue.

Declaration
public int MaximumRecursiveCalls { get; set; }
Property Value
Type Description
System.Int32
Remarks

This property comes into play when you have a calculated formula cell that depends on
another calculated formula that depends on another calculated formula and so on. If the 'depends on another formula' number exceeds MaximumRecursiveCalls, you will see a Too Complex message displayed in the cell. The default value is 100, but you can set it higher or lower depending upon your expected needs. The purpose of the limit is to avoid a circular reference locking up your application.

MaximumStackDepth

Depth of the engine's calculation stack.

Declaration
public int MaximumStackDepth { get; set; }
Property Value
Type Description
System.Int32
Remarks

It is unlikely that you will need to adjust this value, as its default value of 100 is quite large. Any time a formula is to be computed, a Stack object is created with this number of elements to hold temporary calculations as the formula is being computed. For example, this formula: 1+1+1+...+1 requires a stack depth of 2 as there are only 2 temporary values needed as the formula is evaluated. However, this formula: 1+(1+(1+(1+1))) requires a depth of 5, as the five 1's are pushed onto the stack before the first addition (the right-most one) is performed.

Model

Declaration
public GridModel Model { get; }
Property Value
Type Description
GridModel

NamedRanges

Gets the named range Hashtable.

Declaration
public Hashtable NamedRanges { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

The key is the uppercase name and the value is the range for this name.

NamedRangesOriginalNames

Gets the named range Hashtable that holds the original case name as the value.

Declaration
public Hashtable NamedRangesOriginalNames { get; }
Property Value
Type Description
System.Collections.Hashtable
Remarks

The key is the uppercase name and the value is the original name.

NamedRangesSized

Holds namedranges in order of string length.

Declaration
protected ArrayList NamedRangesSized { get; }
Property Value
Type Description
System.Collections.ArrayList

SupportBlanksInSheetNames

Gets or sets whether blanks are treated as significant in sheet names.

Declaration
public bool SupportBlanksInSheetNames { get; set; }
Property Value
Type Description
System.Boolean
Remarks

Earlier versions of GridFormulaEngine did not support the use of blanks in sheet names. (They were treated as insignificant.) The current version does treat blanks as significant. If you want to revert to the prior treatment of blanks in sheet names, then set this property to false.

SuspendRefresh

Gets or sets whether to suspend recalculation from occurring more than once on RecalculateRange call or any cell value change for better performance. Default value is false.

Declaration
public bool SuspendRefresh { get; set; }
Property Value
Type Description
System.Boolean

UseCommonLibrary

Gets or sets whether you want all grids to share the same collection of library functions.

Declaration
public static bool UseCommonLibrary { get; set; }
Property Value
Type Description
System.Boolean

UseDatesInCalculations

Gets or sets whether dates can be used as operands in calculations. The default value is false.

Declaration
public bool UseDatesInCalculations { get; set; }
Property Value
Type Description
System.Boolean

UseNoAmpersandQuotes

Gets or sets whether strings concatenated using the ampersand operator should be returned inside double quote marks.

Declaration
public bool UseNoAmpersandQuotes { get; set; }
Property Value
Type Description
System.Boolean

UsesVirtualDataSource

Indicates whether the underlying data is virtually bound to the grid.

Declaration
public bool UsesVirtualDataSource { get; set; }
Property Value
Type Description
System.Boolean
Remarks

If the formula engine knows the data is stored within a GridControl.Data object, it can optimize data access. If the grid is being populated through virtual techniques (handling QueryCellInfo), the formula engine has to get the data through that means. The default value is to assume the data is coming from a virtual datasource. There are some other situations, like formulas in headers or frozen cells, when this property should be set to True.

WeekEndType

Declaration
public ArrayList WeekEndType { get; }
Property Value
Type Description
System.Collections.ArrayList

Methods

AddFunction(String, GridFormulaEngine.LibraryFunction)

Adds a function to the Function Library.

Declaration
public bool AddFunction(string name, GridFormulaEngine.LibraryFunction func)
Parameters
Type Name Description
System.String name

The name of the function to be added.
GridFormulaEngine.LibraryFunction func

The function to be added.
Returns
Type Description
System.Boolean

True if successfully removed, False otherwise.
Remarks

LibraryFunction is a delegate the defines the signature of functions that you can add to the Function Library.

public delegate string LibraryFunction(string args);

AddNamedRange(String, String, String)

Adds a named range to the namedranges collection.

Declaration
public bool AddNamedRange(string name, string range, string scope)
Parameters
Type Name Description
System.String name

The name of the range to be added.
System.String range

The range to be added.
System.String scope
Returns
Type Description
System.Boolean

True if successfully added, False otherwise.
Remarks

The range should be a string such as A4:C8.

AdjustNameRangesForSize()

Orders a namedrange collection according to string length.

Declaration
public void AdjustNameRangesForSize()
Remarks

The GridFormulaEngine needs an ordered list of named ranges to be able to properly parse named ranges. If you manually add named ranges to namedranges, then you should call this method afterwards.

AdjustRangeArg(ref String)

Accepts a possible parsed formula and returns the calculated value without quotes.

Declaration
public void AdjustRangeArg(ref string range)
Parameters
Type Name Description
System.String range

The argument to be adjusted.
Remarks

This method is useful in custom functions if you want to allow your custom functions to handle parsed formulas as arguments. In this case, calling this method at the beginning of your custom function will allow you custom function to work only with computed values, and not have to handle parsed formulas directly.

AdjustReferences(String, Int32, Int32)

Helper method for adjusting formulas.

Declaration
public string AdjustReferences(string origText, int rowOffset, int colOffset)
Parameters
Type Name Description
System.String origText

Valid unparsed formula string.
System.Int32 rowOffset

Row offset adjusmtent to be made to the origText.
System.Int32 colOffset

Column offset adjustment to be made to the origText
Returns
Type Description
System.String

Unparsed formula string derived from origText by adjusting the row and column references.
Remarks

For example, calling AdjustReferences("=A4+C4", 2, 1) returns the string "=B6+D6". This is a helper method that is used to adjust formula references for inserted and deleted rows and columns. Normally, you would not need this method unless you are managing formulas outside the GridControl as in a virtual GridControl or a GridDataBoundGrid. This AdjustReferences implementation does not support updating references with sheet names within the formulas.

AdjustReferences(String, Int32, Int32, String, String)

Helper method for adjusting formulas.

Declaration
public string AdjustReferences(string origText, int rowOffset, int colOffset, string sheetNameWhereCopied, string currentSheetName)
Parameters
Type Name Description
System.String origText

Valid unparsed formula string.
System.Int32 rowOffset

Row offset adjusmtent to be made to the origText.
System.Int32 colOffset

Column offset adjustment to be made to the origText
System.String sheetNameWhereCopied

The name of the sheet where the copy took place.
System.String currentSheetName

The name of the sheet where the cell holding origText is located.
Returns
Type Description
System.String

Unparsed formula string derived from origText by adjusting the row and column references.
Remarks

This AdjustReferences implementation does support updating references with sheet names within the formulas.

BaseToBase(String, Int32, Int32)

Declaration
public string BaseToBase(string argList, int from, int to)
Parameters
Type Name Description
System.String argList
System.Int32 from
System.Int32 to
Returns
Type Description
System.String

besseli0(Double)

Declaration
public static double besseli0(double x)
Parameters
Type Name Description
System.Double x
Returns
Type Description
System.Double

BitAnd(String)

Declaration
public string BitAnd(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

BitLShift(String)

Computes the Bit Left Shift of the given number.

Declaration
public string BitLShift(string argList)
Parameters
Type Name Description
System.String argList

Input Numbersfor which the OR operations has to be performed.
Returns
Type Description
System.String

Bit Left Shift value of the given number.

BitRShift(String)

Computes the Bit Right Shift of the given number.

Declaration
public string BitRShift(string argList)
Parameters
Type Name Description
System.String argList

Input Numbersfor which the Bit Right Shift operations has to be performed.
Returns
Type Description
System.String

Bit Right Shift value of the given number.

BitXor(String)

Computes the Bit XoR of the given two numbers.

Declaration
public string BitXor(string argList)
Parameters
Type Name Description
System.String argList

Input Numbersfor which the OR operations has to be performed.
Returns
Type Description
System.String

Bit OR value of the given two numbers.

ChangeGridSheetName(String, String, GridModel)

Changes a sheetname that was previously registered using RegisterGridAsSheet(String, GridModel, Int32). This method iterates through all the cells in all the sheets in the sheet family, swapping all occurrences of the oldName in any formula with the newName.

Declaration
public static bool ChangeGridSheetName(string oldName, string newName, GridModel grid)
Parameters
Type Name Description
System.String oldName

The old sheet name.
System.String newName

The new sheet name.
GridModel grid

The grid model.
Returns
Type Description
System.Boolean

True if the sheet was successfully renamed. If false returns, check whether the sheet family already contains the new name.

ChangeName(String, String, GridModel)

Declaration
public static void ChangeName(string oldName, string newName, GridModel grid)
Parameters
Type Name Description
System.String oldName
System.String newName
GridModel grid

ColIndex(String)

Returns a column index from a cell reference.

Declaration
public int ColIndex(string s)
Parameters
Type Name Description
System.String s

String holding a cell reference such as C21 or AB11.
Returns
Type Description
System.Int32

An integer with the corresponding column number.

Combinations(Int32, Int32)

Returns the number of possible combinations of k objects from a set of n object. The order of the chosen objects does not matter.

Declaration
public static double Combinations(int n, int k)
Parameters
Type Name Description
System.Int32 n

Number of objects
System.Int32 k

Number of objects chosen
Returns
Type Description
System.Double

ComputeAbs(String)

Computes the absolute value of the argument.

Declaration
public string ComputeAbs(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the absolute value of the argument.

ComputeAcos(String)

Computes angle whose cosine is the argument.

Declaration
public string ComputeAcos(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding angle whose cosine is the argument.

ComputeAcosh(String)

The inverse of Cosh.

Declaration
public string ComputeAcosh(string args)
Parameters
Type Name Description
System.String args

Value >= 1.
Returns
Type Description
System.String

ACosh(value).

ComputeAcot(String)

Declaration
public string ComputeAcot(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeAcoth(String)

Declaration
public string ComputeAcoth(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeAddress(String)

Declaration
public string ComputeAddress(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeAnd(String)

Returns the AND of all values treated as logical values listed in the argument.

Declaration
public string ComputeAnd(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers. Each item in the list is considered True if it is nonzero, and False if it is zero.
Returns
Type Description
System.String

A string holding the AND of all values listed in the argument.

ComputeArabic(String)

Declaration
public string ComputeArabic(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeAreas(String)

Returns the area of the passed in cell reference range

Declaration
public string ComputeAreas(string arg)
Parameters
Type Name Description
System.String arg

Contains one argument - reference
Returns
Type Description
System.String

area of the passed in cell reference.

ComputeAsc(String)

Changes full-width characters to half-width characters.

Declaration
public string ComputeAsc(string args)
Parameters
Type Name Description
System.String args

Value to convert.
Returns
Type Description
System.String

Converted string.

ComputeAsin(String)

Computes angle whose sine is the argument.

Declaration
public string ComputeAsin(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding angle whose sine is the argument.

ComputeAsinh(String)

The inverse of Sinh.

Declaration
public string ComputeAsinh(string args)
Parameters
Type Name Description
System.String args

Value.
Returns
Type Description
System.String

ASinh(value).

ComputeAtan(String)

Computes angle whose tangent is the argument.

Declaration
public string ComputeAtan(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the tangent of the argument.

ComputeAtan2(String)

The ArcTangent of the x and y values.

Declaration
public string ComputeAtan2(string argList)
Parameters
Type Name Description
System.String argList

x_value and y_value.
Returns
Type Description
System.String

Angle whose tangent is y_value/x_value.

ComputeAtanh(String)

The inverse of Tanh.

Declaration
public string ComputeAtanh(string args)
Parameters
Type Name Description
System.String args

|Value| < 1.
Returns
Type Description
System.String

ATanh(value).

ComputeAvedev(String)

Returns the average deviation of all values listed in the argument.

Declaration
public string ComputeAvedev(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the average deviation of all values listed in the argument.

ComputeAveragea(String)

Returns the simple average of all values (including text) listed in the argument.

Declaration
public string ComputeAveragea(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the simple average of all values listed in the argument.

ComputeAvg(String)

Returns the simple average of all values listed in the argument.

Declaration
public string ComputeAvg(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the simple average of all values listed in the argument.

ComputeAvg(String, Boolean)

Declaration
public string ComputeAvg(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeBase(String)

Declaration
public string ComputeBase(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBesselI(String)

Declaration
public string ComputeBesselI(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBesselJ(String)

Declaration
public string ComputeBesselJ(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputebesselK(String)

Declaration
public string ComputebesselK(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBesselY(String)

Declaration
public string ComputeBesselY(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBinomdist(String)

Returns the binomial distribution.

Declaration
public string ComputeBinomdist(string argList)
Parameters
Type Name Description
System.String argList

Number of successes, number of trials, probability, cumulative.
Returns
Type Description
System.String

Returns the binomial distribution.

ComputeBinomOdist(String)

Returns the binomial distribution.

Declaration
public string ComputeBinomOdist(string argList)
Parameters
Type Name Description
System.String argList

Number of successes, number of trials, probability, cumulative.
Returns
Type Description
System.String

The binomial distribution.

ComputeBinomOInv(String)

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Declaration
public string ComputeBinomOInv(string argList)
Parameters
Type Name Description
System.String argList

Number of trials, probability, alpha.
Returns
Type Description
System.String

Returns the critical value.

ComputeBinToDec(String)

Declaration
public string ComputeBinToDec(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBinToHex(String)

Declaration
public string ComputeBinToHex(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeBinToOct(String)

Computes the Octal Number for the given binary NUmber.

Declaration
public string ComputeBinToOct(string argList)
Parameters
Type Name Description
System.String argList

Input BinaryNumber
Returns
Type Description
System.String

The resultant Octal Number

ComputeBitOr(String)

Computes the Bit OR of the given two numbers.

Declaration
public string ComputeBitOr(string argList)
Parameters
Type Name Description
System.String argList

Input Numbersfor which the OR operations has to be performed.
Returns
Type Description
System.String

Bit OR value of the given two numbers.

ComputeCeiling(String)

Computes the smallest whole number greater than or equal to the argument.

Declaration
public string ComputeCeiling(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the smallest whole number greater than or equal to the argument.

ComputeCeilingMath(String)

Declaration
public string ComputeCeilingMath(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeCell(String)

Return the information about cell

Declaration
public string ComputeCell(string arg)
Parameters
Type Name Description
System.String arg

content, reference
Returns
Type Description
System.String

Cell information

ComputeChidist(String)

Returns the chi-squared distribution.

Declaration
public string ComputeChidist(string argList)
Parameters
Type Name Description
System.String argList

X degrees of freedom.
Returns
Type Description
System.String

Returns the chi-squared distribution.

ComputeChiinv(String)

Returns the inverse of the chi-squared distribution.

Declaration
public string ComputeChiinv(string argList)
Parameters
Type Name Description
System.String argList

X degrees of freedom.
Returns
Type Description
System.String

Returns the inverse of the chi-squared distribution.

ComputeChisqOdistORt(String)

Declaration
public string ComputeChisqOdistORt(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeChisqOinv(String)

Returns the inverse of the chi-squared distribution.

Declaration
public string ComputeChisqOinv(string argList)
Parameters
Type Name Description
System.String argList

x, degrees of freedom.
Returns
Type Description
System.String

The inverse of the chi-squared distribution.

ComputeChisqOinvORt(String)

Returns the inverse of the chi-squared distribution.

Declaration
public string ComputeChisqOinvORt(string argList)
Parameters
Type Name Description
System.String argList

x, degrees of freedom.
Returns
Type Description
System.String

The inverse of the chi-squared distribution.

ComputeChisqOTest(String)

Declaration
public string ComputeChisqOTest(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeChitest(String)

Returns the Chi Test for independence.

Declaration
public string ComputeChitest(string range)
Parameters
Type Name Description
System.String range

Actual_range, expected_range.
Returns
Type Description
System.String

y-intercept.

ComputeCode(String)

Declaration
public string ComputeCode(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeColumn(String)

Declaration
public string ComputeColumn(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeColumns(String)

Returns the number of columns of the passed in cell reference.

Declaration
public string ComputeColumns(string arg)
Parameters
Type Name Description
System.String arg

Contains one argument - reference
Returns
Type Description
System.String

number of columns.

ComputeCombin(String)

The number of combinations of a given number of items.

Declaration
public string ComputeCombin(string argList)
Parameters
Type Name Description
System.String argList

number, number_items.
Returns
Type Description
System.String

The number of combinations.

ComputeCombinA(String)

Declaration
public string ComputeCombinA(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeComplex(String)

Declaration
public string ComputeComplex(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeConcatenate(String)

Returns a single character string.

Declaration
public string ComputeConcatenate(string range)
Parameters
Type Name Description
System.String range

List of strings to be concatenated.
Returns
Type Description
System.String

A single string.

ComputeConfidence(String)

Returns a confidence interval radius.

Declaration
public string ComputeConfidence(string argList)
Parameters
Type Name Description
System.String argList

Alpha, standard deviation, size.
Returns
Type Description
System.String

Returns x such that normal distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeConfidenceOnorm(String)

Returns a confidence interval radius.

Declaration
public string ComputeConfidenceOnorm(string argList)
Parameters
Type Name Description
System.String argList

Alpha, standard deviation, size.
Returns
Type Description
System.String

Returns x such that normal distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeConfidenceT(String)

Declaration
public string ComputeConfidenceT(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeConversion(String)

Declaration
public string ComputeConversion(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeCorrel(String)

Returns the correlation coefficient between the two sets of points.

Declaration
public string ComputeCorrel(string range)
Parameters
Type Name Description
System.String range

Range1, range2.
Returns
Type Description
System.String

Correlation coefficient.

ComputeCos(String)

Computes the cosine of the argument.

Declaration
public string ComputeCos(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the cosine of the argument.

ComputeCosh(String)

Computes the hyperbolic cosine of the argument.

Declaration
public string ComputeCosh(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the hyperbolic cosine of the argument.

ComputeCot(String)

Returns the hyperbolic cosine of a number.

Declaration
public string ComputeCot(string argList)
Parameters
Type Name Description
System.String argList

A cell reference or a number
Returns
Type Description
System.String

A string containing the hyperbolic cosine of a number

ComputeCoth(String)

Returns the cotangent of an angle.

Declaration
public string ComputeCoth(string argList)
Parameters
Type Name Description
System.String argList

A cell reference or a number
Returns
Type Description
System.String

A string containing the cotangent of an angle

ComputeCount(String)

Returns the count of all values (including text) listed in the argument evaluate to a number.

Declaration
public string ComputeCount(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the count of all numerical values listed in the argument.

ComputeCount(String, Boolean)

Declaration
public string ComputeCount(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeCounta(String)

Returns the count of all values (including text) listed in the argument.

Declaration
public string ComputeCounta(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the count of all values listed in the argument.

ComputeCounta(String, Boolean)

Declaration
public string ComputeCounta(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeCountblank(String)

Returns the count of blank cells listed in the argument.

Declaration
public string ComputeCountblank(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the count of blank cells listed in the argument.

ComputeCountif(String)

Counts the cells specified by some criteria.

Declaration
public string ComputeCountif(string argList)
Parameters
Type Name Description
System.String argList

The criteria range, the criteria.
Returns
Type Description
System.String

Returns string to the cell count

ComputeCovar(String)

Returns the covariance between the two sets of points.

Declaration
public string ComputeCovar(string range)
Parameters
Type Name Description
System.String range

Range1, range2.
Returns
Type Description
System.String

Covariance.

ComputeCovarianceP(String)

Returns population covariance, the average of the products of deviations for each data point pair in two data sets.

Declaration
public string ComputeCovarianceP(string range)
Parameters
Type Name Description
System.String range

range1, range2.
Returns
Type Description
System.String

The covarianceP

ComputeCovarianceS(String)

Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.

Declaration
public string ComputeCovarianceS(string range)
Parameters
Type Name Description
System.String range

range1, range2.
Returns
Type Description
System.String

The covariances

ComputeCritbinom(String)

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Declaration
public string ComputeCritbinom(string argList)
Parameters
Type Name Description
System.String argList

Number of trials, probability, alpha.
Returns
Type Description
System.String

Returns the critcal value.

ComputeCsc(String)

Returns the cosecant of an angle

Declaration
public string ComputeCsc(string argList)
Parameters
Type Name Description
System.String argList

a cell reference or number
Returns
Type Description
System.String

A string containing the cosecant of an angle

ComputeCsch(String)

Returns the hyperbolic cosecant of an angle.

Declaration
public string ComputeCsch(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

A string containing the hyperbolic cosecant of an angle

ComputeCUMIPMT(String)

Declaration
public string ComputeCUMIPMT(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeCUMPRINC(String)

Declaration
public string ComputeCUMPRINC(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeDate(String)

Returns the number of days since 01 Jan 1900.

Declaration
public string ComputeDate(string argList)
Parameters
Type Name Description
System.String argList

Year, month, and day.
Returns
Type Description
System.String

Number of days.

ComputeDatevalue(String)

Returns the number of days since 01 Jan 1900.

Declaration
public string ComputeDatevalue(string argList)
Parameters
Type Name Description
System.String argList

Text containing a date.
Returns
Type Description
System.String

Number of days.

ComputeDAverage(String)

Averages the values in a field (column) of records in a list or database that match conditions you specify.

Declaration
public string ComputeDAverage(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDay(String)

Returns the day of the serial number date.

Declaration
public string ComputeDay(string argList)
Parameters
Type Name Description
System.String argList

Serial number date.
Returns
Type Description
System.String

Day.

ComputeDAYS(String)

Declaration
public string ComputeDAYS(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeDays360(String)

Number of days between 2 dates using 360 day year.

Declaration
public string ComputeDays360(string argList)
Parameters
Type Name Description
System.String argList

Serial number date1, serial number date1, and method.
Returns
Type Description
System.String

Days between the dates.

ComputeDb(String)

Computes the declining balance of an asset.

Declaration
public string ComputeDb(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the initial cost, salvage value, life of asset, period of calculation, and months in initial year.
Returns
Type Description
System.String

Declining balance.

ComputeDCount(String)

Returns the amount received at maturity for a fully invested security.

Declaration
public string ComputeDCount(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDCountA(String)

Counts the nonblank cells in a field (column) of records in a list or database that match conditions that you specify.

Declaration
public string ComputeDCountA(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDdb(String)

Computes the double declining balance of an asset.

Declaration
public string ComputeDdb(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the initial cost, salvage value, life of asset, period of calculation, factor.
Returns
Type Description
System.String

Double declining balance.

ComputeDecimal(String)

Declaration
public string ComputeDecimal(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeDecToBin(String)

Declaration
public string ComputeDecToBin(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeDecToHex(String)

Computes the Hexadecimal value for the given Decimal Number.

Declaration
public string ComputeDecToHex(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

Returns the calculated Hexadecimal value.

ComputeDecToOct(String)

Computes the Octal value for the given Decimal Number.

Declaration
public string ComputeDecToOct(string argList)
Parameters
Type Name Description
System.String argList

data to be converted.
Returns
Type Description
System.String

Returns the calculated Octal value.

ComputeDegrees(String)

Converts radians into degrees.

Declaration
public string ComputeDegrees(string args)
Parameters
Type Name Description
System.String args

Value in radians.
Returns
Type Description
System.String

Degrees.

ComputeDevsq(String)

Returns the sum of the squares of the mean deviations.

Declaration
public string ComputeDevsq(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

Sum of the squares of the mean deviation.

ComputeDGet(String)

Extracts a single value from a column of a list or database that matches conditions that you specify.

Declaration
public string ComputeDGet(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDisc(String)

Returns the discount rate for a security.

Declaration
public string ComputeDisc(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Rate of Discount

ComputeDMax(String)

Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.

Declaration
public string ComputeDMax(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDMin(String)

Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.

Declaration
public string ComputeDMin(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDollar(String)

Converts a number to text using currency format.

Declaration
public string ComputeDollar(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits.
Returns
Type Description
System.String

Currency format string.

ComputeDollarDe(String)

Converts a number to text using currency format.

Declaration
public string ComputeDollarDe(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits.
Returns
Type Description
System.String

Currency format string.

ComputeDollarFr(String)

Declaration
public string ComputeDollarFr(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeDProduct(String)

Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.

Declaration
public string ComputeDProduct(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDStdev(String)

Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

Declaration
public string ComputeDStdev(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDStdevp(String)

Calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

Declaration
public string ComputeDStdevp(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDSum(String)

Adds the numbers in a field (column) of records in a list or database that match conditions that you specify

Declaration
public string ComputeDSum(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDuration(String)

Returns the weighted average of the present value of the cash flows

Declaration
public string ComputeDuration(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Number of years

ComputedValue(String)

Computes the value of a parsed formula.

Declaration
public string ComputedValue(string formula)
Parameters
Type Name Description
System.String formula

The formula to be computed.
Returns
Type Description
System.String

A string holding the computed value.
Remarks

The string passed into ComputedValue must have been parsed using the Parse method. Before calling the method, you should set FormulaContextCell to properly reflect which cell owns this formula.

ComputeDVar(String)

Estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

Declaration
public string ComputeDVar(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeDVarp(String)

Calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.

Declaration
public string ComputeDVarp(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeEDATE(String)

Declaration
public string ComputeEDATE(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeENCODEURL(String)

Returns the encode url of the given text

Declaration
public string ComputeENCODEURL(string argList)
Parameters
Type Name Description
System.String argList

text
Returns
Type Description
System.String

returns the EncodeURL

ComputeEOMONTH(String)

Declaration
public string ComputeEOMONTH(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeErf(String)

Declaration
public string ComputeErf(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeErfCPrecise(String)

Declaration
public string ComputeErfCPrecise(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeErfPrecise(String)

Declaration
public string ComputeErfPrecise(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeErrorType(String)

Returns a number corresponding to the predefined error values(#NULL!, #VALUE!, #REF!, #NAME?, #NUM!, #N/A, "#GETTING_DATA). Returns #N/A if not or any value enclosed within double quotes.

Declaration
public string ComputeErrorType(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeEven(String)

Rounds up to larger in magnitude even number.

Declaration
public string ComputeEven(string args)
Parameters
Type Name Description
System.String args

Number to be rounded.
Returns
Type Description
System.String

Rounded even value.

ComputeExp(String)

Computes e raised to the value of the argument.

Declaration
public string ComputeExp(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the e raised to the value of the argument.

ComputeExpondist(String)

Returns the exponential distribution.

Declaration
public string ComputeExpondist(string argList)
Parameters
Type Name Description
System.String argList

X, lambda, cumulative.
Returns
Type Description
System.String

Returns the exponential distribution.
Remarks

Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function.

ComputeExponODist(String)

Returns the exponential distribution.

Declaration
public string ComputeExponODist(string argList)
Parameters
Type Name Description
System.String argList

x, lambda, cumulative.
Returns
Type Description
System.String

The exponential distribution.
Remarks

Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function.

ComputeFact(String)

Factorial of a given number.

Declaration
public string ComputeFact(string args)
Parameters
Type Name Description
System.String args

x.
Returns
Type Description
System.String

x!.

ComputeFactDouble(String)

Declaration
public string ComputeFactDouble(string argsList)
Parameters
Type Name Description
System.String argsList
Returns
Type Description
System.String

ComputeFalse(String)

Returns the logical value False.

Declaration
public string ComputeFalse(string empty)
Parameters
Type Name Description
System.String empty

Empty string.
Returns
Type Description
System.String

Logical False value string.

ComputeFdist(String)

Returns the F (Fisher) probability distribution.

Declaration
public string ComputeFdist(string argList)
Parameters
Type Name Description
System.String argList

X, degreesfreedom1, degreesfreedom2.
Returns
Type Description
System.String

Returns the F probability distribution.

ComputeFILTERXML(String)

Filter the value from XML document

Declaration
public string ComputeFILTERXML(string argList)
Parameters
Type Name Description
System.String argList

XML content
Returns
Type Description
System.String

value

ComputeFindB(String)

Finds the first occurrence of one string in another string.

Declaration
public string ComputeFindB(string arg)
Parameters
Type Name Description
System.String arg

Conatins two or three arguments. The first argument is the string to find. The second string is the string that is being searched. The third argument is the start location in the second string for the search.
Returns
Type Description
System.String

The location of the found string.

ComputeFinv(String)

Returns the inverse of F distribution.

Declaration
public string ComputeFinv(string argList)
Parameters
Type Name Description
System.String argList

P, degreesfreedom1, degreesfreedom2.
Returns
Type Description
System.String

Returns x such that F distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeFisher(String)

Returns the Fisher transformation of the input variable.

Declaration
public string ComputeFisher(string argList)
Parameters
Type Name Description
System.String argList

Input variable x.
Returns
Type Description
System.String

Fisher transformation of x.
Remarks

X should be between -1 and 1.

ComputeFisherinv(String)

Returns the inverse of Fisher transformation.

Declaration
public string ComputeFisherinv(string argList)
Parameters
Type Name Description
System.String argList

Input variable y.
Returns
Type Description
System.String

The value x such that the Fisher transformation y is x.

ComputeFixed(String)

Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and return the result as text.

Declaration
public string ComputeFixed(string args)
Parameters
Type Name Description
System.String args

Number, number of digits, a flag that prevents from include commas in the returned text.
Returns
Type Description
System.String

Formatted number as string.

ComputeFloor(String)

Computes the largest whole number less than or equal to the argument.

Declaration
public string ComputeFloor(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the largest whole number less than or equal to the argument.

ComputeFOdist(String)

Returns the F probability distribution.

Declaration
public string ComputeFOdist(string argList)
Parameters
Type Name Description
System.String argList

x, degreesfreedom1, degreesfreedom2.
Returns
Type Description
System.String

Returns the F probability distribution.

ComputeFOdistORt(String)

Returns the F (Fisher) probability distribution.

Declaration
public string ComputeFOdistORt(string argList)
Parameters
Type Name Description
System.String argList

x, degreesfreedom1, degreesfreedom2.
Returns
Type Description
System.String

Returns the F probability distribution.

ComputeFOinvORt(String)

Returns the inverse of F distribution.

Declaration
public string ComputeFOinvORt(string argList)
Parameters
Type Name Description
System.String argList

p, degreesfreedom1, degreesfreedom2.
Returns
Type Description
System.String

Returns x such that F distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeForecast(String)

Returns a forecasted value based on two sets of points using Least Square Fit regression.

Declaration
public string ComputeForecast(string range)
Parameters
Type Name Description
System.String range

X, rangex, rangey.
Returns
Type Description
System.String

Forecasted.

ComputeFORMULATEXT(String)

Declaration
public string ComputeFORMULATEXT(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeFv(String)

Computes the future value of an investment.

Declaration
public string ComputeFv(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, number of periods, payment per period, present value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

Future value of an investment.

ComputeFvschedule(String)

Returns the future value of an initial principal after applying a series of compound interest rates.

Declaration
public string ComputeFvschedule(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Number of future value

ComputeGammadist(String)

Returns the gamma distribution.

Declaration
public string ComputeGammadist(string argList)
Parameters
Type Name Description
System.String argList

X, alpha, beta, cumulative.
Returns
Type Description
System.String

Returns the gamma distribution.
Remarks

X, alpha and beta should be positive real numbers. Cumulative should be either True if you want to return the value of the distribution function, or False if you want to return the value of the density function. The distribution value is computed interactively using Trapezoidal Rule to six to seven significant digits or 20 iteration maximum.

ComputeGammainv(String)

Returns the inverse of gamma distribution.

Declaration
public string ComputeGammainv(string argList)
Parameters
Type Name Description
System.String argList

P, alpha, beta
Returns
Type Description
System.String

Returns x such that gamma distribution at x is p.
Remarks

P, alpha and beta should be positive real numbers, with p between 0 and 1.

ComputeGammaln(String)

Returns the natural logarithm of the gamma function.

Declaration
public string ComputeGammaln(string argList)
Parameters
Type Name Description
System.String argList

The value to be evaluated.
Returns
Type Description
System.String

Returns the natural logarithm of the gamma function.

ComputeGammaln0Precise(String)

Returns the natural logarithm of the gamma function.

Declaration
public string ComputeGammaln0Precise(string argList)
Parameters
Type Name Description
System.String argList

The value to be evaluated.
Returns
Type Description
System.String

The natural logarithm of the gamma function.

ComputeGammaOdist(String)

Returns the gamma distribution.

Declaration
public string ComputeGammaOdist(string argList)
Parameters
Type Name Description
System.String argList

X, alpha, beta, cumulative.
Returns
Type Description
System.String

The gamma distribution.
Remarks

X, alpha, and beta should be positive real numbers. Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function. The distribution value is computed interactively using Trapezoidal Rule to six to seven significant digits or 20 iteration maximum.

ComputeGammaOinv(String)

Returns the inverse of gamma distribution.

Declaration
public string ComputeGammaOinv(string argList)
Parameters
Type Name Description
System.String argList

p, alpha, beta
Returns
Type Description
System.String

Returns x such that gamma distribution at x is p.
Remarks

P, alpha, and beta should be positive real numbers, with p between 0 and 1.

ComputeGCD(String)

Declaration
public string ComputeGCD(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeGeomean(String)

Returns the geometric mean of all values listed in the argument.

Declaration
public string ComputeGeomean(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The geometric mean of all values listed in the argument.

ComputeHarmean(String)

Returns the harmonic mean of all values listed in the argument.

Declaration
public string ComputeHarmean(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The harmonic mean all values listed in the argument.

ComputeHexToBin(String)

Computes the Binary value for the given Hexadecimal Data.

Declaration
public string ComputeHexToBin(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

Returns the calculated Binary value.

ComputeHexToDec(String)

Computes the Decimal Equivalent for the given Hexadecimal value

Declaration
public string ComputeHexToDec(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

The calculated Decimal value for the given.

ComputeHexToOct(String)

Computes the Octal Equivalent for the given Hexadecimal value

Declaration
public string ComputeHexToOct(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

The calculated Octal value for the given.

ComputeHLookUp(String)

Returns a horizontal table look up value.

Declaration
public string ComputeHLookUp(string range)
Parameters
Type Name Description
System.String range

Contains search value, table, return index and match properties.
Returns
Type Description
System.String

Matching value found in the table.
Remarks

For example, =HLOOKUP("Axles",A1:C4,2,TRUE) looks for the exact match for Axles in A1:C1 and returns the corresponding value in A2:C2.

ComputeHour(String)

Returns the hour of the given time.

Declaration
public string ComputeHour(string argList)
Parameters
Type Name Description
System.String argList

Given time.
Returns
Type Description
System.String

Hour.

ComputeHYPERLINK(String)

Declaration
public string ComputeHYPERLINK(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeHypgeomdist(String)

Returns the hypergeometric distribution.

Declaration
public string ComputeHypgeomdist(string argList)
Parameters
Type Name Description
System.String argList

Number of sample successes, number of sample, number of population successes, number of population.
Returns
Type Description
System.String

Returns the gamma distribution.

ComputeHypgeomOdist(String)

Returns the hypergeometric distribution.

Declaration
public string ComputeHypgeomOdist(string argList)
Parameters
Type Name Description
System.String argList

Number of sample successes, number of sample, number of population successes, number of population.
Returns
Type Description
System.String

Returns the gamma distribution.

ComputeIf(String)

Conditionally computes one of two alternatives depending upon a logical expression.

Declaration
public string ComputeIf(string args)
Parameters
Type Name Description
System.String args

A string holding a list of three arguments.
Returns
Type Description
System.String

Returns a string holding the second argument if the first argument is True (non-zero). Otherwise, it returns a string holding the third argument.
Remarks

The first argument is treated as a logical expression with a non-zero value considered True and a zero value considered False. The value of only one of the alternatives is computed depending upon the logical expression.

ComputeIfError(String)

Returns a value you specify if a formula evaluates to an error otherwise, returns the result of the formula.

Declaration
public string ComputeIfError(string args)
Parameters
Type Name Description
System.String args

String to be tested.
Returns
Type Description
System.String

ComputeIHDIST(String)

The Irwin-Hall distribution results from the sum on n independent standard uniform variables

Declaration
public string ComputeIHDIST(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeImABS(String)

Declaration
public string ComputeImABS(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImaginary(String)

Declaration
public string ComputeImaginary(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImaginaryArgument(String)

Returns the argument (theta), an angle expressed in radians

Declaration
public string ComputeImaginaryArgument(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The argument (theta), an angle expressed in radians

ComputeImaginaryDifference(String)

Declaration
public string ComputeImaginaryDifference(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImaginarySum(String)

Declaration
public string ComputeImaginarySum(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImCos(String)

Declaration
public string ComputeImCos(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImCosH(String)

Returns the Hyperbolic Cos value of the given Complex Number.

Declaration
public string ComputeImCosH(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The Hyperbolic Cos Value of the given Complex Number.

ComputeImCot(String)

Declaration
public string ComputeImCot(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeIMCSCH(String)

Declaration
public string ComputeIMCSCH(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImDiv(String)

Computes the Division of the given Complex Numbers

Declaration
public string ComputeImDiv(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Numbers
Returns
Type Description
System.String

The Divided result of the two complex numbers.

ComputeImEXP(String)

Returns the Exponent of the given Complex Number.

Declaration
public string ComputeImEXP(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The Exponent of the given Complex Number.

ComputeIMLN(String)

Returns the LOG value of the given Complex Number.

Declaration
public string ComputeIMLN(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The Log of the given Complex Number.

ComputeImPower(String)

Returns the power of the given Complex Number.

Declaration
public string ComputeImPower(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The power of the given Complex Number.

ComputeImSin(String)

Declaration
public string ComputeImSin(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImSinH(String)

Declaration
public string ComputeImSinH(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeImSqrt(String)

Returns the Square Root of the given Complex Number.

Declaration
public string ComputeImSqrt(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The Square Root of the given Complex Number.

ComputeIndirect(String)

Returns the reference specified by a text string. References are immediately evaluated to display their contents.

Syntax: INDIRECT(CellRefString, [IsA1Style])

Declaration
public string ComputeIndirect(string args)
Parameters
Type Name Description
System.String args

Cell reference string.
Returns
Type Description
System.String

Reference specified the argument.

ComputeINFO(String)

Declaration
public string ComputeINFO(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeInt(String)

Returns the integer value.

Declaration
public string ComputeInt(string range)
Parameters
Type Name Description
System.String range

Number to be truncated.
Returns
Type Description
System.String

An integer.

ComputeIntercept(String)

Returns the y-intercept of the least square fit line through the given points.

Declaration
public string ComputeIntercept(string range)
Parameters
Type Name Description
System.String range

y_range, x_range.
Returns
Type Description
System.String

y-intercept.

ComputeIntrate(String)

Returns the interest rate for a fully invested security.

Declaration
public string ComputeIntrate(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

Rate of interest

ComputeIpmt(String)

Computes the interest payment for a period.

Declaration
public string ComputeIpmt(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, the period, number of periods, present value, future value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

ComputeIrr(String)

Computes the internal rate of return of a series of cash flows.

Declaration
public string ComputeIrr(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing a range of cells and an initial guess.
Returns
Type Description
System.String

Internal rate of return.
Remarks

This IRR calculation uses Newton's method to approximate a root of f(r) = Sum( values[i]/(1+r)^i) = 0 where the Sum index is i = 1 to the number of values. The algorithm returns a value if the relative difference between root approximations is less than 1e-5. It fails if this accuracy is not attained in 20 iterations.

ComputeIsBlank(String)

Determines whether the value is empty string.

Declaration
public string ComputeIsBlank(string args)
Parameters
Type Name Description
System.String args

Value to be tested.
Returns
Type Description
System.String

True if the value is empty, False otherwise.

ComputeIsErr(String)

Returns True is the string denotes an error except #N/A.

Declaration
public string ComputeIsErr(string range)
Parameters
Type Name Description
System.String range

Value to be tested.
Returns
Type Description
System.String

True if the value is an error except #N/A, false otherwise.

ComputeIsError(String)

Returns True is the string denotes an error.

Declaration
public string ComputeIsError(string range)
Parameters
Type Name Description
System.String range

String to be tested.
Returns
Type Description
System.String

True if the value is an error.

ComputeIsEven(String)

Determines whether the given string is Even number or Not.

Declaration
public string ComputeIsEven(string range)
Parameters
Type Name Description
System.String range

A string to be tested.
Returns
Type Description
System.String

TRUE if the string is Even Number, otherwise returns False

ComputeIsFormula(String)

Declaration
public string ComputeIsFormula(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeIsLogical(String)

Determines whether the value is a logical value.

Declaration
public string ComputeIsLogical(string args)
Parameters
Type Name Description
System.String args

Value to be tested.
Returns
Type Description
System.String

True if the value is a logical value, False otherwise.

ComputeIsNA(String)

Determines whether the value is the #NA error value.

Declaration
public string ComputeIsNA(string args)
Parameters
Type Name Description
System.String args

Value to be tested.
Returns
Type Description
System.String

True if the value is the #NA error value, False otherwise.

ComputeIsNonText(String)

Determines whether the value is not a string.

Declaration
public string ComputeIsNonText(string args)
Parameters
Type Name Description
System.String args

Value to be tested.
Returns
Type Description
System.String

True if the value is not a string, false otherwise.

ComputeIsNumber(String)

Determines whether the string contains a number or not.

Declaration
public string ComputeIsNumber(string range)
Parameters
Type Name Description
System.String range

String to be tested.
Returns
Type Description
System.String

True if the string is a number.

ComputeIsOdd(String)

Determines wheather the String contains Odd Number or Not.

Declaration
public string ComputeIsOdd(string range)
Parameters
Type Name Description
System.String range

A string to be tested
Returns
Type Description
System.String

Returns True if the value in the range is Odd otherwise returns False

ComputeISOWeeknum(String)

Returns ISO week number of the year for a given date

Declaration
public string ComputeISOWeeknum(string argList)
Parameters
Type Name Description
System.String argList

date
Returns
Type Description
System.String

returns ISO week number

ComputeIspmt(String)

Computes the simple interest payment.

Declaration
public string ComputeIspmt(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, the period, number of periods, and present value.
Returns
Type Description
System.String

Interest payment.

ComputeIsText(String)

Determines whether the value is string or not.

Declaration
public string ComputeIsText(string args)
Parameters
Type Name Description
System.String args

Value to be tested.
Returns
Type Description
System.String

True if the value is a string, false otherwise.

ComputeJis(String)

Declaration
public string ComputeJis(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeKurt(String)

Returns the kurtosis of the passed-in values.

Declaration
public string ComputeKurt(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The kurtosis of the data.

ComputeLarge(String)

Returns the kth largest value in the range.

Declaration
public string ComputeLarge(string range)
Parameters
Type Name Description
System.String range

Range, k.
Returns
Type Description
System.String

Kth largest value.

ComputeLCM(String)

Declaration
public string ComputeLCM(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeLeft(String)

Returns the left so many characters in the given string.

Declaration
public string ComputeLeft(string range)
Parameters
Type Name Description
System.String range

Contains the string and the number of characters.
Returns
Type Description
System.String

A string.

ComputeLeftB(String)

Returns the left so many characters in the given string.

Declaration
public string ComputeLeftB(string range)
Parameters
Type Name Description
System.String range

Contains the string and the number of characters.
Returns
Type Description
System.String

A left sub string..

ComputeLen(String)

Returns the length of the given string.

Declaration
public string ComputeLen(string range)
Parameters
Type Name Description
System.String range

Contains the string.
Returns
Type Description
System.String

An integer length.

ComputeLenB(String)

Returns the length of the given string.

Declaration
public string ComputeLenB(string range)
Parameters
Type Name Description
System.String range

Contains the string.
Returns
Type Description
System.String

An integer length.

ComputeLn(String)

Computes the natural logarithm of the value in the argument.

Declaration
public string ComputeLn(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding natural logarithm of the value in the argument.

ComputeLog(String)

Computes the logarithm of the first value using the second value as the base.

Declaration
public string ComputeLog(string argList)
Parameters
Type Name Description
System.String argList

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding logarithm of the value in the argument using the second argument as the base.

ComputeLog10(String)

Computes the base 10 logarithm of the value in the argument.

Declaration
public string ComputeLog10(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding base 10 logarithm of the value in the argument.

ComputeLoginv(String)

Returns the inverse of the lognormal distribution.

Declaration
public string ComputeLoginv(string argList)
Parameters
Type Name Description
System.String argList

P, mean, standarddev.
Returns
Type Description
System.String

Returns the value x where the lognormal distribution of x is p.

ComputeLognormdist(String)

Returns the lognormal distribution.

Declaration
public string ComputeLognormdist(string argList)
Parameters
Type Name Description
System.String argList

X, mean, standarddev.
Returns
Type Description
System.String

Returns the lognormal distribution.

ComputeLognormOdist(String)

Returns the lognormal distribution.

Declaration
public string ComputeLognormOdist(string argList)
Parameters
Type Name Description
System.String argList

x, mean, standarddev.
Returns
Type Description
System.String

The lognormal distribution.

ComputeLognormOinv(String)

Returns the inverse of the lognormal distribution.

Declaration
public string ComputeLognormOinv(string argList)
Parameters
Type Name Description
System.String argList

p, mean, standarddev.
Returns
Type Description
System.String

Returns the value x where the lognormal distribution of x is p.

ComputeLower(String)

Converts text to lowercase.

Declaration
public string ComputeLower(string args)
Parameters
Type Name Description
System.String args

Value to convert.
Returns
Type Description
System.String

Converted string.

ComputeMatch(String)

Finds the index a specified value in a lookup_range.

Declaration
public string ComputeMatch(string arg)
Parameters
Type Name Description
System.String arg

look_value, lookup_range, match_type
Returns
Type Description
System.String

The relative index of the lookup_value in the lookup_range.
Remarks

Lookup_range should be a either a single row range or a single column range. If match_type is 0, the relative index of the first exact match (ignoring case) in the specified range is returned. If match_type is 1, the values in the range should be in ascending order, and the index of the largest value less than or equal to the lookup_value is returned. If match_type is -1, the values in the range should be in descending order, and the index of the smallest value greater than or equal to the lookup_value is returned.

ComputeMax(String)

Returns the maximum value of all values listed in the argument.

Declaration
public string ComputeMax(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the maximum value of all values listed in the argument.

ComputeMax(String, Boolean)

Declaration
public string ComputeMax(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeMaxa(String)

Returns the maximum value of all values listed in the argument including logical values.

Declaration
public string ComputeMaxa(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the maximum value of all values listed in the argument.
Remarks

True is treated as 1 and False is treated as 0.

ComputeMdeterm(String)

Returns the number of columns of the passed in cell reference.

Declaration
public string ComputeMdeterm(string arg)
Parameters
Type Name Description
System.String arg

Contains one argument - reference
Returns
Type Description
System.String

number of columns.

ComputeMedian(String)

Returns the median value in the range.

Declaration
public string ComputeMedian(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

Median value.

ComputeMid(String)

Returns a substring of the given string.

Declaration
public string ComputeMid(string range)
Parameters
Type Name Description
System.String range

Contains the original string, start position of the substring, and the number of characters in the substring.
Returns
Type Description
System.String

A string.

ComputeMidB(String)

Returns a substring of the given string.

Declaration
public string ComputeMidB(string range)
Parameters
Type Name Description
System.String range

Contains the original string, start position of the substring, and the number of characters in the substring.
Returns
Type Description
System.String

A substring.

ComputeMin(String)

Returns the minimum value of all values listed in the argument.

Declaration
public string ComputeMin(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the minimum value of all values listed in the argument.

ComputeMin(String, Boolean)

Declaration
public string ComputeMin(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeMina(String)

Returns the minimum value of all values listed in the argument including logical values.

Declaration
public string ComputeMina(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the minimum value of all values listed in the argument.
Remarks

True is treated as 1 and False is treated as 0.

ComputeMinute(String)

Returns the Minute of the given time.

Declaration
public string ComputeMinute(string argList)
Parameters
Type Name Description
System.String argList

Given time.
Returns
Type Description
System.String

Minute.

ComputeMInverse(String)

Declaration
public string ComputeMInverse(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeMirr(String)

Computes the modified internal rate of return of a series of cash flows.

Declaration
public string ComputeMirr(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing a range of cells, finance interest rate, and a reinvest interest rate.
Returns
Type Description
System.String

Modified internal rate of return.

ComputeMmult(String)

Declaration
public string ComputeMmult(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeMod(String)

Returns the remainder after dividing one number by another.

Declaration
public string ComputeMod(string range)
Parameters
Type Name Description
System.String range

Two numbers in a list.
Returns
Type Description
System.String

The remainder.

ComputeMode(String)

Returns the most frequent value in the range.

Declaration
public string ComputeMode(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The most frequent value.

ComputeMonth(String)

Returns the month of the given date.

Declaration
public string ComputeMonth(string argList)
Parameters
Type Name Description
System.String argList

Given time.
Returns
Type Description
System.String

Month.

ComputeMRound(String)

Determines the MRound value for thr Given arguments.

Declaration
public string ComputeMRound(string argsList)
Parameters
Type Name Description
System.String argsList

Number, Multiple
Returns
Type Description
System.String

MRound value of the given number

ComputeMultinomial(String)

Determines the Multinominal value of given range of numbers.

Declaration
public string ComputeMultinomial(string range)
Parameters
Type Name Description
System.String range

Given numbers
Returns
Type Description
System.String

Multinominal value of given range of numbers.

ComputeMUnit(String)

Declaration
public string ComputeMUnit(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeN(String)

Converts a value to a number.

Declaration
public string ComputeN(string args)
Parameters
Type Name Description
System.String args

Value to convert.
Returns
Type Description
System.String

Converted string.

ComputeNA()

Returns the string "#N/A" (#N/A - value not available).

Declaration
public string ComputeNA()
Returns
Type Description
System.String

error value

ComputeNegbinomdist(String)

Returns the negative binomial distribution.

Declaration
public string ComputeNegbinomdist(string argList)
Parameters
Type Name Description
System.String argList

Number of failures, success threshold, probability, cumulative.
Returns
Type Description
System.String

Returns the negative binomial distribution.

ComputeNegbinomODist(String)

Returns the negative binomial distribution.

Declaration
public string ComputeNegbinomODist(string argList)
Parameters
Type Name Description
System.String argList

Number of failures, success threshold, probability, cumulative.
Returns
Type Description
System.String

The negative binomial distribution.

ComputeNetworkDaysintl(String)

Returns the number of whole workdays between two dates, week end and holidays are not consider as working days

Declaration
public string ComputeNetworkDaysintl(string argList)
Parameters
Type Name Description
System.String argList

start_date, end_date,weekend (optional), holidays (optional)
Returns
Type Description
System.String

return the work days

ComputeNormdist(String)

Returns the normal distribution.

Declaration
public string ComputeNormdist(string argList)
Parameters
Type Name Description
System.String argList

X, mean, standarddev, cumulative.
Returns
Type Description
System.String

Returns the normal distribution.
Remarks

Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function. The distribution value is computed interactively using Trapezoidal Rule to six to seven significant digits or 20 iteration maximum.

ComputeNorminv(String)

Returns the inverse of normal distribution.

Declaration
public string ComputeNorminv(string argList)
Parameters
Type Name Description
System.String argList

P, mean, standard deviation.
Returns
Type Description
System.String

Returns x such that normal distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeNormOdist(String)

Returns the normal distribution for the specified mean and standard deviation.

Declaration
public string ComputeNormOdist(string argList)
Parameters
Type Name Description
System.String argList

x, mean, standarddev, cumulative.
Returns
Type Description
System.String

The normal distribution.
Remarks

Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function. The distribution value is computed interactively using Trapezoidal Rule to six to seven significant digits or 20 iteration maximum.

ComputeNormOinv(String)

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Declaration
public string ComputeNormOinv(string argList)
Parameters
Type Name Description
System.String argList

P, mean, standard deviation.
Returns
Type Description
System.String

Returns x such that normal distribution at x is p.
Remarks

P should be between 0 and 1.

ComputeNormOsODist(String)

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one.

Syntax: NORMSDIST(z)

Declaration
public string ComputeNormOsODist(string argList)
Parameters
Type Name Description
System.String argList

Z is the value for which you want the distribution.
Returns
Type Description
System.String

Standard normal cumulative distribution.

ComputeNormOsOInv(String)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax: NORMSINV(p)

Declaration
public string ComputeNormOsOInv(string argList)
Parameters
Type Name Description
System.String argList

p is a probability corresponding to the normal distribution.
Returns
Type Description
System.String

Inverse of standard normal cumulative distribution.
Remarks

p should be between 0 and 1.

ComputeNormsDist(String)

Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one.

Syntax: NORMSDIST(z)

Declaration
public string ComputeNormsDist(string argList)
Parameters
Type Name Description
System.String argList

Z is the value for which you want the distribution.
Returns
Type Description
System.String

Returns string standard normal cumulative distribution function.

ComputeNormsInv(String)

Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

Syntax: NORMSINV(p)

Declaration
public string ComputeNormsInv(string argList)
Parameters
Type Name Description
System.String argList

p is a probability corresponding to the normal distribution.
Returns
Type Description
System.String
Remarks

p should be between 0 and 1.

ComputeNot(String)

Flips the logical value represented by the argument.

Declaration
public string ComputeNot(string args)
Parameters
Type Name Description
System.String args

A string holding either a single argument consisting of a cell reference, a formula, or a number.
Returns
Type Description
System.String

Returns 0 if the argument evaluates to a non-zero value. Otherwise, it returns 1.
Remarks

The argument is treated as a logical expression with a non-zero value considered True and a zero value considered False.

ComputeNow(String)

Returns the current date and time as a date serial number.

Declaration
public string ComputeNow(string argList)
Parameters
Type Name Description
System.String argList

Ignored.
Returns
Type Description
System.String

Current date and time as serial number.

ComputeNper(String)

Computes the number of periods in an investment.

Declaration
public string ComputeNper(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, payment per period, present value, future value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

Number of periods.

ComputeNpv(String)

Computes the net present value of an investment.

Declaration
public string ComputeNpv(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period
and a list of invested values.
Returns
Type Description
System.String

Net present value.

ComputeNumberValue(String)

Convert the text to number

Declaration
public string ComputeNumberValue(string argList)
Parameters
Type Name Description
System.String argList

text,
Returns
Type Description
System.String

decimal separator,group separator

ComputeOctToBin(String)

Computes the Binary value for the given Octal Number.

Declaration
public string ComputeOctToBin(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

Returns the calculated Binary value.

ComputeOctToDec(String)

Computes the Decimal Equivalent for the given Octal value

Declaration
public string ComputeOctToDec(string argList)
Parameters
Type Name Description
System.String argList

The Value to be converted to Decimal
Returns
Type Description
System.String

The calculated value for the given

ComputeOctToHex(String)

Calculates the Hexadecimal equivalent value for the given Octal value

Declaration
public string ComputeOctToHex(string argList)
Parameters
Type Name Description
System.String argList

Data to be converted.
Returns
Type Description
System.String

The Converted Hexadecimal value.

ComputeOdd(String)

Rounds up to larger in magnitude odd number.

Declaration
public string ComputeOdd(string args)
Parameters
Type Name Description
System.String args

Number to be rounded.
Returns
Type Description
System.String

Rounded odd value.

ComputeOffSet(String)

Returns a range that is the offset of the reference range by rows and cols.

Declaration
public string ComputeOffSet(string arg)
Parameters
Type Name Description
System.String arg

reference, rows, cols, [height], [width]
Returns
Type Description
System.String

A range offset.
Remarks

The returned range is the range passed in through the reference variable offset by the number of rows in the rows variable and number of columns in the cols variable. If height and width are present in the argument list, they determine the number of rows and columns in the returned range. Otherwise, the dimensions of the returned range match the input range.

ComputeOr(String)

Returns the inclusive OR of all values treated as logical values listed in the argument.

Declaration
public string ComputeOr(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers. Each item in the list is considered True if it is nonzero, and False if it is zero.
Returns
Type Description
System.String

A string holding the OR of all values listed in the argument.

ComputePearson(String)

Returns the Pearson product moment correlation coefficient.

Declaration
public string ComputePearson(string range)
Parameters
Type Name Description
System.String range

range1, range2
Returns
Type Description
System.String

Pearson product

ComputePercentile(String)

Returns the percentile position in the range.

Declaration
public string ComputePercentile(string range)
Parameters
Type Name Description
System.String range

Range, k.
Returns
Type Description
System.String

Percentile position.
Remarks

K is a value between 0 and 1.

ComputePercentileExc(String)

Returns the percentile position in the range.

Declaration
public string ComputePercentileExc(string range)
Parameters
Type Name Description
System.String range

Range, k.
Returns
Type Description
System.String

Percentile position.
Remarks

K is a value between 0 and 1.

ComputePercentileInc(String)

Declaration
public string ComputePercentileInc(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputePercentrank(String)

Returns the percentage rank in the range.

Declaration
public string ComputePercentrank(string range)
Parameters
Type Name Description
System.String range

Range, x, signifcant digits.
Returns
Type Description
System.String

Percentile position.
Remarks

Signifcant digits are optional, defaulting to 3.

ComputePercentrankExc(String)

Declaration
public string ComputePercentrankExc(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputePercentrankInc(String)

Returns the percentage rank Inc in the range.

Declaration
public string ComputePercentrankInc(string range)
Parameters
Type Name Description
System.String range

Range, x, significant digits.
Returns
Type Description
System.String

Percentile position.
Remarks

Significant digits are optional, defaulting to 3.

ComputePermut(String)

The number of permutations of n items taken k at the time.

Declaration
public string ComputePermut(string argList)
Parameters
Type Name Description
System.String argList

N, k
Returns
Type Description
System.String

The number of combinations.

ComputePermutationA(String)

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

Declaration
public string ComputePermutationA(string argList)
Parameters
Type Name Description
System.String argList

n, k
Returns
Type Description
System.String

The number of combinations.

ComputePI(String)

Returns the number pi.

Declaration
public string ComputePI(string args)
Parameters
Type Name Description
System.String args

Ignored. Can be empty.
Returns
Type Description
System.String

A string holding the number pi.

ComputePmt(String)

Computes the payment for a loan.

Declaration
public string ComputePmt(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, number of periods, present value, future value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

Payment amount.

ComputePoisson(String)

Returns the Poisson distribution.

Declaration
public string ComputePoisson(string argList)
Parameters
Type Name Description
System.String argList

X, mean, cumulative.
Returns
Type Description
System.String

Returns the exponential distribution.
Remarks

Cumulative should be either True if you want to return the value of the distribution function or False if you want to return the value of the density function.

ComputePoissonODist(String)

Declaration
public string ComputePoissonODist(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputePow(String)

Returns a specified number raised to the specified power.

Declaration
public string ComputePow(string args)
Parameters
Type Name Description
System.String args

String containing two parameters separated by commas: the first being base number, the second being the exponent.
Returns
Type Description
System.String

A string holding the value of the base number raised to the exponent.

ComputePpmt(String)

Computes the principal payment for a period.

Declaration
public string ComputePpmt(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, the period, number of periods, present value, future value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

Principal payment.

ComputeProb(String)

Returns the probability that a value in the given range occurs.

Declaration
public string ComputeProb(string range)
Parameters
Type Name Description
System.String range

Xrange1, prange2, lowerbound, upperbound.
Returns
Type Description
System.String

The probability.

ComputeProduct(String)

Returns the product of the arguments in the list.

Declaration
public string ComputeProduct(string range)
Parameters
Type Name Description
System.String range

List of arguments.
Returns
Type Description
System.String

Product of the arguments.

ComputeProduct(String, Boolean)

Declaration
public string ComputeProduct(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeProper(String)

Declaration
public string ComputeProper(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputePv(String)

Computes the present value of an investment.

Declaration
public string ComputePv(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the rate as percentage per period, number of periods, payment per period, future value, and payment type (0 = end of period, 1 = start of period).
Returns
Type Description
System.String

Present value.

ComputeQuartile(String)

Returns the quartile position in the range.

Declaration
public string ComputeQuartile(string range)
Parameters
Type Name Description
System.String range

Range, q.
Returns
Type Description
System.String

Percentile position.
Remarks

Q is 0, 1, 2, 3, 4.

ComputeQuartileOExc(String)

Declaration
public string ComputeQuartileOExc(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.String

ComputeQuartileOInc(String)

Returns the quartile position in the range.

Declaration
public string ComputeQuartileOInc(string range)
Parameters
Type Name Description
System.String range

Range, q.
Returns
Type Description
System.String

Percentile position.
Remarks

Q is 0, 1, 2, 3, 4.

ComputeQuotient(String)

Declaration
public string ComputeQuotient(string argsList)
Parameters
Type Name Description
System.String argsList
Returns
Type Description
System.String

ComputeRadians(String)

Converts degrees into radians.

Declaration
public string ComputeRadians(string args)
Parameters
Type Name Description
System.String args

Value in degrees.
Returns
Type Description
System.String

Radians.

ComputeRand(String)

Returns an evenly distributed random number greater than or equal zero and less than one.

Declaration
public string ComputeRand(string args)
Parameters
Type Name Description
System.String args

Ignored. Can be empty.
Returns
Type Description
System.String

A string holding the random number.

ComputeRank(String)

Returns the rank of x in the range.

Declaration
public string ComputeRank(string range)
Parameters
Type Name Description
System.String range

X, range, order.
Returns
Type Description
System.String

Rank.

ComputeRankOAvg(String)

Returns the rank of x in the range.

Declaration
public string ComputeRankOAvg(string range)
Parameters
Type Name Description
System.String range

X, range, order.
Returns
Type Description
System.String

Rank of x.

ComputeRankOEq(String)

Returns the rank of x in the range.

Declaration
public string ComputeRankOEq(string range)
Parameters
Type Name Description
System.String range

X, range, order.
Returns
Type Description
System.String

Rank of x.

ComputeRate(String)

Computes the internal rate of return of a series of cash flows.

Declaration
public string ComputeRate(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing a range of cells and an initial guess.
Returns
Type Description
System.String

Internal rate of return.
Remarks

This IRR calculation uses Newton's method to approximate a root of f(r) = Sum( values[i]/(1+r)^i) = 0 where the Sum index is i = 1 to the number of values. The algorithm returns a value if the relative difference between root approximations is less than 1e-7. It fails if this accuracy is not attained in 20 iterations.

ComputeReal(String)

Declaration
public string ComputeReal(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeReceived(String)

Returns the amount received at maturity for a fully invested security.

Declaration
public string ComputeReceived(string args)
Parameters
Type Name Description
System.String args

Number and the number of digits
Returns
Type Description
System.String

Received amount

ComputeReplace(String)

Replace the part of the text with a new text from orginal text

Declaration
public string ComputeReplace(string argList)
Parameters
Type Name Description
System.String argList

Text,Start index, Number of char to replace, new text
Returns
Type Description
System.String

replaced string

ComputeRept(String)

Declaration
public string ComputeRept(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeRight(String)

Returns the right so many characters in the given string.

Declaration
public string ComputeRight(string range)
Parameters
Type Name Description
System.String range

Contains the string and the number of characters.
Returns
Type Description
System.String

A string.

ComputeRightB(String)

Returns the right so many characters in the given string.

Declaration
public string ComputeRightB(string range)
Parameters
Type Name Description
System.String range

Contains the string and the number of characters.
Returns
Type Description
System.String

A right substring.

ComputeRoman(String)

Declaration
public string ComputeRoman(string argsList)
Parameters
Type Name Description
System.String argsList
Returns
Type Description
System.String

ComputeRound(String)

Rounds a number to a specified number of digits.

Declaration
public string ComputeRound(string argList)
Parameters
Type Name Description
System.String argList

Number and number of digits.
Returns
Type Description
System.String

Rounded number.

ComputeRounddown(String)

Rounds a number to a specified number of digits.

Declaration
public string ComputeRounddown(string argList)
Parameters
Type Name Description
System.String argList

Number and number of digits.
Returns
Type Description
System.String

Rounded number.

ComputeRoundup(String)

Rounds a number to a specified number of digits.

Declaration
public string ComputeRoundup(string argList)
Parameters
Type Name Description
System.String argList

Number and number of digits.
Returns
Type Description
System.String

Rounded number.

ComputeRow(String)

Returns the row index of the passed in cell reference.

Declaration
public string ComputeRow(string arg)
Parameters
Type Name Description
System.String arg

Contains zero or one argument. If no argument is passed, returns the row index of the location of this Row function cell, otherwise returns the row index of the passed in cell reference.
Returns
Type Description
System.String

The row index.
Remarks

This method doesn't return an array of row numbers as the array formula entry is not supported in engine. It is another usecase of this library function.

ComputeRows(String)

Declaration
public string ComputeRows(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeROWS(String)

Declaration
public string ComputeROWS(string arg)
Parameters
Type Name Description
System.String arg
Returns
Type Description
System.String

ComputeRRI(String)

Declaration
public string ComputeRRI(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeRsq(String)

Returns the square of the Pearson product moment correlation coefficient.

Declaration
public string ComputeRsq(string range)
Parameters
Type Name Description
System.String range

Range1, range2.
Returns
Type Description
System.String

Square of the Pearson product.

ComputeSearchB(String)

Returns the number of the starting position of the first string from the second string.

Declaration
public string ComputeSearchB(string argList)
Parameters
Type Name Description
System.String argList

first strring, second string and starting position
Returns
Type Description
System.String

index of the string

ComputeSecant(String)

Declaration
public string ComputeSecant(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeSecanth(String)

Returns the hyperbolic secant of an angle.

Declaration
public string ComputeSecanth(string argList)
Parameters
Type Name Description
System.String argList

A cell reference, or number
Returns
Type Description
System.String

A string containing the hyperbolic secant of an angle.

ComputeSecond(String)

Returns the second of the given time.

Declaration
public string ComputeSecond(string argList)
Parameters
Type Name Description
System.String argList

Given time.
Returns
Type Description
System.String

Second.

ComputeSHEET(String)

Declaration
public string ComputeSHEET(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeSHEETS(String)

Declaration
public string ComputeSHEETS(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeSign(String)

Returns a number indicating the sign of the argument.

Declaration
public string ComputeSign(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding a number representing the sign of the argument.

ComputeSin(String)

Computes the sine of the argument.

Declaration
public string ComputeSin(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the sine of the argument.

ComputeSinh(String)

Computes the hyperbolic sine of the argument.

Declaration
public string ComputeSinh(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the hyperbolic sine of the argument.

ComputeSkew(String)

Returns the skewness of a distribution.

Declaration
public string ComputeSkew(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

Skewness of a distribution.

ComputeSkewP(String)

Returns the skewness of a distribution based on a population a characterization of the degree of asymmetry of a distribution around its mean.

Declaration
public string ComputeSkewP(string range)
Parameters
Type Name Description
System.String range

numbers or names, arrays, or reference that contain numbers
Returns
Type Description
System.String

Skewness of a distribution.

ComputeSln(String)

Computes the straight-line depreciation of an asset per period.

Declaration
public string ComputeSln(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the cost, salvage value, and life.
Returns
Type Description
System.String

Depreciation.

ComputeSlope(String)

Returns the slope of the least square fit line through the given points.

Declaration
public string ComputeSlope(string range)
Parameters
Type Name Description
System.String range

Y_range, x_range.
Returns
Type Description
System.String

y-intercept.

ComputeSmall(String)

Returns the kth smallest value in the range.

Declaration
public string ComputeSmall(string range)
Parameters
Type Name Description
System.String range

Range, k.
Returns
Type Description
System.String

Kth smallest value.

ComputeSqrt(String)

Computes the square root of the argument.

Declaration
public string ComputeSqrt(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the square root of the argument.

ComputeSqrtpi(String)

Declaration
public string ComputeSqrtpi(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeStandardize(String)

Returns a normalized value.

Declaration
public string ComputeStandardize(string argList)
Parameters
Type Name Description
System.String argList

X, mean, stddev.
Returns
Type Description
System.String

Normalized value.

ComputeStdev(String)

Returns the sample standard deviation.

Declaration
public string ComputeStdev(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample standard deviation.

ComputeStdev(String, Boolean)

Declaration
public string ComputeStdev(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeStdeva(String)

Returns the sample standard deviation.

Declaration
public string ComputeStdeva(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample standard deviation.
Remarks

Treats True as 1 and False as 0.

ComputeStdevaP(String)

Returns the sample standard deviation.

Declaration
public string ComputeStdevaP(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample standard deviation.
Remarks

Treats True as 1; False as 0.

ComputeStdevaS(String)

Returns the sample standard deviation.

Declaration
public string ComputeStdevaS(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample standard deviation.
Remarks

Treats True as 1; False as 0.

ComputeStdevp(String)

Returns the population standard deviation.

Declaration
public string ComputeStdevp(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The population standard deviation.

ComputeStdevp(String, Boolean)

Declaration
public string ComputeStdevp(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeStdevpa(String)

Returns the population standard deviation.

Declaration
public string ComputeStdevpa(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The population standard deviation.
Remarks

Treats True as 1 and False as 0.

ComputeSteyx(String)

Returns the standard error of the least square fit line through the given points.

Declaration
public string ComputeSteyx(string range)
Parameters
Type Name Description
System.String range

Y_range, x_range.
Returns
Type Description
System.String

Standard error.

ComputeSubstitute(String)

In a given string, this method substitutes an occurrence of one string with another string.

Declaration
public string ComputeSubstitute(string range)
Parameters
Type Name Description
System.String range

A list of 3 or 4 arguments: the original string, the search string, the replacement string, and optionally, an integer representing the occurrence to be replaced.
Returns
Type Description
System.String

The modified string.

ComputeSubTotal(String)

Returns the subtotal of input range(s).

Declaration
public string ComputeSubTotal(string args)
Parameters
Type Name Description
System.String args

A list of cell references(seperated by commas) with Number to Indicate the function
Returns
Type Description
System.String

A string holding result of the Specified Function. (i.e)Subtotal of range(s)

ComputeSum(String)

Returns the sum of all values listed in the argument.

Declaration
public string ComputeSum(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the sum of all values listed in the argument.

ComputeSum(String, Boolean)

Declaration
public string ComputeSum(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeSumIf(String)

Computes the sum of range2 if the item in the range1 satisfies the condition.

Declaration
public string ComputeSumIf(string range)
Parameters
Type Name Description
System.String range

Range1, condition, range2.
Returns
Type Description
System.String

The conditional sum.

ComputeSumIfS(String)

Computes the Sum of Range1 If the item in range2 satisfies condition in range3 and item in range4 satisfies Condition in range5 etc..

Declaration
public string ComputeSumIfS(string range)
Parameters
Type Name Description
System.String range

Contains Sumrange,Criteriarange1,Criteria1 etc..
Returns
Type Description
System.String

The Conditional Sum of Range

ComputeSumProduct(String)

Returns the sum of the products of corresponding values.

Declaration
public string ComputeSumProduct(string range)
Parameters
Type Name Description
System.String range

Two cell ranges.
Returns
Type Description
System.String

Sum of the products.

ComputeSumsq(String)

Returns the sum of the square of all values listed in the argument.

Declaration
public string ComputeSumsq(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

A string holding the sum of the squares of all values listed in the argument.

ComputeSumx2my2(String)

Returns the sum of the differences of squares of the two ranges.

Declaration
public string ComputeSumx2my2(string range)
Parameters
Type Name Description
System.String range

x_range and y_range.
Returns
Type Description
System.String

A string holding sum of the differences of squares.

ComputeSumx2py2(String)

Returns the sum of the sums of squares of the two ranges.

Declaration
public string ComputeSumx2py2(string range)
Parameters
Type Name Description
System.String range

x_range and y_range.
Returns
Type Description
System.String

A string holding sum of the sums of squares.

ComputeSumxmy2(String)

Returns the sum of the squares of the differences between two ranges.

Declaration
public string ComputeSumxmy2(string range)
Parameters
Type Name Description
System.String range

x_range and y_range.
Returns
Type Description
System.String

A string holding sum of the squares of the differences.

ComputeSyd(String)

Computes the sum of years digits depreciation of an asset per period.

Declaration
public string ComputeSyd(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the cost, salvage value, life, and period.
Returns
Type Description
System.String

Depreciation for the requested period.

ComputeT(String)

Declaration
public string ComputeT(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.String

ComputeTan(String)

Computes the tangent the argument.

Declaration
public string ComputeTan(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the tangent of the argument.

ComputeTanh(String)

Computes the hyperbolic tangent of the argument.

Declaration
public string ComputeTanh(string args)
Parameters
Type Name Description
System.String args

A cell reference, formula, or number.
Returns
Type Description
System.String

A string holding the hyperbolic tangent of the argument.

ComputeText(String)

Returns a quoted string from a date or number.

Declaration
public string ComputeText(string range)
Parameters
Type Name Description
System.String range

Value to be converted to a string.
Returns
Type Description
System.String

Quoted string.

ComputeTime(String)

Returns a fraction of a day.

Declaration
public string ComputeTime(string argList)
Parameters
Type Name Description
System.String argList

Hour, minute, and second.
Returns
Type Description
System.String

Fraction of a day.

ComputeTimevalue(String)

Returns a fraction of a day.

Declaration
public string ComputeTimevalue(string argList)
Parameters
Type Name Description
System.String argList

Time as a text string.
Returns
Type Description
System.String

Fraction of a day.

ComputeToday(String)

Returns the current date as a date serial number.

Declaration
public string ComputeToday(string argList)
Parameters
Type Name Description
System.String argList

Ignored.
Returns
Type Description
System.String

Current date as date serial number.

ComputeTOInv(String)

Returns the Student's t-distribution.

Declaration
public string ComputeTOInv(string argList)
Parameters
Type Name Description
System.String argList

x, degreesfreedom1.
Returns
Type Description
System.String

Returns the Student's t-distribution.

ComputeTranspose(String)

Returns the vertical range of cells as a horizontal range, or vice versa

Declaration
public string ComputeTranspose(string arg)
Parameters
Type Name Description
System.String arg

Cell refrences
Returns
Type Description
System.String

value

ComputeTrim(String)

Removes all leading and trailing white-space characters.

Declaration
public string ComputeTrim(string args)
Parameters
Type Name Description
System.String args

Value to trim.
Returns
Type Description
System.String

The string that remains after all leading and trailing white-space characters were removed.

ComputeTrimmean(String)

Returns the mean of the range after removing points on either extreme.

Declaration
public string ComputeTrimmean(string range)
Parameters
Type Name Description
System.String range

Range, percent.
Returns
Type Description
System.String

Kth smallest value.

ComputeTrue(String)

Returns the logical value True.

Declaration
public string ComputeTrue(string empty)
Parameters
Type Name Description
System.String empty
Returns
Type Description
System.String

Logical True value string.

ComputeTrunc(String)

Truncates a number to an integer.

Declaration
public string ComputeTrunc(string range)
Parameters
Type Name Description
System.String range

Value and number of digits.
Returns
Type Description
System.String

Truncated value.

ComputeTruncate(String)

Declaration
public string ComputeTruncate(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeType(String)

Returns the interger value for the datatype of given text

Declaration
public string ComputeType(string argList)
Parameters
Type Name Description
System.String argList

text
Returns
Type Description
System.String

integer value

ComputeUniChar(String)

Declaration
public string ComputeUniChar(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeUniCode(String)

Declaration
public string ComputeUniCode(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeUnidist(String)

Returns the PDF of the uniform distribution.

Declaration
public string ComputeUnidist(string argList)
Parameters
Type Name Description
System.String argList

Number of successes, number of trials, probability, cumulative.
Returns
Type Description
System.String

The binomial distribution.

ComputeUpper(String)

Converts text to uppercase.

Declaration
public string ComputeUpper(string args)
Parameters
Type Name Description
System.String args

Value to convert.
Returns
Type Description
System.String

Converted string.

ComputeValue(String)

Returns a number.

Declaration
public string ComputeValue(string range)
Parameters
Type Name Description
System.String range

A date or number string.
Returns
Type Description
System.String

A number.

ComputeVar(String)

Returns sample variance of the listed values.

Declaration
public string ComputeVar(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample variance.

ComputeVar(String, Boolean)

Declaration
public string ComputeVar(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeVara(String)

Returns sample variance of the listed values.

Declaration
public string ComputeVara(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample variance.
Remarks

True is treated as 1 and False is treated as 0.

ComputeVarp(String)

Returns population variance of the listed values.

Declaration
public string ComputeVarp(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The population variance.

ComputeVarp(String, Boolean)

Declaration
public string ComputeVarp(string range, bool calculateHiddenRange)
Parameters
Type Name Description
System.String range
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

ComputeVarpa(String)

Returns population variance of the listed values.

Declaration
public string ComputeVarpa(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of: cell references, formulas, or numbers.
Returns
Type Description
System.String

The population variance.
Remarks

True is treated as 1 and False is treated as 0.

ComputeVarPAdv(String)

Returns sample variance of the listed values.

Declaration
public string ComputeVarPAdv(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample variance.

ComputeVarSAdv(String)

Calculates variance based on the entire population (ignores logical values and text in the population).

Declaration
public string ComputeVarSAdv(string range)
Parameters
Type Name Description
System.String range

A string holding a list (separated by commas) of cell references, formulas, or numbers.
Returns
Type Description
System.String

The sample variance.

ComputeVdb(String)

Computes the variable declining balance of an asset

Declaration
public string ComputeVdb(string argList)
Parameters
Type Name Description
System.String argList

Delimited string containing the initial cost, salvage value, life of asset, period of calculation, factor.
Returns
Type Description
System.String

Variable declining balance.

ComputeVLookUp(String)

Returns a vertical table look up value.

Declaration
public string ComputeVLookUp(string range)
Parameters
Type Name Description
System.String range

Contains search value, table, return index and match properties.
Returns
Type Description
System.String

Matching value found in the table.
Remarks

For example, =VLOOKUP("Axles",A1:C4,2,TRUE) looks for the exact match for Axles in A1:A4 and returns the corresponding value in B1:B4.

ComputeWebService(String)

Return the XML content of the given document

Declaration
public string ComputeWebService(string argList)
Parameters
Type Name Description
System.String argList

web link
Returns
Type Description
System.String

XML data

ComputeWeekday(String)

Day of the week.

Declaration
public string ComputeWeekday(string argList)
Parameters
Type Name Description
System.String argList

Serial number date1 and return_type.
Returns
Type Description
System.String

Days between the dates.

ComputeWeeknum(String)

Declaration
public string ComputeWeeknum(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeWeibull(String)

Returns the Weibull distribution.

Declaration
public string ComputeWeibull(string argList)
Parameters
Type Name Description
System.String argList

X, alpha, beta, cumulative.
Returns
Type Description
System.String

Returns the Weibull distribution.

ComputeWeiBullODist(String)

Declaration
public string ComputeWeiBullODist(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeWorkDay(String)

returns the date of the given date after the number of working days

Declaration
public string ComputeWorkDay(string argList)
Parameters
Type Name Description
System.String argList

startDate, days, holidays (optional)
Returns
Type Description
System.String

returns the date

ComputeWorkDayintl(String)

Declaration
public string ComputeWorkDayintl(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ComputeXirr(String)

Computes the internal rate of return of a series of cash flows.

Declaration
public string ComputeXirr(string argList)
Parameters
Type Name Description
System.String argList

values, dates, guess. Values and dates are ranges of cells holding the values and dates. Guess is the initial guess. The first date is the the start date for the calculation.
Returns
Type Description
System.String

Internal rate of return.
Remarks

This XIRR calculation is similar to IRR except that the values are not equally spaced in time. The algorithm returns a value if the relative difference between root approximations is less than 1e-5. It fails if this accuracy is not attained in 20 iterations.

ComputeYear(String)

Returns the year of the given date.

Declaration
public string ComputeYear(string argList)
Parameters
Type Name Description
System.String argList

Given date.
Returns
Type Description
System.String

Month.

ComputeYearFrac(String)

returns the fraction of the year represented by the number of whole days between two given dates

Declaration
public string ComputeYearFrac(string argList)
Parameters
Type Name Description
System.String argList

startDate, endDate, basis (optional)
Returns
Type Description
System.String

returns the fraction of the year

ComputeZOtest(String)

Returns the one-tailed probability value of a Z test.

Declaration
public string ComputeZOtest(string range)
Parameters
Type Name Description
System.String range

Range, mu, sigma.
Returns
Type Description
System.String

Kth smallest value.

ComputeZtest(String)

Returns the one-tailed probability value of a Z test.

Declaration
public string ComputeZtest(string range)
Parameters
Type Name Description
System.String range

Range, mu, sigma.
Returns
Type Description
System.String

Kth smallest value.

CreateSheetFamilyID()

Returns an integer that is used to identify a family of grids.

Declaration
public static int CreateSheetFamilyID()
Returns
Type Description
System.Int32

Sheet family id.
Remarks

Essential Grid supports multisheet references within a family of grids. To use this functionality, you employ the method to get a unique identifier for the family. Then in the RegisterGridAsSheet method that you call to add grids to this family, you pass this unique identifier to mark the grids as belonging to this family. You can only cross reference grids within the same family.

Delta(String)

Compares the given two values

Declaration
public string Delta(string argList)
Parameters
Type Name Description
System.String argList

Two Numbers to be compared.
Returns
Type Description
System.String

Returns the result of the comparision in the form of 0 or 1

Dispose(Boolean)

Declaration
protected override void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing
Overrides

Factorial(Int32)

Returns n! 0! = 1,otherwise n! = n * (n-1) * (n-2) * ... * 2 * 1,

Declaration
public static long Factorial(int n)
Parameters
Type Name Description
System.Int32 n
Returns
Type Description
System.Int64

Gestep(String)

Compares the given two values

Declaration
public string Gestep(string argList)
Parameters
Type Name Description
System.String argList

Two Numbers to be compared.
Returns
Type Description
System.String

Returns the result of the comparision in the form of 0 or 1

GetCellsFromArgs(String)

Accepts an argument string and returns a string array of cells.

Declaration
public string[] GetCellsFromArgs(string args)
Parameters
Type Name Description
System.String args

String containing a cell range.
Returns
Type Description
System.String[]

String array of cells.
Remarks

Converts arguments in these forms to a string array of individual cells.

A1,A2,B4,C1,...,D8

A1:A5

A1:C5

GetDataFromArgs(String)

Declaration
public DataTable GetDataFromArgs(string args)
Parameters
Type Name Description
System.String args
Returns
Type Description
System.Data.DataTable

GetSheetFamilyItem(GridModel)

Returns the GridSheetFamilyItem for the specified model. If there was no item registered for the model, a new item is created and cached.

Declaration
public static GridSheetFamilyItem GetSheetFamilyItem(GridModel model)
Parameters
Type Name Description
GridModel model

The grid model.
Returns
Type Description
GridSheetFamilyItem

The GridSheetFamilyItem for the specified model.

GetStringArray(String)

Returns an array of strings from an argument list.

Declaration
public string[] GetStringArray(string s)
Parameters
Type Name Description
System.String s

A delimited argument list.
Returns
Type Description
System.String[]

Array of strings from an argument list.

GetValueFromArg(String)

Computes the value contained in the argument.

Declaration
public string GetValueFromArg(string arg)
Parameters
Type Name Description
System.String arg

A parsed formula, raw number, or cell reference.
Returns
Type Description
System.String

A string with the computed number in it.
Remarks

This method takes the argument and checks whether it is a parsed formula, raw number, or cell reference like A21. The return value is a string that holds the computed value of the passed-in argument.

GetValueFromArg(String, Boolean)

Computes the value contained in the argument.

Declaration
public string GetValueFromArg(string arg, bool calculateHiddenRange)
Parameters
Type Name Description
System.String arg

A parsed formula, raw number, or cell reference.
System.Boolean calculateHiddenRange
Returns
Type Description
System.String

A string with the arg value in it.
Remarks

This method takes the argument and checks whether it is a parsed formula, raw number, or cell reference like A21. The return value is a string that holds the computed value of the passed-in argument.

GetValueFromGrid(Int32, Int32)

Conditionally gets either the formula value or the cell value depending upon whether the requested cell is a FormulaCell.

Declaration
public string GetValueFromGrid(int row, int col)
Parameters
Type Name Description
System.Int32 row

Row index of the requested cell.
System.Int32 col

Column index of the requested cell.
Returns
Type Description
System.String

String holding either the cell value or the computed formula value.

GetValueFromGrid(String)

Conditionally gets either the formula value or the cell value depending upon whether the requested cell is a FormulaCell.

Declaration
public string GetValueFromGrid(string cell1)
Parameters
Type Name Description
System.String cell1

The alphanumeric cell label, like A1, or EE14.
Returns
Type Description
System.String

String holding either the cell value or the computed formula value.

GetVisibility(String)

Returns the visibility of the range from the Model.

Declaration
public bool GetVisibility(string range)
Parameters
Type Name Description
System.String range
Returns
Type Description
System.Boolean

If the range is visible returns True otherwise returns False

IHProbDens(Double, Int32)

The Irwin-Hall distribution results from the sum on n independent standard uniform variables

Declaration
public static double IHProbDens(double x, int n)
Parameters
Type Name Description
System.Double x

The value at which to evaluate the distribution.
System.Int32 n

The number of standard uniform variables.
Returns
Type Description
System.Double

ImConjugate(String)

Returns the complex conjugate of a complex number in x + yi or x + yj text format.

Declaration
public string ImConjugate(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The complex conjugate of a complex number in x + yi or x + yj text format.

IMCSC(String)

Declaration
public string IMCSC(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

IMLOG10(String)

Returns the LOG10 value of the given Complex Number.

Declaration
public string IMLOG10(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Number
Returns
Type Description
System.String

The Log10 of the given Complex Number.

IMLOG2(String)

Declaration
public string IMLOG2(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

ImProduct(String)

Computes the Product of the given Complex Numbers

Declaration
public string ImProduct(string argList)
Parameters
Type Name Description
System.String argList

Input Complex Numbers
Returns
Type Description
System.String

The multiplied result of the two complex numbers.

IMSEC(String)

Declaration
public string IMSEC(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

IMSecH(String)

Declaration
public string IMSecH(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

IMTan(String)

Declaration
public string IMTan(string argList)
Parameters
Type Name Description
System.String argList
Returns
Type Description
System.String

InitLibraryFunctions()

Creates and initially loads the Function Library with the supported functions.

Declaration
public virtual void InitLibraryFunctions()

InverseSumOfGeometricSeries(Double, Int32)

Returns the inverse of the sum of a geometric series of length n, who's first element is 1. For decay factor d, S = 1 + d + d^2 + ... + d^(n-1). Return 1/S.

Declaration
public static double InverseSumOfGeometricSeries(double decayFactor, int length)
Parameters
Type Name Description
System.Double decayFactor

Decay factor Typically between -1 adn +1.
System.Int32 length

Number of elements in the geometric series, must be positive.
Returns
Type Description
System.Double

IsCircularReference(String, String)

Determines whether the given formula at the given cell will cause a circular reference.

Declaration
public bool IsCircularReference(string cell, string formula)
Parameters
Type Name Description
System.String cell

The alphanumeric cell label, like A1, or EE14.
System.String formula

The formula to be tested.
Returns
Type Description
System.Boolean

True if the given formula causes a circular reference, false otherwise.

IsDirty(GridFormulaTag)

Returns whether or not the calculation for this GridFormulaTag is current or not.

Declaration
public bool IsDirty(GridFormulaTag tag)
Parameters
Type Name Description
GridFormulaTag tag

The GridFormulaTag to be tested.
Returns
Type Description
System.Boolean

Returns true if the tag has been computed with the most recent values, false otherwise.

IsFormulaValid(String)

Checks if the given string holds a valid formula.

Declaration
public bool IsFormulaValid(string text)
Parameters
Type Name Description
System.String text

String to be tested.
Returns
Type Description
System.Boolean

True if string holds a valid formula, false otherwise.

IsFormulaValid(String, out String, out String, out String)

Checks if given string holds a valid formula.

Declaration
public bool IsFormulaValid(string text, out string parsedFormula, out string errorMessage, out string computedValue)
Parameters
Type Name Description
System.String text

String to be tested.
System.String parsedFormula

Tokenized string holding holding valid parsed formula.
System.String errorMessage

Error message from the grid if string is invalid.
System.String computedValue

Computed value from parsed formula.
Returns
Type Description
System.Boolean

True if string holds a valid formula, false otherwise.

IsSeparatorInTIC(String)

Returns True if the ParseArgumentSeparator character is included in a string.

Declaration
public bool IsSeparatorInTIC(string s)
Parameters
Type Name Description
System.String s

The string to be searched.
Returns
Type Description
System.Boolean

True or False.

j0(String)

Returns the Bessel function of order 0 of the specified number.

Declaration
public static double j0(string x)
Parameters
Type Name Description
System.String x
Returns
Type Description
System.Double

j1(String)

Declaration
public static double j1(string x)
Parameters
Type Name Description
System.String x
Returns
Type Description
System.Double

Mean(Double[])

Returns the mean of an array.

Declaration
public double Mean(double[] array)
Parameters
Type Name Description
System.Double[] array

Array of data for which we are calculating the mean.
Returns
Type Description
System.Double

Mean(Double[], Double)

Returns the mean of an array.

Declaration
public static double Mean(double[] array, double decayFactor)
Parameters
Type Name Description
System.Double[] array

Array of data for which we are calculating the mean. For time series, the last element (index = n-1), is the most recent.
System.Double decayFactor

In most applications, the decay factor is between 0 and 1. Weigth on the last element in array is 1.0, the 2nd to last element d, 3rd to last d^2, ...
Returns
Type Description
System.Double

Parse(String)

Parses a formula string into a tokenized string.

Declaration
public string Parse(string text)
Parameters
Type Name Description
System.String text

The string to be parsed.
Returns
Type Description
System.String

The parsed string.
Remarks

This method accepts a string that holds a formula, like =Sum(A1:B5), and translates this string into a tokenized expression that can be computed using the ComputedValue method. Before calling the method, you should set FormulaContextCell to properly reflect which cell owns this formula. The return value, which is the tokenized string, is referred to as a parsed formula string.

RecalculateRange(GridRangeInfo)

Recalculates any formula cells in the specified range.

Declaration
public void RecalculateRange(GridRangeInfo range)
Parameters
Type Name Description
GridRangeInfo range

GridRangeInfo object that specifies the cells to be recalculated.
Remarks

The calculations for non-visible formula cells are performed the next time cell are actually displayed. If you want the calculation performed immediately on cells (visible or not), call the two argument overload of RecalculateRange, passing the forceCalculations argument as True.

RecalculateRange(GridRangeInfo, GridModel, Boolean, Boolean)

Recalculates any formula cells in the specified range.

Declaration
public void RecalculateRange(GridRangeInfo range, GridModel grd, bool forceCalculations, bool forceParsing)
Parameters
Type Name Description
GridRangeInfo range

GridRangInfo object that specifies the cells to be recalculated.
GridModel grd

The GridModel object where the range to be updated is located.
System.Boolean forceCalculations

Determines whether the calculations on non-visible cells are performed immediately or delayed until the next time the cell is drawn. For visible cells, the calculations are done immediately.
System.Boolean forceParsing

When forceParsing is False, a formula is only re-parsed if FormulaTag is NULL, or FormulaTag.Formula is empty. Otherwise, the existing parsed formula in FormulaTag.Formula is used to perform the calculation. The value of forceParsing only affects the Engine if forceCalculations is True.
Remarks

This method does not do anything if CalculatingSuspended is True.

RecalculateRange(GridRangeInfo, Boolean)

Recalculates any formula cells in the specified range.

Declaration
public void RecalculateRange(GridRangeInfo range, bool forceCalculations)
Parameters
Type Name Description
GridRangeInfo range

GridRangeInfo object that specifies the cells to be recalculated.
System.Boolean forceCalculations

Determines whether the calculations on non-visible cells are performed immediately or delayed until the next time the cell is drawn. For visible cells, the calculations are done immediately.

RecalculateRange(GridRangeInfo, Boolean, Boolean)

Recalculates any formula cells in the specified range.

Declaration
public void RecalculateRange(GridRangeInfo range, bool forceCalculations, bool forceParsing)
Parameters
Type Name Description
GridRangeInfo range

GridRangeInfo object that specifies the cells to be recalculated.
System.Boolean forceCalculations

Determines whether the calculations on non-visible cells are performed immediately or delayed until the next time the cell is drawn. For visible cells, the calculations are done immediately.
System.Boolean forceParsing

When forceParsing is False, a formula is only re-parsed if FormulaTag is NULL, or FormulaTag.Formula is empty. Otherwise, the existing parsed formula in FormulaTag.Formula is used to perform the calculation. The value of forceParsing only affects the Engine if forceCalculations is True.
Remarks

This method does not do anything if CalculatingSuspended is true.

Refresh(String)

Recalculates any cell that depends upon the passed in cell.

Declaration
public void Refresh(string s)
Parameters
Type Name Description
System.String s

A cell such as A21 or EE31.

RefreshRange(GridRangeInfo)

Recalculates every cell that depends upon any cell in the passed-in range.

Declaration
public void RefreshRange(GridRangeInfo range)
Parameters
Type Name Description
GridRangeInfo range

GridRangeInfo object to be refreshed.
Remarks

For example, if range is GridRangeInfo(1,1,2,2), and cells (5,6) and (12,17) hold formulas that reference the cells in the range, then cells (5,6) and (12,17) will be re-computed as the result of this call.

RegisterGridAsSheet(String, GridModel, Int32)

Registers a grid so it can be referenced in a formula from another grid.

Declaration
public static void RegisterGridAsSheet(string refName, GridModel model, int sheetFamilyID)
Parameters
Type Name Description
System.String refName

The reference name used to refer to this grid from formulas in other grids.
GridModel model

The GridModel from the grid being registered.
System.Int32 sheetFamilyID

An integer previously created with a call to GridFormulaEngine.CreateSheetFamilyID. This number is used to identify the grids as belonging to a particular family of grids. You can only reference grids from within the same family.
Remarks

Essential Grid supports multisheet references with its formulas. For example, if you have two tabpages with a GridControl on each, you can reference cells from the first in the second grid. For this to work, both grids need to be registered using this method.

The syntax for using a sheet reference as part of a formula is to prefix a cell reference with the sheet reference name followed by an exclamation point.

The formula "= sheet1!A1 + sheet2!C3" would add the value of cell A1 for the grid whose reference name is sheet1 to the value from cell C3 in the grid whose reference name is sheet2.

Examples

Use this code to use cross sheet references.

	//Register 3 grids so cell can be referenced across grids.
	int sheetfamilyID = GridFormulaEngine.CreateSheetFamilyID();
	GridFormulaEngine.RegisterGridAsSheet("summary", this.gridControl1.Model, sheetfamilyID);
	GridFormulaEngine.RegisterGridAsSheet("income", this.gridControl2.Model, sheetfamilyID);
	GridFormulaEngine.RegisterGridAsSheet("expenses", this.gridControl3.Model, sheetfamilyID);
	....
	//Sample formula usage for cells in gridControl1, the 'summary' grid.
	//This code sums up some cells from gridControl3, the 'expenses' grid, 
	//and gridControl2, the 'income' grid.

	//Sum the range B2:B8 from the expenses grid.
	this.gridControl1.Model[3,4].Text = "= Sum(expenses!B2:expenses!B8)";

	//Sum the range B2:B4 from the income grid.
	this.gridControl1.Model[4,4].Text = "= Sum(income!B2:income!B4)";
	'Register 3 grids so cells can be referenced across grids.
	Dim sheetfamilyID As Integer = GridFormulaEngine.CreateSheetFamilyID();
	GridFormulaEngine.RegisterGridAsSheet("summary", Me.gridControl1.Model, sheetfamilyID)
	GridFormulaEngine.RegisterGridAsSheet("income", Me.gridControl2.Model, sheetfamilyID) 
	GridFormulaEngine.RegisterGridAsSheet("expenses", Me.gridControl3.Model, sheetfamilyID) 
	....
	'Sample formula usage for cells in gridControl1, the 'summary' grid.
	'This code sums ups some cells from gridControl3, the 'expenses' grid, 
	'and gridControl2, the 'income' grid.

	'Sum the range B2:B8 from the expenses grid.
	Me.gridControl1(3,4).Text = "= Sum(expenses!B2:expenses!B8)"

	'Sum the range B2:B4 from the income grid.
	Me.gridControl1(4,4).Text = "= Sum(income!B2:income!B4)"

RemoveFunction(String)

Removes a function from the Function Library.

Declaration
public bool RemoveFunction(string name)
Parameters
Type Name Description
System.String name

The name of the function to be removed.
Returns
Type Description
System.Boolean

True if successfully removed, False otherwise.

RemoveNamedRange(String)

Removes a range from the namedranges collection.

Declaration
public bool RemoveNamedRange(string name)
Parameters
Type Name Description
System.String name

The name of the range to be removed.
Returns
Type Description
System.Boolean

True is successfully remove, False otherwise.

RemoveNamedRangeDependency(String)

Removes entries in the DependentNamedRangeCells collection for the given named range.

Declaration
public void RemoveNamedRangeDependency(string key)
Parameters
Type Name Description
System.String key

The named range.

ResetTokenCount()

Reset the sheet token count.

Declaration
public static void ResetTokenCount()
Remarks

While registering the grid as sheet in GridFormulaEngine, each time the TokenCount incremented. So you can use this method reset the TokenCount to 0.

RowIndex(String)

Returns the row index from a cell reference.

Declaration
public int RowIndex(string s)
Parameters
Type Name Description
System.String s

String holding a cell reference such as C21 or AB11.
Returns
Type Description
System.Int32

An integer with the corresponding row number.

SetDirty(GridFormulaTag)

Marks the underlying formula as dirty, indicating it needs to be recomputed. It does this by setting the Text property to null.

Declaration
public void SetDirty(GridFormulaTag tag)
Parameters
Type Name Description
GridFormulaTag tag

The GridFormulaTag to be marked as not computed.

SetNamedRangeDependency(String, String)

Adds a cell to the DependentNamedRangeCells list.

Declaration
public void SetNamedRangeDependency(string key, string cell1)
Parameters
Type Name Description
System.String key

The named range.
System.String cell1

The cell (such as C11 or AJ232).

SplitArgsPreservingQuotedCommas(String)

Returns an array of argument strings from a single string where the arguments are delimited by .

Declaration
public string[] SplitArgsPreservingQuotedCommas(string args)
Parameters
Type Name Description
System.String args

Contains the argument list.
Returns
Type Description
System.String[]

A string array of arguments.
Remarks

This method properly preserves any quoted strings that contain the character.

StandardNormalCumulativeDistribution(Double)

Declaration
public double StandardNormalCumulativeDistribution(double x)
Parameters
Type Name Description
System.Double x
Returns
Type Description
System.Double

StandardNormalCumulativeDistributionFunction(Double)

Returns the CDF of the standard normal distribution.

Declaration
public double StandardNormalCumulativeDistributionFunction(double x)
Parameters
Type Name Description
System.Double x

Value at which the distribution is evaluated.
Returns
Type Description
System.Double

StandardNormalCumulativeDistributionFunctionInverse(Double)

Returns the inverse of the CDF of the standard normal distribution.

Declaration
public double StandardNormalCumulativeDistributionFunctionInverse(double p)
Parameters
Type Name Description
System.Double p

Cumulative probability of the distribution. p is between 0 and 1.
Returns
Type Description
System.Double

StandardNormalProbabilityDensity(Double)

Returns the PDF of the standard normal distribution.

Declaration
public double StandardNormalProbabilityDensity(double x)
Parameters
Type Name Description
System.Double x

Value at which the distribution is evaluated.
Returns
Type Description
System.Double

ToString()

Displays information on the cell currently being calculated.

Declaration
public override string ToString()
Returns
Type Description
System.String

String with information on the cell currently being calculated.
Overrides
System.Object.ToString()

TranslateText(String, String)

Declaration
public string TranslateText(string input, string languagePair)
Parameters
Type Name Description
System.String input
System.String languagePair
Returns
Type Description
System.String

UniProbDens(Double, Double, Double)

Declaration
public static double UniProbDens(double x, double min, double max)
Parameters
Type Name Description
System.Double x
System.Double min
System.Double max
Returns
Type Description
System.Double

UnregisterGridAsSheet(String, GridModel)

Unregisters a grid so it can no longer be referenced in a formula from another grid.

Declaration
public static void UnregisterGridAsSheet(string refName, GridModel model)
Parameters
Type Name Description
System.String refName

The reference name used to refer to this grid from formulas in other grids.
GridModel model

The grid model.

UpdateDependentNamedRangeCell(String)

Updates all cells that depend upon the given named range.

Declaration
public void UpdateDependentNamedRangeCell(string key)
Parameters
Type Name Description
System.String key

The named range whose cells should be updated.

y0(Double)

Returns the Bessel function of the second kind, of order 0 of the specified number.

Declaration
public static double y0(double x)
Parameters
Type Name Description
System.Double x
Returns
Type Description
System.Double

y1(Double)

Returns the Bessel function of the second kind, of order 1 of the specified number.

Declaration
public static double y1(double x)
Parameters
Type Name Description
System.Double x
Returns
Type Description
System.Double

Events

FormulaParsing

Occurs whenever a string needs to be tested to determine whether it should be treated as a formula string and parsed, or be treated as a non-formula string. This event allows for preprocessing the unparsed formula.

Declaration
public event GridFormulaParsingEventHandler FormulaParsing
Event Type
Type Description
GridFormulaParsingEventHandler
Remarks

This event may be raised more than once in the processing of a string into a formula.

QueryDependentCellValue

Declaration
public event GridQueryDependentCellValueEventHandler QueryDependentCellValue
Event Type
Type Description
GridQueryDependentCellValueEventHandler

Implements

System.IDisposable

Extension Methods