Array in expression

[remi.bayon]

Hello everyone,

Maybe it already exists a way to do it but if not it could be very useful to have the function “[number]” or “.at(number)” in the expression editor.

To realise operations on cells of tabs, it needed to save the cell in a separated variable first.

Best regards,
Rémi Bayon

[jjj]

I don’t think this is possible to do in the expression editor. You would need to use the array functions.

[tony.wang]

try this TEXTTONUMBER(TOTEXT(XXXXXX))