In spreadsheet, Can I get the row number and column number of the current cell?
I'm tring to get a matrix like the picture attached.
With Excel, I can easily finish this task by: =IF(ROW()<=COLUMN(),POWER(COLUMN()-1,2)+ROW(),POWER(ROW()-1,2)+2*ROW()-COLUMN())
In GGB, I faced two difficult.
1. row() and column() need a parameter, I can't get the row and column number of the current cell.
2. absolute reference is not surpported in row command. row(A1) works, but row($A1) does not.