Spread Windows Forms 8.0 Product Documentation
RemoveViewport(Int32,Int32,Int32) Method
Example 


Sheet index
Viewport row index
Viewport column index
Removes a row or column of viewports.
Syntax
'Declaration
 
Public Overloads Sub RemoveViewport( _
   ByVal sheetIndex As Integer, _
   ByVal rowViewportIndex As Integer, _
   ByVal columnViewportIndex As Integer _
) 
'Usage
 
Dim instance As SpreadView
Dim sheetIndex As Integer
Dim rowViewportIndex As Integer
Dim columnViewportIndex As Integer
 
instance.RemoveViewport(sheetIndex, rowViewportIndex, columnViewportIndex)
public void RemoveViewport( 
   int sheetIndex,
   int rowViewportIndex,
   int columnViewportIndex
)

Parameters

sheetIndex
Sheet index
rowViewportIndex
Viewport row index
columnViewportIndex
Viewport column index
Exceptions
ExceptionDescription
System.ArgumentOutOfRangeException Specified sheet index is not valid; must be between zero and the number of sheets.
Remarks

The viewport column and viewport row indexes are zero-based, so the first (leftmost) viewport column and first (top) viewport row both have indexes of 0.

You must remove an entire viewport row or viewport column; you cannot remove an individual viewport.

Use both indexes to remove both a viewport row and viewport column at the same time.

Use -1 for the index if you do not want to remove a set of viewports in that orientation. For example,  RemoveViewport(0, -1, 3) only removes a viewport column (the fourth viewport column), but no viewport row is removed.

Example
This example uses the RemoveViewport method.
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.RemoveViewport(0, 0,0)
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.RemoveViewport(0, 0, 0)
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

Reference

SpreadView Class
SpreadView Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.