> For the complete documentation index, see [llms.txt](https://docs.rowsncolumns.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rowsncolumns.app/configuration/features.md).

# Features

- [Data validation](https://docs.rowsncolumns.app/configuration/features/data-validation.md): Validate and show errors to users if they enter invalid data
- [Custom formula evaluation](https://docs.rowsncolumns.app/configuration/features/custom-formula-evaluation.md): Formula parser and calculation is plug n play
- [Iterative calculation](https://docs.rowsncolumns.app/configuration/features/iterative-calculation.md)
- [Formula auditing](https://docs.rowsncolumns.app/configuration/features/formula-auditing.md): Visualize formula dependencies with trace precedents and dependents
- [Real-time data](https://docs.rowsncolumns.app/configuration/features/real-time-data.md): Display real-time data, by subscribing to Websockets to REST API
- [Cell editors](https://docs.rowsncolumns.app/configuration/features/cell-editors.md): Switch between custom or default cell editor
- [Cell renderer](https://docs.rowsncolumns.app/configuration/features/cell-renderer.md): Customise Cells to your liking
- [Structured Cell Renderer](https://docs.rowsncolumns.app/configuration/features/structured-cell-renderer.md): Create your own custom schema on cell and render custom cells like Sparklines, document objects etc
- [Theming](https://docs.rowsncolumns.app/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](https://docs.rowsncolumns.app/configuration/features/styling.md): Add borders, colours, stroke styles or custom gradients very easily
- [Context menu](https://docs.rowsncolumns.app/configuration/features/context-menu.md): Customise Context Menu
- [Localisation](https://docs.rowsncolumns.app/configuration/features/localisation.md): Add text in any language in the Spreadsheet
- [Named ranges](https://docs.rowsncolumns.app/configuration/features/named-ranges.md): Name ranges and use them in formulas
- [Basic filter or Excel AutoFilter](https://docs.rowsncolumns.app/configuration/features/basic-filter-or-excel-autofilter.md): Use a Basic filter or Autofilter to quickly find, filter and sort tabular data
- [Charts](https://docs.rowsncolumns.app/configuration/features/charts.md): Rowsncolumns Spreadsheet renders charts via ECharts (or Plotly via opt-in), parses + emits OOXML chart XML, and accepts a custom renderer if neither default fits.
- [Slicers](https://docs.rowsncolumns.app/configuration/features/slicers.md): Add, move, resize, and manage slicers for table filtering
- [Embedded content](https://docs.rowsncolumns.app/configuration/features/embedded-content.md): Embed external content, pictures and drawings
- [Calculate on-demand](https://docs.rowsncolumns.app/configuration/features/calculate-on-demand.md): Trigger a full recalc whenever you need it.
- [Pivoting and Grouping](https://docs.rowsncolumns.app/configuration/features/pivoting-and-grouping.md): Create pivot tables with row/column grouping, aggregations, sorting, filtering, totals, drilldown, and slicer integration
- [Outline & Grouping](https://docs.rowsncolumns.app/configuration/features/outline-grouping.md): Group rows or columns into collapsible outlines with Excel-style +/- gutter buttons and a 1/2/3 level selector
- [Print preview](https://docs.rowsncolumns.app/configuration/features/print-preview.md): Google-Sheets-style full-screen print preview dialog with paginated previews, paper-size + margin + orientation settings, headers/footers, scope, and a paginated browser print
- [Tokenizer](https://docs.rowsncolumns.app/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](https://docs.rowsncolumns.app/configuration/features/lazy-loading-infinite-scrolling.md): Load data based on the visible viewport of the grid
- [OpenAI/Chat GPT Integration](https://docs.rowsncolumns.app/configuration/features/openai-chat-gpt-integration.md): Built-in OpenAI integration using ASK\_OPENAI function
- [Search](https://docs.rowsncolumns.app/configuration/features/search.md): Use the provided hooks and components to quickly add search functionality
- [Formula protection](https://docs.rowsncolumns.app/configuration/features/formula-protection.md): Add extra layer of protection to prevent users from copying formulas
- [Autofill](https://docs.rowsncolumns.app/configuration/features/autofill.md): Automatically fill a series of data in the Spreadsheet
- [Paint Format](https://docs.rowsncolumns.app/configuration/features/paint-format.md): Copy formatting from one cell or range and apply it to another
- [Advanced Grid Features](https://docs.rowsncolumns.app/configuration/features/advanced-grid-features.md): AI-powered autofill and advanced grid navigation features
- [Export canvas as image](https://docs.rowsncolumns.app/configuration/features/export-canvas-as-image.md): Export the entire visible canvas or part of the canvas as an image
- [Cell format Registry](https://docs.rowsncolumns.app/configuration/features/cell-format-registry.md): Spreadsheet lets you store and compress duplicate format data using cellxfs registries
- [Shared strings](https://docs.rowsncolumns.app/configuration/features/shared-strings.md): Spreadsheet can store repeated text in a shared string table and reference it from cell data.
- [Rich text formatting](https://docs.rowsncolumns.app/configuration/features/rich-text-formatting.md): Per-segment formatting inside a single cell — bold, italic, underline, strikethrough, color, font family, font size — plus \`@mention\` chips.
- [Mentions](https://docs.rowsncolumns.app/configuration/features/mentions.md): Add @mentions functionality to spreadsheet cells
- [Cell Tooltips and Popovers](https://docs.rowsncolumns.app/configuration/features/cell-tooltips-and-popovers.md): Display tooltips and expandable content for spreadsheet cells
- [Multi-Instance Spreadsheets](https://docs.rowsncolumns.app/configuration/features/multi-instance-spreadsheets.md): Run multiple spreadsheet instances in the same application
- [User-Defined Colors](https://docs.rowsncolumns.app/configuration/features/user-defined-colors.md): Create custom color palettes for your spreadsheet
- [Version comparison](https://docs.rowsncolumns.app/configuration/features/version-comparison.md)
- [Navigate to Sheet Range](https://docs.rowsncolumns.app/configuration/features/navigate-to-range.md): Programmatically navigate and scroll to specific cell ranges
- [Calculated columns](https://docs.rowsncolumns.app/configuration/features/calculated-columns.md): Add columns with formulas, join multiple tables
- [Structured references](https://docs.rowsncolumns.app/configuration/features/structured-references.md): Add structured data to Spreadsheet and reference them using semantic formulas
- [Schema based tables and columns](https://docs.rowsncolumns.app/configuration/features/structured-references/schema-based-tables-and-columns.md): Convert any dataset to a schema driven table
- [Drag and Drop](https://docs.rowsncolumns.app/configuration/features/drag-and-drop.md): Drag and drop images and CSV/Excel files from your desktop
- [Text to Columns](https://docs.rowsncolumns.app/configuration/features/text-to-columns.md): Split text in cells into multiple columns
- [Conditional formatting](https://docs.rowsncolumns.app/configuration/features/conditional-formatting.md): Change text or background colour of cells based on the value
- [Sparklines](https://docs.rowsncolumns.app/configuration/features/sparklines.md): Inline mini-charts inside cells — line, column, or win/loss
- [Comments](https://docs.rowsncolumns.app/configuration/features/comments.md): Legacy single-author cell notes with author + rich text + author color
- [Gradient cell fills](https://docs.rowsncolumns.app/configuration/features/gradient-fills.md): Linear and radial gradient fills on individual cells — round-trips XLSX and renders on canvas
- [Linked data types](https://docs.rowsncolumns.app/configuration/features/linked-data-types.md): Cells that carry a structured entity (Stocks, Geography, custom) with refreshable fields accessed via dot notation
- [LAMBDA and higher-order functions](https://docs.rowsncolumns.app/configuration/features/lambda-and-higher-order-functions.md): LAMBDA, LET, MAP/REDUCE/BYROW/BYCOL/SCAN/MAKEARRAY, and GROUPBY/PIVOTBY
- [Undo/Redo](https://docs.rowsncolumns.app/configuration/features/undo-redo.md): All change history is preserved. Making versioning simple.