I found the same question on Ask LibreOffice, and its answers were most enlightening.

ROW() and COLUMN() return the current cell's row and column numbers if they are called without arguments. You can then use these to construct cell addresses and references using ADDRESS() and INDIRECT().