Over 50 MVC Extensions
FREE TRIAL BUY NOW
THEMES
THEME SETTINGS

Spreadsheet - API Functions in Formulas

  • UndoRedo
    Undo

    Undo
    po

  • Paste
    CutCopy
    Clipboard

    Clipboard
    po
  • v
    v
    popopopo
    Font

    Font
    po
  • Wrap TextMerge Cellspo
    Alignment

    Alignment
    po
  • po
    dialogboxlauncherNumber

    Number
    po

  • Insert
    po
    Delete
    po
    Format
    po
    Cells

    Cells
    po
  • AutoSumpoFillpoClearpo

    Sort & Filterpo
    Find
    Editing

    Editing
    po

  • Format As Table
    Styles

    Styles
    po

  • Margins
    po
    Orientation
    po
    Size
    po
    dialogboxlauncherPage Setup

    Page Setuppo
  • dialogboxlauncherPrint

    Print
    po
  • Show

    Show
    po

  • Full Screen
    View

    View
    po

  • Freeze Panespo
    Window

    Window
    po
  • Table Name
    Properties

    Properties
    po
  • Convert to Range
    Tools

    Tools
    po
  • Table Style Options

    Table Style Optionspo
  • Modify Style
    Table Style Options

    Table Style Optionspo
 

This example demonstrates how to programmatically use predefined functions in formulas to perform simple or complex calculations over arguments. Set the Range.Formula property to a formula. Follow the rules below to create a formula that uses a function.

  • Start the formula with the "=" sign, as you usually do when creating formulas.
  • Specify the function name.
  • Specify the function arguments in parentheses. Arguments can be numbers, text and logical values, cell references and names, or other functions.
Version: v2017 vol 1.3
Copyright © 2006-2017 Developer Express Inc
Your Next Great MVC App Starts Here

Get started today and download your 30-day trial of DevExpress MVC Extensions (includes 30 days of free technical support).

All demos ship with full source code and are included in the DevExpress MVC distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress MVC Extensions ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.