Spread Windows Forms 7.0 Product Documentation
SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions,Boolean,Boolean,Boolean) Method
See Also  Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > SetClipSpecial Method : SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions,Boolean,Boolean,Boolean) Method


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

Glossary Item Box

Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.

Syntax

Visual Basic (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 _
) 
Visual Basic (Usage)Copy Code
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)
C# 
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 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.