Value プロパティ (SummaryValue)

この集計おける計算結果を返します。

シンタックス

Visual Basic

'宣言
 
Public ReadOnly Property Value As Object

C#

public object Value {get;}

解説

Value プロパティは、この集計で計算された集計値を返します。返されるオブジェクトのタイプは、実行される計算のタイプによって異なります。たとえば、Minimum または Maximum 集計計算は、値で変換を実行せずに最小または最大のセル値を返します。Sum または Average 集計タイプでは 10 進数インスタンスになり、Count 集計タイプでは整数となります。

SummaryText プロパティを使用して、集計で表示される時にテキストを取得できます。

使用例

Visual Basic

Imports Infragistics.Shared
Imports Infragistics.Win
Imports Infragistics.Win.UltraWinGrid

  Private Sub UltraGrid1_SummaryValueChanged(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs) Handles ultraGrid1.SummaryValueChanged

      ' Use the key to identify what summary the SummaryValue object is associated with
      ' and set appearance properties accordingly.

      If e.SummaryValue.Key = "Max" Then
          If CType(e.SummaryValue.Value, Decimal) < 20 Then
              ' If the max is less than han 40, then highlight the summary with red color
              ' by setting the back color to red
              e.SummaryValue.Appearance.BackColor = Color.LightYellow
          Else
              e.SummaryValue.Appearance.BackColor = Color.SkyBlue
          End If
      End If

      If e.SummaryValue.Key = "Avg" Then
          If CType(e.SummaryValue.Value, Decimal) > 20 Then
              ' If the sum is greater than 20, then highlight the summary with red color
              ' by setting the back color to red
              e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue
          Else
              e.SummaryValue.Appearance.BackColor = Color.LightYellow
          End If
      End If

  End Sub

C#

using Infragistics.Shared;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Diagnostics;

private void ultraGrid1_SummaryValueChanged(object sender, Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs e)
{

	// Use the key to identify what summary the SummaryValue object is associated with
	// and set appearance properties accordingly.

	if ( e.SummaryValue.Key == "Max" )
	{	
		if ( (decimal)e.SummaryValue.Value < 20 )
		{
			// If the max is less than han 40, then highlight the summary with red color
			// by setting the back color to red
			e.SummaryValue.Appearance.BackColor = Color.LightYellow;
		}
		else 
		{
			e.SummaryValue.Appearance.BackColor = Color.SkyBlue;
		}
	}

	if ( e.SummaryValue.Key == "Avg" )
	{	
		if ( (decimal)e.SummaryValue.Value > 20 )
		{
			// If the sum is greater than 20, then highlight the summary with red color
			// by setting the back color to red
			e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue;
		}
		else 
		{
			e.SummaryValue.Appearance.BackColor = Color.LightYellow;
		}
	}

}