MULTIPLE.OPERATIONS doesn't work with OFFSET
MULTIPLE.OPERATIONS doesn't work with OFFSET
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?
- Attachments
-
- example.ods
- (10.88 KiB) Downloaded 114 times
OpenOffice 3.1 on MacOS
Re: MULTIPLE.OPERATIONS doesn't work with OFFSET
=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
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
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: MULTIPLE.OPERATIONS doesn't work with OFFSET
Yes, this is what I want. I want to change cell A7 and then A2 chooses the right value using the offset in A7.
OpenOffice 3.1 on MacOS
Re: MULTIPLE.OPERATIONS doesn't work with OFFSET
For some reason it works if I use INDEX rather than OFFSET. Any ideas why? (see attached file)
- Attachments
-
- sample.ods
- (7.57 KiB) Downloaded 110 times
OpenOffice 3.1 on MacOS
Re: MULTIPLE.OPERATIONS doesn't work with OFFSET
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.
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.
OpenOffice 3.1 on MacOS