After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 602530 - ":" cannot construct ranges from expressions
":" cannot construct ranges from expressions
Status: RESOLVED OBSOLETE
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
1.9.x
Other Windows
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
: 585274 (view as bug list)
Depends on:
Blocks:
 
 
Reported: 2009-11-20 19:48 UTC by Klaus Gruppenbacher
Modified: 2018-05-22 13:34 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
ttest file (10.00 KB, application/octet-stream)
2009-11-23 19:10 UTC, Klaus Gruppenbacher
Details

Description Klaus Gruppenbacher 2009-11-20 19:48:30 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
Comment 1 Morten Welinder 2009-11-20 20:36:09 UTC
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))
Comment 2 Andreas J. Guelzow 2009-11-20 22:32:17 UTC
I think in OOo : is an operator so it behaves differently than in Gnumeric. That's also why we have bug #585274.
Comment 3 Klaus Gruppenbacher 2009-11-23 19:10:12 UTC
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.
Comment 4 Andreas J. Guelzow 2009-11-25 01:41:52 UTC
*** Bug 585274 has been marked as a duplicate of this bug. ***
Comment 5 Klaus Gruppenbacher 2009-11-27 17:39:04 UTC
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))
Comment 6 GNOME Infrastructure Team 2018-05-22 13:34:12 UTC
-- 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.