Occurs when the user saves or loads a view state of a sheet.
Syntax
Event Data
The event handler receives an argument of type SheetViewStateEventArgs containing data related to this event. The following SheetViewStateEventArgs properties provide information specific to this event.
| Property | Description |
|---|
| Handled | Gets or sets whether the event has been handled. |
| Index | Gets the index of the collection that contains the sheet. |
| IsSave | Gets whether the state of the sheet is saved. |
| SheetView | Gets the sheet whose state is to be loaded or to be saved. |
Remarks
Example
This example illustrates the use of the event.
| C# |  Copy Code |
|---|
private void FpSpread1SaveOrLoadSheetState(object sender, FarPoint.Web.Spread.SheetViewStateEventArgs e)
{
if (e.IsSave)
{
Session["SheetName" + e.Index] = e.SheetView.SaveViewState();
}
else
{
e.SheetView.LoadViewState(Session["SheetName" + e.Index]);
}
e.Handled = true;
}
|
| Visual Basic | Copy Code |
|---|
Private Sub FpSpread1SaveOrLoadSheetState(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SheetViewStateEventArgs)
Handles FpSpread1.SaveOrLoadSheetState
If (e.IsSave) Then
Session("SheetName" & e.Index) = e.SheetView.SaveViewState()
Else
e.SheetView.LoadViewState(Session("SheetName" & e.Index))
End If
e.Handled = True
End Sub |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
