Spread Windows Forms 10.0 Product Documentation
SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions,Boolean,Boolean,Boolean) Method


Starting row index of the range of cells (or -1 for all rows)
Starting column index of the range of cells (or -1 for all columns)
Number of rows in the range of cells (or -1 for all rows)
Number of columns in the range of cells (or -1 for all columns)
CellInfo object to set into the cells of the specified range
Clipboard paste option that determines what to paste
Whether to include row headers
Whether to include column headers
Whether to include filter bars
Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.
Syntax
'Declaration
 
Public Overloads Sub SetClipSpecial( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal value As Object, _
   ByVal pasteOption As ClipboardPasteOptions, _
   ByVal rowHeader As Boolean, _
   ByVal columnHeader As Boolean, _
   ByVal filterBar As Boolean _
) 
'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim value As Object
Dim pasteOption As ClipboardPasteOptions
Dim rowHeader As Boolean
Dim columnHeader As Boolean
Dim filterBar As Boolean
 
instance.SetClipSpecial(row, column, rowCount, columnCount, value, pasteOption, rowHeader, columnHeader, filterBar)
public void SetClipSpecial( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   object value,
   ClipboardPasteOptions pasteOption,
   bool rowHeader,
   bool columnHeader,
   bool filterBar
)

Parameters

row
Starting row index of the range of cells (or -1 for all rows)
column
Starting column index of the range of cells (or -1 for all columns)
rowCount
Number of rows in the range of cells (or -1 for all rows)
columnCount
Number of columns in the range of cells (or -1 for all columns)
value
CellInfo object to set into the cells of the specified range
pasteOption
Clipboard paste option that determines what to paste
rowHeader
Whether to include row headers
columnHeader
Whether to include column headers
filterBar
Whether to include filter bars
Exceptions
ExceptionDescription
System.ArgumentOutOfRangeException Specified row index is out of range; must be between 0 and the total number of rows
System.ArgumentOutOfRangeException Specified column index is out of range; must be between 0 and the total number of columns
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SheetView Class
SheetView Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.