Allow INDEX to reference entire column

[distancesprinter]

In Excel, I am accustomed to using INDEX(MATCH()) by referencing entire columns, e.g. INDEX(A:A,MATCH(C1,B:B,0)) where C1 is the interesting value, B:B is the column to match C1 value in, and A:A is the column whose matching row index to return. It seems I can MATCH against an entire column but cannot INDEX an entire column.

Looks like many people have run into this:

https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=9527

Can this feature be developed? I really enjoy LibreOffice Calc, otherwise.

[distancesprinter]

It looks like this is working in Calc 5. I had been using 4.3.3.2. However, I think it can be improved, as I cannot select a column as a reference, by clicking the Column A button that would typically select the entire column A, as I am typing the formula. I need to type Sheet1.A:A manually.

[Lupp]

What is your exact version? I just tried again with V5.1.0.3 and got the expected (correct) result.

[mariosv]

If I’m not wrong, it was implemented with 5.0, and works for me with 5.0.5

[distancesprinter]

You’re right, I needed to update to 5.0.5 from 4.3.3.2 (which is what is in Debian’s stable repo). It looks like I can’t easily select the column A as I’m typing the formula, but I can at least type it.