sheet.appendRow() adds data way down in sheet with lots of blank rows in between

[Alan Wells]

Multiple people have reported issues with sheet.appendRow() adding the data way down in the sheet, out of sight, and with many blank rows in between the data and the row where sheet.appendRow() adds the data.

I don't know whether the user mistakenly adds cell content, and then removes it, but there is something unseen in the cell evaluating as a value, or if this is a real bug.  If it is a bug, then I'm guessing that duplicating it could be very difficult.

https://stackoverflow.com/questions/55736033/sheetappendrow-no-longer-adds-new-rows?noredirect=1#comment98180781_55736033

[Martin Hawksey]

From memory one cause of this behaviour is if the sheet includes an ARRAYFORMULA() particularly if it is using a column reference e.g. =ARRAYFORMULA(A:A) ... not tested my theory/memory

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-script-community.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5d3e6528-e1b3-4a51-a254-6668b3b156fb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.