problems with array in apps script

1

I have problems to pass the information from spreadsheet to an html with apps script.

I explain to you; I have a spreadsheet that contains 5 columns and 5 lines, but they are formulas, concatenation and others.

from an appscript html template, command to call the data with the following instructions;

var articulos = hojaEVA.getRange(1,1,5,5).getValues();   

then I do a return articulos; to send it to HTML, but it marks me an error saying that you can not use the return with that type of data.

but it only happens to me when my .getRange(1,1,5,5).getValues(); has formulas, if they are data alone it does not mark error.

    
asked by Fernando Tovar 28.09.2016 в 20:39
source

1 answer

1

I already found my problem, it was not because of the formulas, it was because a column was dated, I passed it to text and it worked without problems.

    
answered by 28.09.2016 / 21:56
source