ClipboardCopyFormulas Field

Copies only the selected items' formulas to the Clipboard.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared ReadOnly ClipboardCopyFormulas As Object

'Usage
 
Dim value As Object
 
value = SpreadActions.ClipboardCopyFormulas

public static readonly object ClipboardCopyFormulas

Example

This example uses the ClipboardCopyFormulas action.

// Type a formula, select the cell or cells, and press p to copy the formula
fpSpread1.AllowUserFormulas = true;
FarPoint.Win.Spread.InputMap im;
im = fpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused);
im.Put(new FarPoint.Win.Spread.Keystroke(Keys.P, Keys.None), FarPoint.Win.Spread.SpreadActions.ClipboardCopyFormulas);

Visual Basic

' Type a formula, select the cell Or cells, And press p to copy the formula
FpSpread1.AllowUserFormulas = True
Dim im As FarPoint.Win.Spread.InputMap
im = FpSpread1.GetInputMap(FarPoint.Win.Spread.InputMapMode.WhenFocused)
im.Put(New FarPoint.Win.Spread.Keystroke(Keys.P, Keys.None), FarPoint.Win.Spread.SpreadActions.ClipboardCopyFormulas)

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

Reference

SpreadActions Class
SpreadActions Members