Static $tStatic nextReturns whether this class instance contains an array value.
True if this instance class contains an array, else false.
Returns whether this class instance contains a group of array values.
True if this instance class contains an array group, else false.
Returns whether this class instance contains a boolean value
True if this instance class contains a boolean, else false
Returns whether this class instance contains a DBNull value
True if this instance class contains a null value, else false
Returns whether this class instance contains a DateTime value
True if this instance class contains a DateTime, else false
Returns whether this class instance contains an error value
True if this class instance contains an error, else false
Returns whether this class instance contains a null value
True if this instance class contains a null value, else false
Returns whether this class instance contains a IExcelCalcReference value
True if this instance class contains a reference, else false
Returns whether this class instance contains a string value
True if this instance class contains a string, else false
Return the underlying value
Compares current instance with the passed in ExcelCalcValue instance. Returns -1, 1 or 0 depending on whether the current instance is less than, greater than or equal to the passed in instance respectively.
-1, 1 or 0 depending on whether the current instance is less than, greater than or equal to the passed in instance respectively.
The object that this instance should be compared against.
Gets the resolved value of the reference. This method will walk down the reference chain recursively to get the resolved value of the reference that is not just another reference.
Gets the resolved value of the reference. This method will walk down the reference chain recursively to get the resolved value of the reference that is not just another reference.
True if the value returned will actually be used in calculations; False if the value is being requested to inspect some aspect of it, such as its type.
Indicates if the specified ExcelCalcValue has the save value as this instance.
True if the value of both instances are equal; otherwise false.
ExcelCalcValue to compare against.
Convert this class instance's value to an ArrayProxy data type.
An array equivalent to the value of this instance.
Convert this class instance's value to an array group data type.
An array group equivalent to the value of this instance.
Convert this class instance's value to a boolean data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A boolean floating-point equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a boolean data type
A boolean floating-point equivalent to the value of this instance
Convert this class instance's value to a byte data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A 8-bit unsigned integer equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a char type
If there is no meaningful conversion, this method will throw an InvalidCastException
A Unicode character equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a char data type
A Unicode character equivalent to the value of this instance
Convert this class instance's value to a DateTime data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A DateTime equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a decimal data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A Decimal equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a decimal data type
A Decimal equivalent to the value of this instance
Convert this class instance's value to a double data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A double-precision floating-point equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this instance's value to an ExcelCalcErrorValue
This method returns an ExcelCalcErrorValue whose error code is set this instance's error code.
If there this instance does not contain an error, a ExcelCalcErrorValue containing a default value is returnedA ExcelCalcErrorValue containing the equivalent error code to the value of this instance
Convert this class instance's value to an int
A signed 32-bit integer value containing the equivalent value of this instance
Convert this class instance's value to an int
If there is no meaningful conversion to an integer this method will throw an InvalidCastException
A signed 32-bit integer value containing the equivalent value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a short data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A 16-bit signed integer floating-point equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a int data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A 32-bit signed integer floating-point equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a int data type
A 32-bit signed integer floating-point equivalent to the value of this instance
Convert this class instance's value to a long data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A 64-bit signed integer equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this instance's value to a IExcelCalcReference.
The instance value's underlying data type must be reference to return a reference, else an error reference is returned.
If there is no meaningful conversion to a reference, this method will throw an InvalidCastExceptionIf this instance contains a object that implements the IExcelCalcReference interface, this method returns the object instance, else an error reference is returned.
Convert this class instance's value to a float data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A single-precision floating-point equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a string instance data type
If there is no meaningful conversion, this method will throw an InvalidCastException
A string instance equivalent to the value of this instance
An IFormatProvider interface implementation that supplies culture-specific formatting information
Static areIndicates if the value of the specified ExcelCalcValue is equivalent to the value
True if the values are the same; otherwise false is returned.
First ExcelCalcValue to compare
Second ExcelCalcValue to compare
Static compareStatic compareStatic compareCompares x and y ExcelCalcValue instances and returns -1 if x is less than y, 1 if x is greater than y and 0 if x and y are equal.
-1, 1 or 0 depending on whether the current instance is less than, greater than or equal to the passed in instance respectively.
The first value to compare.
The value to compare with the first value.
Static dateConverts a DateTime to Excel's numerical representation of a date.
When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. This overload assumes the 1900 date system is being used as so it corrects the date values.
The DateTime value to convert to the Microsoft Excel date format.
Converts a DateTime to Excel's numerical representation of a date.
The DateTime value to convert to the Microsoft Excel date format.
When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. Pass False to disable this correction.
Static equalsStatic equalsStatic excelConverts Excel's numerical representation of a date to a DateTime.
When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. This overload assumes the 1900 date system is being used as so it corrects the date values.
The Microsoft Excel date format which should be converted to a DateTime.
Converts Excel's numerical representation of a date to a DateTime.
The Microsoft Excel date format which should be converted to a DateTime.
When using the 1900 date system in Excel, dates before 3/1/1900 must be corrected, because Excel incorrectly assumes 1900 is a leap year. Pass False to disable this correction.
Static getStatic getStatic getStatic reference
Provides methods that manage a composite data type representing a value.
An instance of this class may contain one of several base data types including doubles, singles, integers, booleans, strings, and error values.
The class implements the IConvertible interface providing methods to perform conversions between the basic data types. Additionally the class provides methods to perform basic arithmetic operations and comparisons between ExcelCalcValue objects.