Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SpreadActions Class / ClipboardCopyFormulas Field
Example


In This Topic
    ClipboardCopyFormulas Field
    In This Topic
    Copies only the selected items' formulas to the Clipboard.
    Syntax
    '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);
    ' 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)
    See Also