SETCALCCELLS - Revision history

Jrheinlaender at 17:02, 27 August 2024

2024-08-27T17:02:25Z

← Older revision		Revision as of 17:02, 27 August 2024
Line 15:		Line 15:
	EQDEF cell = "a1"		EQDEF cell = "a1"

	EQDEF z = CALCCELL("Tabelle1", VAL(cell))		EQDEF z = CALCCELL("Unbenannt 1.ods", "Tabelle1", VAL(cell))

	SETCALCCELL {"Unbenannt 1.ods", "Tabelle1", VAL(cell), VAL(z+1)}		SETCALCCELL {"Unbenannt 1.ods", "Tabelle1", VAL(cell), VAL(z+1)}

Jrheinlaender at 13:49, 1 September 2018

2018-09-01T13:49:46Z

← 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 file name, table name and cell reference, not string expressions
	}}		}}
	[[Category:Data exchange]]		[[Category:Data exchange]]

Jrheinlaender at 19:08, 29 August 2018

2018-08-29T19:08:00Z

@@ Line 1: / Line 1: @@
-{{Keyword|
+{{Keyword
+|
-Set the value of 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 range reference. The dimensions of the cell range must match the dimensions of the expression (scalar, [[vector]] or [[matrix]]).
+=
 The Calc document is saved immediately after the change, during the recalculation of the iMath document.
+|
+|
 [[CALCCELL]] [[SETTABLECELL]] [[TABLECELL]]
 }}
 [[Category:Data exchange]]

Jrheinlaender at 18:01, 8 July 2017

2017-07-08T18:01:34Z

← Older revision		Revision as of 18:01, 8 July 2017
Line 7:		Line 7:
	\|		\|
	\|		\|
	[[CALCCELL] [[SETTABLECELL]] [[TABLECELL]]		[[CALCCELL]] [[SETTABLECELL]] [[TABLECELL]]
	}}		}}
	[[Category:Data exchange]]		[[Category:Data exchange]]

Jrheinlaender: Created page with "{{Keyword| `SETCALCCELLS ( string , string , string , expression )` | Set the value of a cell range in an Office Calc document. The first string con..."

2017-07-08T17:56:45Z

Created page with "{{Keyword| <code>SETCALCCELLS ( string , string , string , expression )</code> | Set the value of a cell range in an Office Calc document. The first string con..."

New page

{{Keyword|
<code>SETCALCCELLS ( [[string]] , [[string]] , [[string]] , [[expression]] )</code>
|
Set the value of 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 range reference. The dimensions of the cell range must match the dimensions of the expression (scalar, [[vector]] or [[matrix]]).

The Calc document is saved immediately after the change, during the recalculation of the iMath document.
|
|
[[CALCCELL] [[SETTABLECELL]] [[TABLECELL]]
}}
[[Category:Data exchange]]

SETCALCCELLS - Revision history

Jrheinlaender at 17:02, 27 August 2024

Jrheinlaender at 13:49, 1 September 2018

Jrheinlaender at 19:08, 29 August 2018

Jrheinlaender at 18:01, 8 July 2017

Jrheinlaender: Created page with "{{Keyword| SETCALCCELLS ( string , string , string , expression ) | Set the value of a cell range in an Office Calc document. The first string con..."

Jrheinlaender: Created page with "{{Keyword| `SETCALCCELLS ( string , string , string , expression )` | Set the value of a cell range in an Office Calc document. The first string con..."