GrapeCity.CalcEngine.IReferenceSource.GetValue

GetValue Method

GetValue(IEvaluationContext, int, int, IPrimitiveValue)

Gets the value at the specified location of the 2-dimensions matrix.

Declaration

void GetValue(IEvaluationContext context, int row, int column, IPrimitiveValue result)

Sub GetValue(context As IEvaluationContext, row As Integer, column As Integer, result As IPrimitiveValue)

Parameters

Type	Name	Description
IEvaluationContext	context	An GrapeCity.CalcEngine.EvaluationContext object indicates the evaluation context.
int	row	An integer value indicates the row index of the 2-dimensions matrix.
int	column	An integer value indicates the column index of the 2-dimensions matrix.
IPrimitiveValue	result	An IPrimitiveValue object represents the value at the specified location.

GetValue(IEvaluationContext, int, int, int, int, IValuesArray, bool)

Gets the values at the specified range of the 2-dimensions matrix.

Declaration

void GetValue(IEvaluationContext context, int row, int column, int row2, int column2, IValuesArray result, bool keepEmptyValue = false)

Sub GetValue(context As IEvaluationContext, row As Integer, column As Integer, row2 As Integer, column2 As Integer, result As IValuesArray, Optional keepEmptyValue As Boolean = False)

Parameters

Type	Name	Description
IEvaluationContext	context	An GrapeCity.CalcEngine.EvaluationContext object indicates the evaluation context.
int	row	An integer value indicates the top row index of the 2-dimensions matrix.
int	column	An integer value indicates the left column index of the 2-dimensions matrix.
int	row2	An integer value indicates the bottom row index of the 2-dimensions matrix.
int	column2	An integer value indicates the right column index of the 2-dimensions matrix.
IValuesArray	result	An IPrimitiveValue object represents the values at the specified range.
bool	keepEmptyValue	Boolean value represents keeping empty values as empty or not.

GetValue(IEvaluationContext, int, int, int, int, CellValue[], int)

Gets the values at the specified range of the 2-dimensions matrix.

Declaration

void GetValue(IEvaluationContext context, int row, int column, int row2, int column2, CellValue[] result, int index = 0)

Sub GetValue(context As IEvaluationContext, row As Integer, column As Integer, row2 As Integer, column2 As Integer, result As CellValue(), Optional index As Integer = 0)

Parameters

Type	Name	Description
IEvaluationContext	context	An GrapeCity.CalcEngine.EvaluationContext object indicates the evaluation context.
int	row	An integer value indicates the top row index of the 2-dimensions matrix.
int	column	An integer value indicates the left column index of the 2-dimensions matrix.
int	row2	An integer value indicates the bottom row index of the 2-dimensions matrix.
int	column2	An integer value indicates the right column index of the 2-dimensions matrix.
CellValue[]	result	An CellValue array represents the values at the specified range.
int	index	The start item index to write data.

GetValue(IEvaluationContext, int, int, ref CellValue)

Gets the value at the specified location of the 2-dimensions matrix.

Declaration

void GetValue(IEvaluationContext context, int row, int column, ref CellValue result)

Sub GetValue(context As IEvaluationContext, row As Integer, column As Integer, ByRef result As CellValue)

Parameters

Type	Name	Description
IEvaluationContext	context	An GrapeCity.CalcEngine.EvaluationContext object indicates the evaluation context.
int	row	An integer value indicates the row index of the 2-dimensions matrix.
int	column	An integer value indicates the column index of the 2-dimensions matrix.
CellValue	result	An CellValue object represents the value at the specified location.

GetValue Method