Ask Your Question

The Function Match in libreCalc behaves not like Excel

asked 2017-03-09 13:51:13 +0200

polle gravatar image

updated 2017-03-09 14:24:00 +0200

image description

The Funktion is: =MATCH(1;B1:B15) Excel Outputs 8, libreCalc 15. I don't know which one is the right behaviour. Export as xls or opening the ods in Excel does not change anything.

LibreOffice V5.3.0.3 Excel: 16.0.4498.1000

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-09 14:26:05 +0200

Well, if you omit the third argument, then 1 is implied. Then, according to both LibreOffice help and Excel help, the array is assumed to be in ascending order.

Your data doesn't conform to this (it's requirement in case of Excel) - it's not sorted in ascending order; so on a non-conformant data, you shouldn't expect exactly same "undefined behavior".

edit flag offensive delete link more


Adding the third argument does not change the whole behaviour.

So your point is, that my data does not fit the function and thats the reason for my strange results. It feels like, I am using the wrong function for my Situation.

I just wanted the lowest Cell where an 1 is inserted, on libreCalc Match worked that way.

polle gravatar imagepolle ( 2017-03-14 15:08:39 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-09 13:51:13 +0200

Seen: 57 times

Last updated: Mar 09 '17