FarPoint.Win.Spread.Model.ISheetAxisModel isam;
private void Form1_Load(object sender, System.EventArgs e)
{
isam = fpSpread1.ActiveSheet.Models.ColumnAxis;
this.isam.Changed += new FarPoint.Win.Spread.Model.SheetAxisModelEventHandler(this.isam_Changed);
}
private void menuItem1_Click(object sender, System.EventArgs e)
{
isam = fpSpread1.ActiveSheet.Models.ColumnAxis;
isam.SetSize(0, 240);
}
private void isam_Changed(object sender, FarPoint.Win.Spread.Model.SheetAxisModelEventArgs e)
{
switch (e.Type)
{
case FarPoint.Win.Spread.Model.SheetAxisModelEventType.LayoutItemsUpdated:
listBox1.Items.Add(e.Type.ToString());
break;
case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ItemsAdded:
listBox1.Items.Add(e.Type.ToString());
break;
case FarPoint.Win.Spread.Model.SheetAxisModelEventType.AppearanceItemsUpdated:
listBox1.Items.Add(e.Type.ToString());
break;
case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ItemsRemoved:
listBox1.Items.Add(e.Type.ToString());
break;
case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ModelUpdated:
listBox1.Items.Add(e.Type.ToString());
break;
}
}
Friend WithEvents isam As FarPoint.Win.Spread.Model.ISheetAxisModel
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
isam = FpSpread1.ActiveSheet.Models.ColumnAxis
isam.SetSize(0, 240)
End Sub
Private Sub isam_Changed(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.Model.SheetAxisModelEventArgs) Handles isam.Changed
Select Case e.Type
Case FarPoint.Win.Spread.Model.SheetAxisModelEventType.LayoutItemsUpdated
ListBox1.Items.Add(e.Type.ToString())
Case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ItemsAdded
ListBox1.Items.Add(e.Type.ToString())
Case FarPoint.Win.Spread.Model.SheetAxisModelEventType.AppearanceItemsUpdated
ListBox1.Items.Add(e.Type.ToString())
Case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ItemsRemoved
ListBox1.Items.Add(e.Type.ToString())
Case FarPoint.Win.Spread.Model.SheetAxisModelEventType.ModelUpdated
ListBox1.Items.Add(e.Type.ToString())
End Select
End Sub