Spreadsheet Table

A spreadsheet table, in OpenL Tablets, is an analogue of the Excel table with rows, columns, formulas, and calculations as contents. Spreadsheets can also call decision tables or other executable tables to make decisions on values, and based on those, make calculations.

The format of the spreadsheet table header is as follows:

Spreadsheet SpreadsheetResult nameOfTableOrMethod(ARGUMENTS)

The following table describes the spreadsheet table header syntax:

Spreadsheet table header syntax
Element	Description
Spreadsheet	Reserved word that defines the type of the table.
SpreadsheetResult	Type of the return value. SpreadsheetResult returns the calculated content of the whole table. If only a single value is required, its type must be defined as a return type and calculated in the row or column named RETURN.
nameOfTableOrMethod	Java valid name of the table as for any executable table.
ARGUMENTS	Input arguments as for any executable table.

The first column and row of a spreadsheet table make the table column and row names. Values in other cells are the table values. An example follows:

Figure 34: Spreadsheet table organization

A spreadsheet table can contain simple values, such as a string, numeric, range value, or advance value referencing another cell value. The following table describes how another cell value can be referenced in a spreadsheet table:

Methods of referencing another cell
Notation	Method	Description
`{$columnName}`	By column name	Used to refer to the value of another column in the same row.
`{$rowName}`	By row name	Used to refer to the value of another row in the same column.
`{$columnName$rowName}`	Full reference	Used to refer to the value of another row and column.