Are dynamic arrays supported in Spreadsheet?

Desktop editors
1

On the one hand I see SEQUENCE() available. On the other hand it returns nothing but first value.
Similar, something like =A1:A10 returns only A1 value.
Same for EXPAND(). However, TAKE() and DROP() somehow work.
Did I missed something of that was not implemented? If the latest why SEQUENCE() is here?

2

Okay, I see. If I’d like SEQUENCE(257) I need to select 257 cells down and CSE. Any chances you will support dynamic arrays natively?

3

Hello @SergeiStPete
Would you mind providing us with a test file with usage scenario description? We will check it out.

5

@Alexandre , I mean the ability to work with arrays in grid without CSE

6

Understood, thank you. We are working on it already. Unfortunately, I cannot provide exact time frames at the moment. I will update this thread when we have something to share.

8

No problems. It’s important you take this into account and hopefully implement one day. Otherwise you’ll be too far from behemoths of Spreadsheet business.

1 Like