- 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
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
R.YOY
This function is used to get the year-over-year ratio.
Syntax
R.YOY(ValueCell, ContextCell1, [ContextCell2])
Arguments
This function has the following arguments:
Argument | Description |
|---|---|
ValueCell | [Required] Specify the cell for which you want to get the year-over-year ratio. |
ContextCell1 | [Required] Specify the context cell 1, which usually is the year cell. Example: If the A2 cell is bound to the year column, B2 cell is bound to the month column, C2 cell is bound to the sales column, then R.YOY(C2, A2) will return the year-over-year ratio. |
ContextCell2 | [Optional] Specify the context cell 2. If the value cell is a cross cell, this argument must be specified. |
Example 1: The value cell is a normal cell
Template:
Preview:
Example 2: The value cell is a cross cell
Template:
Preview:
