Formulas in React Spreadsheet component
3 Jul 20261 minute to read
The React Spreadsheet Editor component supports formulas, allowing you to perform calculations on worksheet data. Formulas can reference cells from the same sheet or from different sheets, enabling dynamic and flexible data analysis.
-
Formula Property: Set a formula or expression for a cell at initial load using the
formulaproperty. - Data Binding: Assign formulas or expressions to cells through data binding.
- Editing: Enter or modify a formula directly in a cell using the cell editing.
-
updateCell Method: Programmatically set or update the formula of a cell using the
updateCellmethod.
Formula Behavior
Formulas in the Spreadsheet component are automatically recalculated whenever referenced cell values change. This ensures that your calculations and results always stay up to date as you edit your data. You can use built-in formulas, create custom formulas, and handle formula errors for robust data processing.
Formula Features Overview
The React Spreadsheet Editor component provides a variety of features for working with formulas and calculations. Below is a quick overview of each feature, with links to their respective documentation sections:
- Built-in Formulas: Use a wide range of standard formulas for common calculations.
- Custom Formula Creation: Define your own formulas to meet specific calculation needs.
- Named Ranges: Assign names to cell ranges for easier reference in formulas.
- Formula Bar: Enter and edit formulas using the formula bar interface.
- Formula Error Handling: Manage and troubleshoot errors that occur in formulas.
- Calculation Modes: Control when and how formulas are recalculated in the worksheet.
- Culture-Specific Formula Separators: Use separators that match your locale for formulas.
Note
You can refer to our React Spreadsheet Editor feature tour page for its groundbreaking feature representations. You can also explore our React Spreadsheet example to knows how to present and manipulate data.