IMPORTRANGE formula bug in spreadsheet

When I press Enter after entering the formula for the first time, only one cell of data will be filled in. When I click on the formula edit area again and then press Enter, the data filled in the range will be successfully referenced.

Clicking OK button in the function arguments dialog will also cause this problem

Using the Node.js example from the document-server-integration and Docker 9.0 version
image

Hi @Jimmy0769 :wave:

We’re aware of the issue where arrays with range arguments in IMPORTRANGE are not auto-expanding properly—it’s connected to the implementation of dynamic arrays, which is currently in progress.

Once dynamic array support is fully implemented, this behavior should be resolved. Unfortunately, there isn’t a workaround available at the moment.

Thank you for your feedback and patience! :hugs:

1 Like

Hi @Nikolas
Thank you for your reply! Please inform me if there is any progress :grinning:

1 Like