Per Google Docs Editors Help > Using arrays in Google Sheets:
Any function that takes a range (e.g. A1:B6) as an input parameter will also accept an array in its place. For example, SPARKLINE takes a range as the first parameter to specify the values to plot.
I am trying to reference a cell that contains array values to use as the data
parameter for a sparkline. My incoming data is in the format e.g. {43;12;98;2}
and let's say it's placed in cell A1.
Direct inclusion of the values works just fine: =sparkline({43;12;98;2})
But this fails: =sparkline(A1)
as does removing the curly brackets from A1 and doing this =sparkline({A1})
So how exactly does one reference another cell with an array of values in it?