CreateFormulaListValidator Method

Creates a validator based on a formula list.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function CreateFormulaListValidator( _
   ByVal formula As String _
) As DataValidator

'Usage
 
Dim formula As String
Dim value As DataValidator
 
value = DataValidator.CreateFormulaListValidator(formula)

public static DataValidator CreateFormulaListValidator( 
   string formula
)

Parameters

formula: The formula condition.

Return Value

Returns a new validator.

Example

This example uses the CreateFormulaListValidator method.

C#
VB.NET

gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 5;
gcSpreadSheet1.Sheets[0].Cells[1, 2].Value = 4;
gcSpreadSheet1.Sheets[0].Cells[2, 2].Value = 5;
gcSpreadSheet1.HighlightInvalidData = true;
var valid = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateFormulaListValidator("$C$1:$C$3"); 
gcSpreadSheet1.Sheets[0].Cells[0, 1].DataValidator = valid;
gcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Formulas";

<Page.Resources>
        <Style TargetType="UI:InvalidDataPresenter">
            <Setter Property="Template">
                <Setter.Value>
                    <ControlTemplate TargetType="UI:InvalidDataPresenter">
                        <Grid Background="{TemplateBinding Background}">
                            <Ellipse Stroke="Orange"
                                 StrokeThickness="2"
                                 Margin="-6,-3,-6,-3"
                                 />
                        </Grid>
                    </ControlTemplate>
                </Setter.Value>
            </Setter>
        </Style>
    </Page.Resources>

GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 5
GcSpreadSheet1.Sheets(0).Cells(1, 2).Value = 4
GcSpreadSheet1.Sheets(0).Cells(2, 2).Value = 5
GcSpreadSheet1.HighlightInvalidData = True
Dim valid = GrapeCity.Xaml.SpreadSheet.Data.DataValidator.CreateFormulaListValidator("$C$1:$C$3")
GcSpreadSheet1.Sheets(0).Cells(0, 1).DataValidator = valid
GcSpreadSheet1.Sheets(0).Cells(0, 0).Text = "Formulas"

<Page.Resources>
        <Style TargetType="UI:InvalidDataPresenter">
            <Setter Property="Template">
                <Setter.Value>
                    <ControlTemplate TargetType="UI:InvalidDataPresenter">
                        <Grid Background="{TemplateBinding Background}">
                            <Ellipse Stroke="Orange"
                                 StrokeThickness="2"
                                 Margin="-6,-3,-6,-3"
                                 />
                        </Grid>
                    </ControlTemplate>
                </Setter.Value>
            </Setter>
        </Style>
    </Page.Resources>

Requirements

Target Platforms: Windows Server 2012, Windows RT

Reference

DataValidator Class
DataValidator Members