Querying a small table (11x4 cells), results in sheet expanding to 50.000 rows. Is this expected behaviour or a bug?
Shared example spreadsheet here. Spr is read-only, because experimenting with this will quickly create more than 1 million cells. To replicate the behaviour, please copy the spreadsheet to a new spreadsheet, and add "=" To content in cell Sheet1!P11 to activate the query.
When entering the above query in cell T1, query works as expected, and returns a 11x2 results table. When entering the same query in, for example, cell P11, the query fails, but 50.000 rows are created. Query fails with "#REF". As far as I can see, there is no content in the 50k rows.
Error message on hovering over cell: Result was not automatically expanded. "Please insert more rows(10)." But still 50.000 rows are created. Surely this is not what should happen? I searched on SE for similar issues, but could not find any.
My .05: The query creates a new row beyond the last row in the table. This then causes the query result to expand to another row, which creates yet another row, etc. until max. rows is reached.
Any insights/references/comments greatly appreciated!
Table in text format:
ID First_name1 Sales Sale_date
1 Linsay 2 6/3/2007
2 Paris 26.53 6/3/2007
3 Britney 1 6/3/2007
4 Nicole 1 6/3/2007
5 Linsay 9.16 7/3/2007
6 Paris 1.52 7/3/2007
7 Britney 43.21 7/3/2007
8 8.05 7/3/2007
9 Linsay 17.62 8/3/2007
10 Paris 24.19 8/3/2007