TABLECELL - Revision history

Jrheinlaender at 13:47, 1 September 2018

2018-09-01T13:47:00Z

← Older revision		Revision as of 13:47, 1 September 2018
Line 6:		Line 6:
	2=		2=
	Access the value 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). The string must reference a single cell. iMath checks whether the table cell has number type or string type and will create the appropriate expression.		Access the value 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). The string must reference a single cell. iMath checks whether the table cell has number type or string type and will create the appropriate expression.

			Starting with iMath 2.2.6, the second expression may be a vector or an array containing string expressions. iMath will return the values of the referenced cells into a new vector or array of the same structure.

	Cell ranges are not supported because if you split/merge cells then the cell addresses become very complicated and a range might not be clearly defined.		Cell ranges are not supported because if you split/merge cells then the cell addresses become very complicated and a range might not be clearly defined.

Jrheinlaender at 18:58, 29 August 2018

2018-08-29T18:58:48Z

← Older revision		Revision as of 18:58, 29 August 2018
Line 1:		Line 1:
	{{Keyword\|		{{Keyword
	~~<code>TABLECELL ( [[string]] , [[string]] )</code>~~
	\|		\|
	Access the value 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). The string must reference a single cell. iMath checks whether the table cell has number type or string type and will create the appropriate expression.		1=
			<code>TABLECELL ( [[expression]] , [[expression]] )</code>
			\|
			2=
			Access the value 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). The string must reference a single cell. iMath checks whether the table cell has number type or string type and will create the appropriate expression.

	Cell ranges are not supported because if you split/merge cells then the cell addresses become very complicated and a range might not be clearly defined.		Cell ranges are not supported because if you split/merge cells then the cell addresses become very complicated and a range might not be clearly defined.
	\|		\|
			3=
			<code>
			EQDEF cell = "a1"

			EQDEF t = TABLECELL("Tabelle1", VAL(cell))
			</code>

			Note that [[VAL]] is required here to create a string expression from the variable.
	\|		\|
			4=
	[[CALCCELL]] [[SETTABLECELL]] [[SETCALCCELLS]]		[[CALCCELL]] [[SETTABLECELL]] [[SETCALCCELLS]]
			\|
			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]]

Jrheinlaender: Created page with "{{Keyword| `TABLECELL ( string , string )` | Access the value of a table cell. The first string must contain the table name and the second string the cell r..."

2017-07-08T18:24:45Z

Created page with "{{Keyword| <code>TABLECELL ( string , string )</code> | Access the value of a table cell. The first string must contain the table name and the second string the cell r..."

New page

{{Keyword|
<code>TABLECELL ( [[string]] , [[string]] )</code>
|
Access the value 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). The string must reference a single cell. iMath checks whether the table cell has number type or string type and will create the appropriate expression.

Cell ranges are not supported because if you split/merge cells then the cell addresses become very complicated and a range might not be clearly defined.
|
|
[[CALCCELL]] [[SETTABLECELL]] [[SETCALCCELLS]]
}}
[[Category:Data exchange]]

TABLECELL - Revision history

Jrheinlaender at 13:47, 1 September 2018

Jrheinlaender at 18:58, 29 August 2018

Jrheinlaender: Created page with "{{Keyword| TABLECELL ( string , string ) | Access the value of a table cell. The first string must contain the table name and the second string the cell r..."

Jrheinlaender: Created page with "{{Keyword| `TABLECELL ( string , string )` | Access the value of a table cell. The first string must contain the table name and the second string the cell r..."