SapSetData returns #VALUE (problem with using reference cells in formula) - AFO 2.4

[Former Member]

Hi, Experts!

We're trying to use sapsetdata function to save data that previously were calculated in excel.

Input Query:

SapSetData returns normal value (cell D2) when we hardcode technical keys of info objects and their value. See the figure below. This doesn’t suit for us, because we’ve got a dynamic input schedule and the number of rows (and as a result combination of elements of the info-objects) may vary.

SapSetData returns #value error (cell C2) when we are using reference cells as parameters for info objects technical keys and their values in formula:

Does anybody have guesses why the second variant not working?

P.S. we were using this «how to guide» for our solution - https://blogs.sap.com/2016/12/06/using-the-formula-sapsetdata-for-offline-planning-with-sap-business...