I have to use the setSelectedDataAsync method to insert data to a sheet coming from an API. There is quite a bit of data (1000 lines by 100 cols). In this data there are also formulas, coming in R1C1 format. This works perfectly in my desktop Excel.
But in Excel online, they look like this:
I couldn't find a way to specify formulaR1C1.
the other option, getting the range and setting formulaR1C1 to the matrix, would work, but performance is terrible at that data volume.
Any alternatives? I am trying to publish my add-in to the store.
