CALCCELL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Keyword | {{Keyword | ||
| | | | ||
1= | |||
<code>CALCCELL ( [[expression]] , [[expression]] , [[expression]] )</code> | |||
| | | | ||
2= | |||
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. | |||
| | | | ||
3= | |||
<code> | |||
EQDEF cell = "a1" | |||
EQDEF t = CALCCELL("Unbenannt 1.ods", "Tabelle1", VAL(cell)) | |||
</code> | |||
Note that [[VAL]] is required here to create a string expression from the variable. | |||
| | |||
4= | |||
[[SETCALCCELLS]] [[SETTABLECELL]] [[TABLECELL]] | [[SETCALCCELLS]] [[SETTABLECELL]] [[TABLECELL]] | ||
| | |||
5= | |||
2.2.0 or earlier. | |||
Up to version 2.2.6 only literal strings are allowed, not string expressions | |||
}} | }} | ||
[[Category:Data exchange]] | [[Category:Data exchange]] | ||
Latest revision as of 18:56, 29 August 2018
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.