":" cannot construct ranges from expressions
Submitted by Klaus Gruppenbacher
For me it looks like that Gnumeric cannot work with indirect adressing like: =sum(indirect("E"&Z2):indirect("E"&Z2)) This works well with Excel and Openoffice but not with Gnumeric.
I would like to use Gnumeric because Openoffice is missing some features of Excel which work at Gnumeric.
Can you please help?