Returns the sheet given location refers to
Syntax
Visual Basic (Declaration) | |
---|
Public ReadOnly Property Sheet As Integer |
C# | |
---|
public int Sheet {get;} |
Property Value
Integer sheet index
Example
This example returns the sheet location.
C# | Copy Code |
---|
void fpSpread1SheetTabClick(object sender, SheetTabClickEventArgs e)
{
Rectangle r = fpSpread1.GetRootWorkbook().GetTabStripRectangle();
FarPoint.Win.Spread.HitTestInformation hti;
FarPoint.Win.Spread.TabStripHitTestInformation ti;
hti = fpSpread1.HitTest(r.X, r.Y);
ti = hti.TabStripInfo;
if (hti.Type == HitTestType.TabStrip)
{
MessageBox.Show(ti.Sheet.ToString());
}
}
|
Visual Basic | Copy Code |
---|
Private Sub FpSpread1SheetTabClick(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SheetTabClickEventArgs)
Dim r As Rectangle
r = FpSpread1.GetRootWorkbook.GetTabStripRectangle()
Dim hti As FarPoint.Win.Spread.HitTestInformation
Dim ti As FarPoint.Win.Spread.TabStripHitTestInformation
hti = FpSpread1.HitTest(r.X, r.Y)
ti = hti.TabStripInfo
If hti.Type = HitTestType.TabStrip Then
MsgBox(ti.Sheet)
End If |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also