Insert function skips row when adjacent cell is nonblank

Ask the Community
#1

How to reproduce
create new app
A1 = head1
A2 = hello
A5 = head1
B1 = INSERT(A5:A5, A1:A1, A2)
B8 = asdf
Then edit and enter A2 5 times in a row

Expected result
First time B1 is entered A6=hello
Then every time A2 cell edit mode and then entered
A7 = hello
A8 = hello
A9 = hello
and so on

Actual result
First time B1 is entered A6=hello
Then every time A2 cell edit mode and then entered
A7 = hello
A8 =
A9 = hello
A10 = hello
and so on

#2

Thanks, @dknodt. I can reproduce this behavior. We’ll check and get back to you.

#3

hello @Torben, @dknodt and thanks for the post.

As of today, what you observed is actually our intended behaviour.

If we inserted the content into A8 with INSERT(), we’d be putting it next to pre-existing data in cell B8 that is most likely unrelated to the new content. This will most likely result in a semantically inconsistent table.

However, we may make the behaviour more magical in the future and enforce strictly the table indicated by the header cells which are passed as a parameter - I think this was this your intended behaviour.

Any reason why you would want to use this?

#4

@dknodt we re-evaluated and implemented the behaviour you prescribed.

I will close this issue.

Thanks!