# Configuration

- [Features](/configuration/features.md)
- [Data validation](/configuration/features/data-validation.md): Validate and show errors to users if they enter invalid data
- [Custom formula evaluation](/configuration/features/custom-formula-evaluation.md): Formula parser and calculation is plug n play
- [Iterative calculation](/configuration/features/iterative-calculation.md)
- [Formula auditing](/configuration/features/formula-auditing.md): Visualize formula dependencies with trace precedents and dependents
- [Real-time data](/configuration/features/real-time-data.md): Display real-time data, by subscribing to Websockets to REST API
- [Cell editors](/configuration/features/cell-editors.md): Switch between custom or default cell editor
- [Cell renderer](/configuration/features/cell-renderer.md): Customise Cells to your liking
- [Structured Cell Renderer](/configuration/features/structured-cell-renderer.md): Create your own custom schema on cell and render custom cells like Sparklines, document objects etc
- [Theming](/configuration/features/theming.md): Themes are used to custom the colours and default fonts of the Spreadsheet. You can also have customise colours of charts, embeds using a theme
- [Styling](/configuration/features/styling.md): Add borders, colours, stroke styles or custom gradients very easily
- [Context menu](/configuration/features/context-menu.md): Customise Context Menu
- [Localisation](/configuration/features/localisation.md): Add text in any language in the Spreadsheet
- [Named ranges](/configuration/features/named-ranges.md): Name ranges and use it in formulas
- [Basic filter or Excel AutoFilter](/configuration/features/basic-filter-or-excel-autofilter.md): Use a Basic filter or Autofilter to quickly find, filter and sort tabular data
- [Charts](/configuration/features/charts.md): ECharts is the built-in framework for rendering charts, but we are agnostic of chart renderer, so you are free to use your own chart framework
- [Slicers](/configuration/features/slicers.md): Add, move, resize, and manage slicers for table filtering
- [Embedded content](/configuration/features/embedded-content.md): Embed external content, pictures and drawings
- [Calculate on-demand](/configuration/features/calculate-on-demand.md): Trigger a full recalc whenever you need it.
- [Pivoting and Grouping](/configuration/features/pivoting-and-grouping.md): Create pivot tables with row/column grouping and aggregations
- [Tokenizer](/configuration/features/tokenizer.md): A Tokenizer tells the Spreadsheet how to identify formulas and string tokens in the user entered value of cell.
- [Lazy loading/Infinite scrolling](/configuration/features/lazy-loading-infinite-scrolling.md): Load data based on the visible viewport of the grid
- [OpenAI/Chat GPT Integration](/configuration/features/openai-chat-gpt-integration.md): Built-in OpenAI integration using ASK\_OPENAI function
- [Search](/configuration/features/search.md): Use the provided hooks and components to quickly add search functionality
- [Formula protection](/configuration/features/formula-protection.md): Add extra layer of protection to prevent users from copying formulas
- [Autofill](/configuration/features/autofill.md): Automatically fill a series of data in the Spreadsheet
- [Paint Format](/configuration/features/paint-format.md): Copy formatting from one cell or range and apply it to another
- [Advanced Grid Features](/configuration/features/advanced-grid-features.md): AI-powered autofill and advanced grid navigation features
- [Export canvas as image](/configuration/features/export-canvas-as-image.md): Export the entire visible canvas or part of the canvas as an image
- [Cell format Registry](/configuration/features/cell-format-registry.md): Spreadsheet lets you store and compress duplicate format data using cellxfs registries
- [Shared strings](/configuration/features/shared-strings.md): Spreadsheet can store repeated text in a shared string table and reference it from cell data.
- [Mentions](/configuration/features/mentions.md): Add @mentions functionality to spreadsheet cells
- [Cell Tooltips and Popovers](/configuration/features/cell-tooltips-and-popovers.md): Display tooltips and expandable content for spreadsheet cells
- [Multi-Instance Spreadsheets](/configuration/features/multi-instance-spreadsheets.md): Run multiple spreadsheet instances in the same application
- [User-Defined Colors](/configuration/features/user-defined-colors.md): Create custom color palettes for your spreadsheet
- [Version comparison](/configuration/features/version-comparison.md)
- [Navigate to Sheet Range](/configuration/features/navigate-to-range.md): Programmatically navigate and scroll to specific cell ranges
- [Calculated columns](/configuration/features/calculated-columns.md): Add columns with formulas, join multiple tables
- [Structured references](/configuration/features/structured-references.md): Add structured data to Spreadsheet and reference them using semantic formulas
- [Schema based tables and columns](/configuration/features/structured-references/schema-based-tables-and-columns.md): Convert any dataset to a schema driven table
- [Drag and Drop](/configuration/features/drag-and-drop.md): Drag and drop images and CSV/Excel files from your desktop
- [Text to Columns](/configuration/features/text-to-columns.md): Split text in cells into multiple columns
- [Conditional formatting](/configuration/features/conditional-formatting.md): Change text or background colour of cells based on the value
- [Undo/Redo](/configuration/features/undo-redo.md): All change history is preserved. Making versioning simple.
- [Components](/configuration/components.md)
- [Canvas Grid](/configuration/components/canvas-grid.md): The Canvas Grid that renders the spreadsheet
- [Toolbar](/configuration/components/toolbar.md): Toolbar component is a wrapper for all formatting buttons of the Spreadsheet
- [Formula Bar](/configuration/components/formula-bar.md): Display and edit cell formulas and values
- [Font and Text Selectors](/configuration/components/font-and-text-selectors.md): Font family, size, and text formatting selectors
- [Sheet Tabs](/configuration/components/sheet-tabs.md): Quickly switch between multiple sheets
- [Sheet Switcher](/configuration/components/sheet-switcher.md): Dropdown menu with a list of sheets, both hidden and visible
- [Sheet Status](/configuration/components/sheet-status.md): Show average, count and sum of numerical values
- [Range Selector](/configuration/components/range-selector.md): Displays and let users quickly select a named range
- [Formula Input](/configuration/components/formula-input.md): Use a formula input component outside the spreadsheet
- [Selection Input](/configuration/components/selection-input.md): Get selections from Spreadsheet and display it in an input field
- [SheetSearch](/configuration/components/sheetsearch.md): Search within a sheet with this component
- [NamedRangeEditor](/configuration/components/namedrangeeditor.md): Create and edit named ranges
- [DeleteSheetConfirmation](/configuration/components/deletesheetconfirmation.md): A confirmation dialog that can be displayed before deleting a sheet
- [TableEditor](/configuration/components/tableeditor.md): A table editor dialog to edit name, range and other options of a table
- [Cell Format Editor](/configuration/components/cell-format-editor.md): Component to edit cell format. It can be shown in a modal dialog or embedded in your own component.
- [Conditional Format Editor](/configuration/components/conditional-format-editor.md): Adds a Conditonal format editor component
- [Data Validation Editor](/configuration/components/data-validation-editor.md): Allow users to edit data validation rules
- [Insert Link Editor](/configuration/components/conditional-format-editor-1.md): Add and remove hyperlinks in cells
- [Insert Image Editor](/configuration/components/conditional-format-editor-2.md): Adds a image editor
- [Floating Cell Editor](/configuration/components/floating-cell-editor.md): Floating Cell Editor component can be used to create Mobile editors that resides out of the Spreadsheet container.
- [Grid Footer](/configuration/components/grid-footer.md): Footer component for adding rows dynamically at the bottom of the spreadsheet
- [API](/configuration/api.md): Spreadsheet API in a nutshell
- [Cell Data](/configuration/api/cell-data.md): Defines the data model for a cell
- [Sheets](/configuration/api/sheets.md): Supports multiple sheets with cross-references and tables
- [SpreadsheetProvider](/configuration/api/spreadsheetprovider.md): Context Provider that isolates Spreadsheet internal state
- [useSpreadsheet](/configuration/api/usespreadsheet.md): useSpreadsheet exposes some of the internal API via hooks
- [Hooks](/configuration/api/hooks.md): Utility hooks for advanced spreadsheet functionality
- [Modules](/configuration/api/modules.md): Spreadsheet 2 comes with various modules to help you compose the spreadsheet that you like.
- [SheetCell](/configuration/api/sheetcell.md): Sheet Cell is a primitive to generate CellData object
- [Using Spreadsheet with NextJS](/configuration/using-spreadsheet-with-nextjs.md): SSR is supported, but Server components, not yet
- [Keyboard shortcuts](/configuration/keyboard-shortcuts.md): Use keyboard shortcuts to navigate, format and use formulas.
- [Server-side Spreadsheet](/configuration/spreadsheet-interface.md): Update spreadsheet state and run formula evaluation on the backend