Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.DrawingSpace Namespace / SpreadCameraShape Class / Formula Property
Example


In This Topic
    Formula Property (SpreadCameraShape)
    In This Topic
    Gets or sets a string formula that indicates the captured region.
    Syntax
    'Declaration
     
    Public Property Formula As String
    'Usage
     
    Dim instance As SpreadCameraShape
    Dim value As String
     
    instance.Formula = value
     
    value = instance.Formula
    public string Formula {get; set;}
    Example
    This example creates a shape using the Formula property.
    fpSpread1.Sheets[0].Cells[0,0].Text = "test";
    FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape test = new FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape();
    test.Formula = "A1:A5";
    fpSpread1.Sheets[0].AddShape(test, 2, 1);
    fpSpread1.Sheets(0).Cells(0,0).Text = "test"
    Dim test As New FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape()
    test.Formula = "A1:A5"
    fpSpread1.Sheets(0).AddShape(test, 2, 1)
    See Also