Status Update
Comments
se...@google.com <se...@google.com>
se...@google.com <se...@google.com> #2
Hello,
Thank you for reporting this issue!
Does it happen with other spreadsheets? If so, can you share the steps to reproduce this issue on a blank spreadsheet to test it out.
Also, can you clarify the expected and the actual behavior of it?
Regards.
se...@gmail.com <se...@gmail.com> #3
Hi,
Thank you for paying attention to it.
This does not happen on a blank sheet. It happens when sheet is filled with some type of data. I've already provided you with a sheet with a public access where issue happens. You can test on it or make a copy of it.
Expected behavior:
Must add a row at the end of the sheet (in this particular case at the 12-nd row).
Actual behavior:
Adds a row after the heading section (in this particular case at the 10-th row).
Regards.
an...@google.com <an...@google.com> #4
Hi there!
In the linked spreadsheet has data from row 2 to 11. Thus, it's considered the same data table. On row 7, the values are white, which makes them invisible (try clearing the formatting to see them). You have 2 options: Remove the data on row 7, or add another empty row to separate the data.
I hope it helps and have a nice day
se...@gmail.com <se...@gmail.com> #5
Hello.
Yes, the rows from 2 to 11 are considered as the same data table, and I want to append some data at the end of this table, that is - on the 12-nd row. Why separate it? What benefit would having two tables instead of one give if I want to append data in the end of the sheet in any case? Your documentation says that it is possible to do with append
method using already described approach, but actually it does not append data at the end of the table, that's the issue, it adds the data to the mid rows:
Expected: Must add at the 12-nd row.
Actual: Adds at the 10-th row.
an...@google.com <an...@google.com>
an...@google.com <an...@google.com> #6
Hi there!
I was talking about adding space before the table, so it doesn't read the data before it as part of the table.
That being said, I've filed an internal report about it. Any further update will be posted here.
Have a nice day
se...@gmail.com <se...@gmail.com> #7
Hi, any news on this?
is...@google.com <is...@google.com>
se...@gmail.com <se...@gmail.com> #8
You said that Any further update will be posted here
.
Don't you have any update during 1.5 year?
se...@gmail.com <se...@gmail.com> #9
Any updates?
Description
In docs it is written that if only sheet name is passed as range input for
append
method, it will examine all the data in the sheet, determine the last table and add data after it:But it turns out depending on some data inside the sheet this could not work:
test
running which you'll see that appended data is inserted in the 10-th row instead of the last row: Passingtest!A10
ortest!A11
doesn't work either.BUT It behaves as expected (adds the row at the end) if I:
dummy image
or remove its cell (A2:C4)some text
or remove its cell (I2:I6)