Evaluate メソッド (GcSpreadGrid)

Visual Basic
C#

'宣言
 
Public Function Evaluate( _
   ByVal formula As String, _
   Optional ByVal baseRow As Integer, _
   Optional ByVal baseColumn As Integer, _
   Optional ByVal culture As CultureInfo, _
   Optional ByVal referenceStyle As Nullable(Of ReferenceStyle) _
) As Object

public object Evaluate( 
   string formula,
   int baseRow,
   int baseColumn,
   CultureInfo culture,
   Nullable<ReferenceStyle> referenceStyle
)

パラメータ

formula: 評価する数式。
baseRow: 基になる行。
baseColumn: 基になる列。
culture: カルチャ。
referenceStyle: 参照スタイル。

次のサンプルはActiveCellプロパティの使用方法を説明します。

C#
Visual Basic

public void Formula1()
{
GcSpreadGrid gcSpread1 = new GcSpreadGrid();
gcSpread1[0, 0].Value = 1;
gcSpread1[0, 1].Value = 2;
gcSpread1[1, 0].Value = 3;
gcSpread1[1, 1].Value = 4;
object result1 = gcSpread1.Evaluate("(1+2)/3");
object result2 = gcSpread1.Evaluate("SUM(A1:A2)-AVERAGE(B1:B2)");
object result3 = gcSpread1.Evaluate("SUM(R[-2]C[-2]:R[-1]C[-1])", 2, 2, null, ReferenceStyle.R1C1);
// The value of result1, result2 and result3 are:
// 1
// -0.5
// 10
}

Public Sub Formula1()
Dim gcSpread1 As New GcSpreadGrid()
gcSpread1(0, 0).Value = 1
gcSpread1(0, 1).Value = 2
gcSpread1(1, 0).Value = 3
gcSpread1(1, 1).Value = 4
Dim result1 As Object = gcSpread1.Evaluate("(1+2)/3")
Dim result2 As Object = gcSpread1.Evaluate("SUM(A1:A2)-AVERAGE(B1:B2)")
Dim result3 As Object = gcSpread1.Evaluate("SUM(R[-2]C[-2]:R[-1]C[-1])", 2, 2, Nothing, ReferenceStyle.R1C1)
' The value of result1, result2 and result3 are:
' 1
' -0.5
' 10
End Sub

GcSpreadGrid クラス
 GcSpreadGrid メンバ