MULTIPLE.OPERATIONS doesn't work with OFFSET

Discuss the spreadsheet application

MULTIPLE.OPERATIONS doesn't work with OFFSET

Postby lukas1994 » Tue Aug 13, 2019 1:38 am

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 21 times
OpenOffice 3.1 on MacOS
lukas1994
 
Posts: 14
Joined: Mon Aug 12, 2019 1:38 pm

Re: MULTIPLE.OPERATIONS doesn't work with OFFSET

Postby JeJe » Tue Aug 13, 2019 11:48 am

=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
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 739
Joined: Wed Mar 09, 2016 2:40 pm

Re: MULTIPLE.OPERATIONS doesn't work with OFFSET

Postby lukas1994 » Tue Aug 13, 2019 11:52 am

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
lukas1994
 
Posts: 14
Joined: Mon Aug 12, 2019 1:38 pm

Re: MULTIPLE.OPERATIONS doesn't work with OFFSET

Postby lukas1994 » Tue Aug 13, 2019 12:12 pm

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 18 times
OpenOffice 3.1 on MacOS
lukas1994
 
Posts: 14
Joined: Mon Aug 12, 2019 1:38 pm

Re: MULTIPLE.OPERATIONS doesn't work with OFFSET

Postby lukas1994 » Tue Aug 13, 2019 12:42 pm

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.
OpenOffice 3.1 on MacOS
lukas1994
 
Posts: 14
Joined: Mon Aug 12, 2019 1:38 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 11 guests