Spread Windows Forms 6.0 Product Documentation
SetClipSpecial Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : SetClipSpecial Method


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.

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.  

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.
Visual BasicCopy Code
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)
C#Copy Code
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 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

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