GNOME Bugzilla – Bug 602530
":" cannot construct ranges from expressions
Last modified: 2018-05-22 13:34:12 UTC
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? Best regards Klaus
1. INDIRECT is almost always the wrong thing to do. INDEX is better. 2. If you really must, use just one string: =sum(indirect("E"&Z2&":E"&Z2))
I think in OOo : is an operator so it behaves differently than in Gnumeric. That's also why we have bug #585274.
Created attachment 148338 [details] ttest file Please find attached an example. It's part of a complicated evaluation of measuring data. I want to use some kind of pointers that I easily can change evaluation parameters. Indeed, the behavior of INDIERECT is strange.The hint with INDIRECT came from a colleague from our IT department. I don't know how to use INDEX in that way. But anyway, it would be helpful if Gnumeric would behave in the same way as Excel. I would like to completely switch to gnumeric because of some advantages. Maybe I will switch to Linux some day.
*** Bug 585274 has been marked as a duplicate of this bug. ***
I meanwhile could remark, that in my case Gnumeric has a problem when redundant brackets are used, eg.: =sum((indirect("A"&(G1))):(indirect("A"&(G1+2)))) not working =sum(indirect("A"&(G1)):indirect("A"&(G1+2))) working I meanwhile also have seen that using INDEX has some advantages and works well, e.g.: =SUM(INDEX(A1:A50, G1):INDEX(A1:A50, G1+2))
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/125.