Special formulas
Jspreadsheet runs spredsheet-like formulas, and a few special formulas area available to support a better use of this feature.
Custom Jspreadsheet Methods
| Method | Example |
|---|---|
| =PROGRESS(int, string) Create a progressbar @Param int percent - Value from 0-100 @Param string color - Hex color for the progressbar |
Example |
| =RATING(int) Create a start rating based on a integer @Param int value - Rate value from 0-5 |
Example |
| =TABLE() Return the Jspreadsheet table instance | |
| =COLUMN() Return the column number where the formula has been executed | |
| =ROW() Return the row number where the formula has been executed | |
| =CELL() Return the cell string identification | |
| =VALUE(int, int) Return the cell value based on the colNumber and rowNumber |