Posted 6 May 2020, 10:32 am ESTRelative table column references work differently than excel.
1) Click an adjacent row in a table while in cell edit mode gives the A1 notion not column reference. Clicking should [@olumn1]
2) The whole col is highlighted in Spreadjs. Excel only does the relative row.
3) Excel by default populates the entire column with the relative references.