How to access a cell in LibreOffice Calc using numeric indices?

Question

Is there a function in LibreOffice Calc that takes an integer x and an integer y and splashes out the contents of a cell with this position?

There is a function ADDRESSthat spits out the address of a given [x; y]. The problem is that I do not know how to dereference it.

+4

Martin Drozdik Jan 03 '14 at 11:36

1 answer

angabriel · Accepted Answer · 2014-01-03T11:50:42+0000

The following works for me:

=INDIRECT(ADDRESS(5;2))

Where 5 is the row and 2 is the column, INDIRECT seems to resolve this link to the actual value.

NeoOffice is also tested on OSX, where it also works.