Spread Windows Forms 8.0 Product Documentation
SetClipSpecial Method
Example 


Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.
Overload List
OverloadDescription
SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions)Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.  
SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions,Boolean,Boolean)Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.  
SetClipSpecial(Int32,Int32,Int32,Int32,Object,ClipboardPasteOptions,Boolean,Boolean,Boolean)Sets the information to paste from the Clipboard for a specified range of cells on this sheet based on the paste option.  
Remarks
If you simply want to do Clipboard operations with tab-delimited formatted data (text) or unformatted data (value) as strings, use the SetClip or SetClipValue methods. Use the SetClipSpecial method to paste objects into the target range. These objects can contain appearance, formula, value, and formatting information. Use the pasteOption parameter to specify the extent of the information in the CellInfo object.
Example
This example sets the pasted information for a range of cells based on the ClipboardPasteOptions.
FpSpread1.ActiveSheet.SetValue(0, 0, "SetClipSpecial")
Dim cells As New FarPoint.Win.Spread.CellInfoRange(0, 0)
FpSpread1.ActiveSheet.SetClipSpecial(0, 0, 0, 0, cells, FarPoint.Win.Spread.ClipboardPasteOptions.All)
fpSpread1.ActiveSheet.SetValue(0, 0, "SetClipSpecial");
FarPoint.Win.Spread.CellInfoRange cells = new FarPoint.Win.Spread.CellInfoRange(0, 0);
fpSpread1.ActiveSheet.SetClipSpecial(0, 0, 0, 0, cells, FarPoint.Win.Spread.ClipboardPasteOptions.All);
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

SheetView Class
SheetView Members
SetClip Method
SetClipValue Method
ClipboardPasteOptions Enum

 

 


Copyright © GrapeCity, inc. All rights reserved.