- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer VSCode Plugin
- Tutorials
-
SpreadJS Designer Component
- Getting Started
- Quick Start
- Theme
- Designer Interface
- JavaScript Frameworks
- Template-Based Workbook Initialization
- Customizations
-
Work in Designer Component
- AutoSum Functions
- Set Range Template Cell
- Name Box
- Select Cells Using Go To
- Find and Replace
- Edit Font Size
- Edit Font Family
- Manage Conditional Formatting Rules
- Shape Selection Pane
- Automatic Outline
- Format Painter
- Table Slicer
- Data Source
- TableSheet
- GanttSheet Designer
- ReportSheet Designer
- Data Chart Designer
- Text to Columns
- Remove Duplicates
- Pivot Table
- Dockable Side Panel
- Command Palette
- Transform Cells with LAMBDA Formula
- Threaded Comments Panel
- What-If Analysis
- Insert Function Dialog
- Named Cell Templates
- Insert Pictures in Designer
- Toolbar Ribbon
- API Documentation
- SpreadJS Collaboration Server
- Touch Support
- Formula Reference
- Import and Export Reference
- Events
- API Documentation
- Release Notes
What-If Analysis
SpreadJS Designer supports for What‑If Analysis, including Goal Seek and Data Table.
These features are available from the Data tab in the ribbon.
Goal Seek
Goal Seek determines the input value required to achieve a specified formula result.
Open the Goal Seek Dialog
Go to Data → What‑If Analysis → Goal Seek.
The Goal Seek dialog appears.
Configure Goal Seek
In the dialog, specify:
Set cell: The formula cell whose result you want to control.
To value: The desired result.
By changing cell: The input cell that will be adjusted.
Maximum iterations: The maximum number of calculation attempts.
Tolerance: The acceptable difference between the calculated result and the target value.
Click OK to start the process.
Goal Seek Execution
When Goal Seek starts:
The system iteratively updates the changing cell.
A Goal Seek Status pane displays the progress.
You can review intermediate results during calculation.
When the result falls within the specified tolerance:
A result dialog is displayed.
You can then choose:
OK – Apply the final value to the worksheet. The operation supports undo.
Cancel – Revert all changes made during the process.
Data Table
A Data Table evaluates a formula using multiple input values and returns the corresponding results.
Open the Data Table Dialog
Select the target range in the worksheet.
Go to Data → What‑If Analysis → Data Table.
The Data Table dialog appears.
Configure the Data Table
In the dialog, specify:
Row input cell
Column input cell
At least one input cell must be provided.
Click OK to confirm.
After confirmation:
An
SJS.TABLEformula is inserted into the selected range.The results are calculated automatically.
Data Table Execution
During calculation, the Status Bar displays the progress of the Data Table evaluation.
You can monitor the percentage completed until the calculation finishes.
Partial Calculation Mode
For performance optimization, Designer supports Partial Calculation mode for Data Table.
When enabled:
SJS.TABLEformulas are not recalculated automatically when dependent values change.Users must manually trigger recalculation by clicking the Calculate button.
This mode is recommended when working with large data tables.
