[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Collapse]Spreadsheet Formulas
    [Expand]Functions
     Operators
     Array Formulas
     Calculation
     Formula Engine
     Formula AutoComplete
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Shapes
    Printing
    Events
   [Expand]Mail Merge Overview
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Formula AutoComplete

The Formula AutoComplete feature allows you to avoid typing and syntax errors when creating and editing formulas. When you type a formula into a cell, the SpreadsheetControl displays a drop-down list of valid functions, defined names and table names that match the letters you enter. A tooltip with a detailed description appears for a selected item. Use the UP ARROW and DOWN ARROW keys to navigate through the suggestions. Press TAB or double-click the selected item to insert it into the formula. Press ALT+DOWN ARROW in edit mode to disable or enable Formula AutoComplete.

To change the Formula AutoComplete's behavior, use members of the SpreadsheetFormulaAutoCompleteOptions object accessible from the SpreadsheetControlOptions.FormulaAutoComplete property. The table below lists the main properties that affect the Formula AutoComplete functionality:

Property

Description

SpreadsheetFormulaAutoCompleteOptions.Enabled Allows you to turn the Formula AutoComplete functionality on or off.
SpreadsheetFormulaAutoCompleteOptions.SearchMode Allows you to specify which items should appear in the Formula AutoComplete's drop-down list:

Is this topic helpful?​​​​​​​