Spread Windows Forms 7.0 Product Documentation
Formula Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.DrawingSpace Namespace > SpreadCameraShape Class : Formula Property


Glossary Item Box

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

Syntax

Visual Basic (Declaration) 
Public Property Formula As String
Visual Basic (Usage)Copy Code
Dim instance As SpreadCameraShape
Dim value As String
 
instance.Formula = value
 
value = instance.Formula
C# 
public string Formula {get; set;}

Example

This example creates a shape using the Formula property.
C#Copy Code
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 BasicCopy Code
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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.