FarPoint.Win.Spread.SheetView.SetClipSpecial

SetClipSpecial Method

SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions)

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

Declaration

public void SetClipSpecial(int row, int column, int rowCount, int columnCount, object value, ClipboardPasteOptions pasteOption)

Public Sub SetClipSpecial(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, value As Object, pasteOption As ClipboardPasteOptions)

Parameters

Type	Name	Description
int	row	Starting row index of the range of cells (or -1 for all rows)
int	column	Starting column index of the range of cells (or -1 for all columns)
int	rowCount	Number of rows in the range of cells (or -1 for all rows)
int	columnCount	Number of columns in the range of cells (or -1 for all columns)
object	value	CellInfo object to set into the cells of the specified range
ClipboardPasteOptions	pasteOption	Clipboard paste option that determines what to paste

Exceptions

Type	Condition
ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows
ArgumentOutOfRangeException	Specified column index is out of range; must be between 0 and the total number of columns

SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions, bool, bool)

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

Declaration

public void SetClipSpecial(int row, int column, int rowCount, int columnCount, object value, ClipboardPasteOptions pasteOption, bool rowHeader, bool columnHeader)

Public Sub SetClipSpecial(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, value As Object, pasteOption As ClipboardPasteOptions, rowHeader As Boolean, columnHeader As Boolean)

Parameters

Type	Name	Description
int	row	Starting row index of the range of cells (or -1 for all rows)
int	column	Starting column index of the range of cells (or -1 for all columns)
int	rowCount	Number of rows in the range of cells (or -1 for all rows)
int	columnCount	Number of columns in the range of cells (or -1 for all columns)
object	value	CellInfo object to set into the cells of the specified range
ClipboardPasteOptions	pasteOption	Clipboard paste option that determines what to paste
bool	rowHeader	Whether to include row headers
bool	columnHeader	Whether to include column headers

Exceptions

Type	Condition
ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows
ArgumentOutOfRangeException	Specified column index is out of range; must be between 0 and the total number of columns

SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions, bool, bool, bool)

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

Declaration

public void SetClipSpecial(int row, int column, int rowCount, int columnCount, object value, ClipboardPasteOptions pasteOption, bool rowHeader, bool columnHeader, bool filterBar)

Public Sub SetClipSpecial(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, value As Object, pasteOption As ClipboardPasteOptions, rowHeader As Boolean, columnHeader As Boolean, filterBar As Boolean)

Parameters

Type	Name	Description
int	row	Starting row index of the range of cells (or -1 for all rows)
int	column	Starting column index of the range of cells (or -1 for all columns)
int	rowCount	Number of rows in the range of cells (or -1 for all rows)
int	columnCount	Number of columns in the range of cells (or -1 for all columns)
object	value	CellInfo object to set into the cells of the specified range
ClipboardPasteOptions	pasteOption	Clipboard paste option that determines what to paste
bool	rowHeader	Whether to include row headers
bool	columnHeader	Whether to include column headers
bool	filterBar	Whether to include filter bars

Exceptions

Type	Condition
ArgumentOutOfRangeException	Specified row index is out of range; must be between 0 and the total number of rows
ArgumentOutOfRangeException	Specified column index is out of range; must be between 0 and the total number of columns

SetClipSpecial Method
SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions)
Declaration
Parameters
Exceptions
SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions, bool, bool)
Declaration
Parameters
Exceptions
SetClipSpecial(int, int, int, int, object, ClipboardPasteOptions, bool, bool, bool)
Declaration
Parameters
Exceptions