CALCCELL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{Keyword| <code>CALCCELL ( string , string , string )</code> | Access the value of a cell or a cell range in an Office Calc document. The first string contains th...") |
No edit summary |
||
| Line 2: | Line 2: | ||
<code>CALCCELL ( [[string]] , [[string]] , [[string]] )</code> | <code>CALCCELL ( [[string]] , [[string]] , [[string]] )</code> | ||
| | | | ||
Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string contains the sheet name, and the third the cell reference. iMath will create a [[number]] or a [[string | Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string 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. | ||
| | | | ||
| | | | ||
Revision as of 18:46, 8 July 2017
Syntax
CALCCELL ( string , string , string )
Implemented in iMath since version 2.2.0 or earlier.
Explanation
Access the value of a cell or a cell range in an Office Calc document. The first string contains the file name of the Calc document (relative paths are possible). The second string 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.