Special formulas
Jspreadsheet supports spreadsheet-like formulas, along with special formulas designed to enhance usability and functionality.
Custom Jspreadsheet Methods
| Method | Example |
|---|---|
| =PROGRESS(int, string) Create a progress bar. Parameters: int percent (0-100)string color (Hex value) |
Example |
| =RATING(int) Create a star rating based on an integer. Parameters: int value (0-5) |
Example |
| =TABLE() Return the Jspreadsheet table instance. | |
| =COLUMN() Return the column number where the formula is executed. | |
| =ROW() Return the row number where the formula is executed. | |
| =CELL() Return the cell string identification. | |
| =VALUE(int, int) Return the cell value based on the column and row numbers. Parameters: int colNumberint rowNumber |