# Features

- [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.