0003460: Add the following functions to expressions and spreadsheet: concatenate text and indirect

ID	Project	Category	View Status	Date Submitted	Last Update

0003460	Spreadsheet	Feature	public	2018-05-04 21:04	2021-11-24 15:30

Reporter	ulrich1a	Assigned To	realthunder
Priority	normal	Severity	minor	Reproducibility	have not tried
Status	assigned	Resolution	open
Product Version	0.18
Target Version	0.20

Summary	0003460: Add the following functions to expressions and spreadsheet: concatenate text and indirect
Description	It would be an advantage, if a spreadsheet can be filled with different sets of parameters to create a model and then just change one cell to select a certain parameter set. This can be done in a traditional spreadsheet with text concatenation and a line with indirect-functions that use the concatenated text as a cell-adress.
Tags	expressions, spreadsheet

realthunder 2020-02-27 05:54 developer ~0014186	Implemented with this commit in upstream. String can be concatenated using simple '+', or '%' similar to Python string formatter. Indirect reference can be done by just referring to another string property/cell.

yorik 2022-03-03 13:55 administrator ~0016623	This ticket has been migrated to GitHub as issue 5788.

Date Modified	Username	Field	Change
2018-05-04 21:04	ulrich1a	New Issue
2018-05-04 21:04	ulrich1a	Tag Attached: expressions
2018-05-04 21:04	ulrich1a	Tag Attached: spreadsheet
2020-02-27 05:54	realthunder	Note Added: 0014186
2020-02-27 18:09	Kunda1	Assigned To	=> realthunder
2020-02-27 18:09	Kunda1	Status	new => assigned
2021-02-06 06:30	abdullah	Target Version	=> 0.20
2021-11-24 15:30	chennes	Project	Expressions => Spreadsheet