New Version: 2016.04.14 r10077

[cyrille de brébisson]

Hello,

(04-21-2016 01:37 PM)Dirk.nl Wrote:  Choose box inside input function works perfect now.

Choose should also work inside a spreadsheet!

for example, set a spreadsheet with
A1:A5= {5,4,3,2,1}
B1= 1
B2= =CHOOSE(B1,"test", A1:A5}

as a bonus, if you have a program attached to your spreadsheet with a function called test_Changed(), it will be called each time the user changes the choose value.
you can try:
EXPORT test_Changed()
BEGIN
A3:= A3+1;
END;

Cyrille