CALCCELL
Jump to navigation
Jump to search
Syntax
CALCCELL ( expression , expression , expression )
Implemented in iMath since version 2.2.0 or earlier.
Up to version 2.2.6 only literal strings are allowed, not string expressions.
Explanation
Access the value of a cell or a cell range in an Office Calc document. The first string expression contains the file name of the Calc document (relative paths are possible). The second string expression contains the sheet name, and the third the cell reference. iMath will create a number or a string, depending on the type of the Calc cell.
Example
EQDEF cell = "a1"
EQDEF t = CALCCELL("Unbenannt 1.ods", "Tabelle1", VAL(cell))
Note that VAL is required here to create a string expression from the variable.