MESCIUS SPREAD for ASP.NET 10.0J
Validators プロパティ (BaseCellType)

バリデーターコレクションを取得します。
構文
'Declaration
 
Public Overridable ReadOnly Property Validators As ValidatorCollection
public virtual ValidatorCollection Validators {get;}
次のサンプルコードは、セルのバリデーターを指定します。
// Add this section to the ASPX page
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator>
<asp:CompareValidator ID="CompareValidator1" runat="server" ErrorMessage="CompareValidator"></asp:CompareValidator>
<asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="RangeValidator"></asp:RangeValidator>

protected void Page_Load(object sender, System.EventArgs e)
{
    if (IsPostBack) return;
    FpSpread1.Sheets[0].RowCount = 10;
    FpSpread1.Sheets[0].ColumnCount = 7;
    // RequiredFieldValidator, from code
    FarPoint.Web.Spread.TextCellType txt1 = new FarPoint.Web.Spread.TextCellType();
    RequiredFieldValidator rfv = new RequiredFieldValidator();
    rfv.ErrorMessage = "RequiredFieldValidator, from code: value required!";
    txt1.Validators.Add(rfv);
    FpSpread1.ActiveSheetView.Cells[0, 0].Text = "RequiredFieldValidator, from code";
    FpSpread1.ActiveSheetView.Cells[0, 1].CellType = txt1;
    
    // RequiredFieldValidator, from toolbox
    FarPoint.Web.Spread.TextCellType txt2 = new FarPoint.Web.Spread.TextCellType();
    RequiredFieldValidator1.ErrorMessage = "RequiredFieldValidator, from toolbox: value required!";
    txt2.Validators.Add(RequiredFieldValidator1);
    FpSpread1.ActiveSheetView.Cells[1, 0].Text = "RequiredFieldValidator, from toolbox";
    FpSpread1.ActiveSheetView.Cells[1, 1].CellType = txt2;
    
    // CompareValidator, from toolbox
    FarPoint.Web.Spread.TextCellType txt3 = new FarPoint.Web.Spread.TextCellType();
    CompareValidator1.ErrorMessage = "CompareValidator, from toolbox: password does not match! Enter \"Spread\"";
    CompareValidator1.ValueToCompare = "Spread";
    txt3.Validators.Add(CompareValidator1);
    FpSpread1.ActiveSheetView.Cells[2, 0].Text = "CompareValidator, from toolbox";
    FpSpread1.ActiveSheetView.Cells[2, 1].CellType = txt3;
    
    // CompareValidator, from code
    FarPoint.Web.Spread.TextCellType txt4 = new FarPoint.Web.Spread.TextCellType();
    CompareValidator cv = new CompareValidator();
    cv.ErrorMessage = "CompareValidator, from toolbox: password does not match! Enter \"Spread\"";
    cv.ValueToCompare = "Spread";
    txt4.Validators.Add(cv);
    FpSpread1.ActiveSheetView.Cells[3, 0].Text = "CompareValidator, from code";
    FpSpread1.ActiveSheetView.Cells[3, 1].CellType = txt4;
    
    // RangeValidator, from toolbox
    FarPoint.Web.Spread.TextCellType txt5 = new FarPoint.Web.Spread.TextCellType();
    RangeValidator1.ErrorMessage = "RangeValidator, from toolbox: value should in range [10 - 15]";
    RangeValidator1.MinimumValue = "10"; RangeValidator1.MaximumValue = "15";
    RangeValidator1.Type = ValidationDataType.Integer;
    txt5.Validators.Add(RangeValidator1);
    FpSpread1.ActiveSheetView.Cells[4, 0].Text = "RangeValidator, from toolbox";
    FpSpread1.ActiveSheetView.Cells[4, 1].CellType = txt5;
    
    // RangeValidator, from code
    FarPoint.Web.Spread.TextCellType txt6 = new FarPoint.Web.Spread.TextCellType();
    RangeValidator rv = new RangeValidator();
    rv.ErrorMessage = "RangeValidator, from toolbox: value should in range [10 - 15]";
    rv.MinimumValue = "10"; rv.MaximumValue = "15";
    rv.Type = ValidationDataType.Integer;
    txt6.Validators.Add(rv);
    FpSpread1.ActiveSheetView.Cells[5, 0].Text = "RangeValidator, from toolbox";
    FpSpread1.ActiveSheetView.Cells[5, 1].CellType = txt6;
}
'Add this section to the ASPX page
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator>
<asp:CompareValidator ID="CompareValidator1" runat="server" ErrorMessage="CompareValidator"></asp:CompareValidator>
<asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="RangeValidator"></asp:RangeValidator>


Protected Sub Page_Load(sender As Object, e As System.EventArgs)
    If IsPostBack Then
        Return
    End If
    FpSpread1.Sheets(0).RowCount = 10
    FpSpread1.Sheets(0).ColumnCount = 7
    ' RequiredFieldValidator, from code
    Dim txt1 As New FarPoint.Web.Spread.TextCellType()
    Dim rfv As New RequiredFieldValidator()
    rfv.ErrorMessage = "RequiredFieldValidator, from code: value required!"
    txt1.Validators.Add(rfv)
    FpSpread1.ActiveSheetView.Cells(0, 0).Text = "RequiredFieldValidator, from code"
    FpSpread1.ActiveSheetView.Cells(0, 1).CellType = txt1

    ' RequiredFieldValidator, from toolbox
    Dim txt2 As New FarPoint.Web.Spread.TextCellType()
    RequiredFieldValidator1.ErrorMessage = "RequiredFieldValidator, from toolbox: value required!"
    txt2.Validators.Add(RequiredFieldValidator1)
    FpSpread1.ActiveSheetView.Cells(1, 0).Text = "RequiredFieldValidator, from toolbox"
    FpSpread1.ActiveSheetView.Cells(1, 1).CellType = txt2

    ' CompareValidator, from toolbox
    Dim txt3 As New FarPoint.Web.Spread.TextCellType()
    CompareValidator1.ErrorMessage = "CompareValidator, from toolbox: password does not match! Enter ""Spread"""
    CompareValidator1.ValueToCompare = "Spread"
    txt3.Validators.Add(CompareValidator1)
    FpSpread1.ActiveSheetView.Cells(2, 0).Text = "CompareValidator, from toolbox"
    FpSpread1.ActiveSheetView.Cells(2, 1).CellType = txt3
    
    ' CompareValidator, from code
    Dim txt4 As New FarPoint.Web.Spread.TextCellType()
    Dim cv As New CompareValidator()
    cv.ErrorMessage = "CompareValidator, from toolbox: password does not match! Enter ""Spread"""
    cv.ValueToCompare = "Spread"
    txt4.Validators.Add(cv)
    FpSpread1.ActiveSheetView.Cells(3, 0).Text = "CompareValidator, from code"
    FpSpread1.ActiveSheetView.Cells(3, 1).CellType = txt4
    
    ' RangeValidator, from toolbox
    Dim txt5 As New FarPoint.Web.Spread.TextCellType()
    RangeValidator1.ErrorMessage = "RangeValidator, from toolbox: value should in range [10 - 15]"
    RangeValidator1.MinimumValue = "10"
    RangeValidator1.MaximumValue = "15"
    RangeValidator1.Type = ValidationDataType.[Integer]
    txt5.Validators.Add(RangeValidator1)
    FpSpread1.ActiveSheetView.Cells(4, 0).Text = "RangeValidator, from toolbox"
    FpSpread1.ActiveSheetView.Cells(4, 1).CellType = txt5
    
    ' RangeValidator, from code
    Dim txt6 As New FarPoint.Web.Spread.TextCellType()
    Dim rv As New RangeValidator()
    rv.ErrorMessage = "RangeValidator, from toolbox: value should in range [10 - 15]"
    rv.MinimumValue = "10"
    rv.MaximumValue = "15"
    rv.Type = ValidationDataType.[Integer]
    txt6.Validators.Add(rv)
    FpSpread1.ActiveSheetView.Cells(5, 0).Text = "RangeValidator, from toolbox"
    FpSpread1.ActiveSheetView.Cells(5, 1).CellType = txt6
End Sub
参照

BaseCellType クラス
BaseCellType メンバ

 

 


© MESCIUS inc. All rights reserved.