Pablo Jomer Pablo Jomer - 28 days ago 13
Javascript Question

Why is google apps spreadsheet setValue function not setting values in cells?

Why can't I use setValues in google apps spreadsheets API to set the values of cells in a spreadsheet?

I entered the correct cell and the value seems ok. however nothing appears in the cells!
I used the following to create the rows after the first row in my sheet.

sheet.insertRowsAfter(1,15);


After which I did this

sheet.setActiveCell("C2").setValue("AAA");

Answer

I found the answer to this question my self and wanted to preventing others from having the same problem.

Google aps api will set the default font color of a new cell to what ever the color above it is. I used white on blue color for my description column. The white font color propagated but not the background resulting in white on white color. I finaly found this and corrected it by setting cell fontcolor using

setFontColor("#000000");

Comments