Using the below code:
sheet.range("A2").formula("0");
sheet.range("A1:A3").values([[1],[2],[3]]);
I noticed that A2 is set to 0. I was expecting it to be set to 2. Is this expected or is it a bug?
Most likely, it is a bug since the below code sets all the range to 2 (including A2).
sheet.range("A2").formula("0");
sheet.range("A1:A3").value(2);