Static
$tStatic
nextReturns whether this class instance contains an array value.
[[toArrayProxy]]
Returns whether this class instance contains a group of array values.
[[toArrayProxyGroup]]
Returns whether this class instance contains a boolean value
Returns whether this class instance contains a DBNull value
Returns whether this class instance contains a DateTime value
Returns whether this class instance contains an error value
Returns whether this class instance contains a null value
Returns whether this class instance contains a [[IExcelCalcReference]] value
Returns whether this class instance contains a string value
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.
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.
[[ExcelCalcValue]] to compare against.
Convert this class instance's value to an [[ArrayProxy]] data type.
[[ArrayProxy]]
Convert this class instance's value to an array group data type.
[[ArrayProxy]]
Convert this class instance's value to a boolean data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a boolean data type
[[toBoolean]]
Convert this class instance's value to a byte data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a byte data type
[[toByte]]
Convert this class instance's value to a char type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a char data type
[[toChar]]
Convert this class instance's value to a DateTime data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a DateTime data type
[[toDateTime]]
Convert this class instance's value to a decimal data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a decimal data type
Convert this class instance's value to a double data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a double data type
[[toDouble]]
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 returnedConvert this class instance's value to an int
Convert this class instance's value to an int
If there is no meaningful conversion to an integer this method will throw an InvalidCastException
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
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a short data type
[[toInt16]]
Convert this class instance's value to a int data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a int data type
[[toInt32]]
Convert this class instance's value to a long data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a long data type
[[toInt64]]
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 InvalidCastExceptionConvert this class instance's value to a float data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Convert this class instance's value to a float data type
[[toSingle]]
Convert this class instance's value to a string instance data type
If there is no meaningful conversion, this method will throw an InvalidCastException
An IFormatProvider interface implementation that supplies culture-specific formatting information
Static
areIndicates if the value of the specified [[ExcelCalcValue]] is equivalent to the [[value]]
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.
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.