Hi everybody,

I wonder whether this is possible to populate a dynarange using other method as a subset or an odbc query.

I would have said "yes" because of the "Formula" option but I tried the following and this does not work.

Let's assume I have values in the range A1:A4.

When I use the following as source:

- =A1:A4 => returns only the first element (in A1)

- =OFFSET(A1;0;0;1;4) => does not work (#VALUE!)

- named variable aaaa with source A1:A4 => returns the first ellement

- use of the function asarray() (would make sense) : =asarray(A1:A4) => returns the first element

- ={"hello";"world"} => works ! wtf ? something more dynamic maybe ?

question : what is this field here for if this cannot be properly used ?!

when putting a PALO.SUBSET Formula using the generator this works though.

Even more mystery : when pasting a PALO.SUBSET Formula in the worksheet, and the formula in the Dynarange formula field, guest what... => returns NOTHING

any idea ?

cheers,

I wonder whether this is possible to populate a dynarange using other method as a subset or an odbc query.

I would have said "yes" because of the "Formula" option but I tried the following and this does not work.

Let's assume I have values in the range A1:A4.

When I use the following as source:

- =A1:A4 => returns only the first element (in A1)

- =OFFSET(A1;0;0;1;4) => does not work (#VALUE!)

- named variable aaaa with source A1:A4 => returns the first ellement

- use of the function asarray() (would make sense) : =asarray(A1:A4) => returns the first element

- ={"hello";"world"} => works ! wtf ? something more dynamic maybe ?

question : what is this field here for if this cannot be properly used ?!

when putting a PALO.SUBSET Formula using the generator this works though.

Even more mystery : when pasting a PALO.SUBSET Formula in the worksheet, and the formula in the Dynarange formula field, guest what... => returns NOTHING

any idea ?

cheers,

laloune

*Post hoc, non est propter hoc*The post was edited 1 time, last by laloune ().