Formula Property (SpreadCameraShape)

Gets or sets a string formula that indicates the captured region.

Syntax

Visual Basic
C#

'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);

Visual Basic

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)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SpreadCameraShape Class
SpreadCameraShape Members