Dealing with columns
Dealing with cells
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:
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|