SETTABLECELL - Revision history

Jrheinlaender at 19:20, 26 August 2024

2024-08-26T19:20:12Z

← Older revision		Revision as of 19:20, 26 August 2024
Line 7:		Line 7:
	Set the value, string or formula of a table cell. The first string expression must contain the table name and the second string expression 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.		Set the value, string or formula of a table cell. The first string expression must contain the table name and the second string expression 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.

	Starting with iMath 2.2.6, the second expression may be a ~~vector or an array~~ containing string expressions. iMath will set the values of the referenced cells. If the third expression is a single value, all cells will be set to that value. If it is a ~~vector or array~~ of the same dimension, the referenced cells will be set to the values from the ~~vector/array~~.		Starting with iMath 2.2.6, the second expression may be a [[Vector]] containing string expressions. iMath will set the values of the referenced cells. If the third expression is a single value, all cells will be set to that value. If it is a [[Vector]] of the same dimension, the referenced cells will be set to the values from the [[Vector]].
	\|		\|
	3=		3=

Jrheinlaender at 13:49, 1 September 2018

2018-09-01T13:49:08Z

← Older revision		Revision as of 13:49, 1 September 2018
Line 28:		Line 28:
	2.2.0 or earlier.		2.2.0 or earlier.

	Up to version 2.2.6 only literal strings are allowed, not string expressions		Up to version 2.2.6 only literal strings are allowed for table name and cell reference, not string expressions
	}}		}}
	[[Category:Data exchange]]		[[Category:Data exchange]]

Jrheinlaender at 13:48, 1 September 2018

2018-09-01T13:48:30Z

← Older revision		Revision as of 13:48, 1 September 2018
Line 6:		Line 6:
	2=		2=
	Set the value, string or formula of a table cell. The first string expression must contain the table name and the second string expression 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.		Set the value, string or formula of a table cell. The first string expression must contain the table name and the second string expression 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.

			Starting with iMath 2.2.6, the second expression may be a vector or an array containing string expressions. iMath will set the values of the referenced cells. If the third expression is a single value, all cells will be set to that value. If it is a vector or array of the same dimension, the referenced cells will be set to the values from the vector/array.
	\|		\|
	3=		3=

Jrheinlaender at 19:03, 29 August 2018

2018-08-29T19:03:23Z

@@ Line 1: / Line 1: @@
-{{Keyword|
+{{Keyword
-<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 <code>=</code>, iMath will set the table cell to a formula. Otherwise the table cell will be set to a text.
+<code>SETTABLECELL { [[expression]] , [[expression]] , [[expression]] }</code>
 |3=
-|4=
+=
 [[CALCCELL]] [[SETCALCCELLS]] [[TABLECELL]]
 }}
 [[Category:Data exchange]]

Jrheinlaender at 18:19, 8 July 2017

2017-07-08T18:19:42Z

← Older revision		Revision as of 18:19, 8 July 2017
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 '=', iMath will set the table cell to a formula. Otherwise the table cell will be set to a text.		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]]

Jrheinlaender: Created page with "{{Keyword| `SETTABLECELL ( string , string , expression )` | Set the value, string or formula of a table cell. The first string must contain the table n..."

2017-07-08T18:03:18Z

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..."

New page

{{Keyword|
<code>SETTABLECELL ( [[string]] , [[string]] , [[expression]] )</code>
|
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.
|
|
[[CALCCELL]] [[SETCALCCELLS]] [[TABLECELL]]
}}
[[Category:Data exchange]]