Jexcel implements several excel like formulas. This way provides a very nice compability mode with the major spreadsheet software, such as Excel or Google spreadsheet.
From the Jexcel Pro v7+, we brought many new features in relation to the formulas, such as:
- Automatic formula update on copy and paste
- Automatic formula update on corner copy
- Cross worksheet calculations
To bring Jexcel spreadsheet inline with modern software and extend the capabilities, the major futures updates are to bring range operations and custom global variables
We currently maintain a repository with an open source implementation of various excel like formulas adapted to run in a web-based environment.
To support the usage of formulas jexcel brings a few special formulas that are available to help relative calculations.
|=TABLE()||Return the jexcel 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|