MULTIPLE.OPERATIONS doesn't work with OFFSET

[lukas1994]

I'm trying to run MULTIPLE.OPERATIONS on more than one variable. My idea was to use a single offset variable and look up the actual values based on this offset. However, MULTIPLE.OPERATIONS doesn't work with this set up. It works fine if I use the values directly. See attached spreadsheet. Any ideas why this is happening?

[JeJe]

=MULTIPLE.OPERATIONS(A$3;$A$7;$B14)

Vs

=MULTIPLE.OPERATIONS(A$3;$A$2;$E14)

You've changed the middle one in the one that doesn't work from A2 which is 10 to A7 which is 0

[lukas1994]

Yes, this is what I want. I want to change cell A7 and then A2 chooses the right value using the offset in A7.

[lukas1994]

For some reason it works if I use INDEX rather than OFFSET. Any ideas why? (see attached file)

[lukas1994]

I found a few very old issues:
https://bz.apache.org/ooo/show_bug.cgi?id=72718
https://bz.apache.org/ooo/show_bug.cgi?id=96803
https://bz.apache.org/ooo/show_bug.cgi?id=39304

So is MULTIPLE.OPERATIONS not a stable feature?

I could reproduce the SUM(A1;A2) vs SUM(A1:A2) issue for example.