CellValidateInfoNeeded Event

Occurs when cell validate infomation is needed.

Syntax

Visual Basic
C#

'Declaration
 
Public Event CellValidateInfoNeeded As EventHandler(Of CellValidateInfoNeededEventArgs)

'Usage
 
Dim instance As FpSpread
Dim handler As EventHandler(Of CellValidateInfoNeededEventArgs)
 
AddHandler instance.CellValidateInfoNeeded, handler

public event EventHandler<CellValidateInfoNeededEventArgs> CellValidateInfoNeeded

Event Data

The event handler receives an argument of type CellValidateInfoNeededEventArgs containing data related to this event. The following CellValidateInfoNeededEventArgs properties provide information specific to this event.

Property	Description
CellValidator	Gets the cell validator.
IsValid	Gets whether this validation is valid.
ValidateContext	Gets the validate context.

Example

This example uses the CellValidateInfoNeeded event.

//Type a value equal to or less than 10 to see the red line
FarPoint.Win.Spread.LineNotify linen = new FarPoint.Win.Spread.LineNotify();
linen.LineColor = Color.Red;
linen.DoActionReason = FarPoint.Win.Spread.ValidateReasons.EndEdit;
FarPoint.Win.Spread.CompareCellValidator compare = new FarPoint.Win.Spread.CompareCellValidator();
compare.ComparedOperator = FarPoint.Win.Spread.ValidateComparisonOperator.GreaterThan;
compare.Row = 0;
compare.Column = 0;
compare.Actions.Add(linen);
fpSpread1.Sheets[0].AddValidators(new FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), compare);
fpSpread1.Sheets[0].Cells[0, 0].Value = 10;

private void fpSpread1_CellValidateInfoNeeded(object sender, FarPoint.Win.Spread.CellValidateInfoNeededEventArgs e)
  {
      listBox1.Items.Add(e.IsValid);
      listBox1.Items.Add(e.ValidateContext.ValidateReasons);
  }

Visual Basic

'Type a value equal to or less than 10 to see the red line
Dim linen As New FarPoint.Win.Spread.LineNotify()
linen.LineColor = Color.Red
linen.DoActionReason = FarPoint.Win.Spread.ValidateReasons.EndEdit
Dim compare As New FarPoint.Win.Spread.CompareCellValidator()
compare.ComparedOperator = FarPoint.Win.Spread.ValidateComparisonOperator.GreaterThan
compare.Row = 0
compare.Column = 0
compare.Actions.Add(linen)
FpSpread1.Sheets(0).AddValidators(New FarPoint.Win.Spread.Model.CellRange(1, 1, 1, 1), compare)
FpSpread1.Sheets(0).Cells(0, 0).Value = 10

Private Sub FpSpread1_CellValidateInfoNeeded(sender As Object, e As FarPoint.Win.Spread.CellValidateInfoNeededEventArgs) Handles FpSpread1.CellValidateInfoNeeded
  ListBox1.Items.Add(e.IsValid)
  ListBox1.Items.Add(e.ValidateContext.ValidateReasons)
End Sub

Reference

FpSpread Class
FpSpread Members

Product Support Forum | Print this page