- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
- Cells
- Data Binding
- TableSheet
- GanttSheet
-
ReportSheet
-
Template Sheet Settings
- Set Template Cell Type
- Set Spill Mode
- Apply Cell Expansion
- Set Spill Direction
- Set Pin
- Set Cell Context
- Set Filter Condition
- Sort Cell Data
- Auto Fit Template Cell
- Change Cell Styles
- Apply Conditional Formatting
- Add Data Validation
- Change Cell States
- Add Show/Collapse Button
- ReportSheet Formula Functions
- Configure Data Entry Settings
- Set Pagination
- Configure Layout Settings
- Add Picture Shape
- Report Sheet Settings
- Report Sheet Data Entry Support
- Report Sheet Data Charts
-
Template Sheet Settings
- Data Charts
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- AI Assistant
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Import and Export Reference
- Formula Reference
- Frequently Used Events
- API Documentation
- Release Notes
Get Index
This function is used to get the index of the spilled cells.
Syntax
R.INDEX(cell, [context_cell])
Arguments
This function has the following arguments:
Argument | Description |
|---|---|
cell | [Required] Specify the cell that you want to get the index. |
context_cell | [Optional] Specify the cell for which you set the context. if the context cell has been specified, this function will return the cell index in the context. |
Example
// Use the formula(R.Index) to get the index of the spilled cells.
templateSheet.setFormula(1, 3, "R.INDEX(C2)");
templateSheet.setFormula(1, 4, "R.INDEX(C2,A2)");
templateSheet.setFormula(1, 5, "R.INDEX(A2)");The output of the above code will look like below.
