SETTABLECELL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{Keyword| <code>SETTABLECELL ( string , string , expression )</code> | Set the value, string or formula of a table cell. The first string must contain the table n...") |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Keyword| | {{Keyword| | ||
<code>SETTABLECELL ( [[string]] , [[string]] , [[expression]] )</code> | <code>SETTABLECELL ( [[string]] , [[string]] , [[expression]] )</code> | ||
| | |2= | ||
Set the value, string or formula of a table cell. The first string must contain the table name and the second string the cell reference (you can see both if you click into the table cell and then look at the status bar at the bottom of the Writer window). You must reference a single cell. iMath checks whether the expression is a real number and sets the table cell to a double-precision floating point value. If the expression is a string and begins with | Set the value, string or formula of a table cell. The first string must contain the table name and the second string the cell reference (you can see both if you click into the table cell and then look at the status bar at the bottom of the Writer window). You must reference a single cell. iMath checks whether the expression is a real number and sets the table cell to a double-precision floating point value. If the expression is a string and begins with <code>=</code>, iMath will set the table cell to a formula. Otherwise the table cell will be set to a text. | ||
| | |3= | ||
| | |4= | ||
[[CALCCELL]] [[SETCALCCELLS]] [[TABLECELL]] | [[CALCCELL]] [[SETCALCCELLS]] [[TABLECELL]] | ||
}} | }} | ||
[[Category:Data exchange]] | [[Category:Data exchange]] | ||
Revision as of 18:19, 8 July 2017
Syntax
SETTABLECELL ( string , string , expression )
Implemented in iMath since version 2.2.0 or earlier.
Explanation
Set the value, string or formula of a table cell. The first string must contain the table name and the second string the cell reference (you can see both if you click into the table cell and then look at the status bar at the bottom of the Writer window). You must reference a single cell. iMath checks whether the expression is a real number and sets the table cell to a double-precision floating point value. If the expression is a string and begins with =, iMath will set the table cell to a formula. Otherwise the table cell will be set to a text.