Extend Range Syntax

[ChrisMaple]

I'd like to be able to express
PRODUCT(1+A1/100;1+A2/100;1+A3/100;1+A4/100)
as
PRODUCT(1+A1/100:1+A4/100)
(notice change from semicolon to colon).
The purpose is twofold: simpler expression and automatic function change if a new row is inserted.
I think this would be a useful extention for future releases of oocalc.
Is there any way something similar to this can be accomplished now, without being more trouble than it's worth?

[RickRandom]

I think you could try:

=PRODUCT(1+A1:A4/100)

but instead of pressing Enter, press Ctrl-Shift-Enter, and this enters it as an array function, and automatically adds the { and } around it.

I'm not sure if this is what you want, or if it actually works.

(My usual approach would be to add another column with 1+A1/100, fill donw, then get the product of the new column.)

[ChrisMaple]

Thanks, this works perfectly, and greatly enhances my understanding of how to do things in oocalc.