Which part of a reference a cell token is, relative to a range operator : — the signal
IFormula.setReferenceModeAt needs to cycle the correct corner.
'self' — a standalone cell reference (no :).
'left' / 'right' — the operands of a range. A single-cell range A1:A1 is still a range, so
its two cell tokens are 'left' and 'right' — NOT 'self' (coords alone can't tell them apart).
Which part of a reference a cell token is, relative to a range operator
:— the signal IFormula.setReferenceModeAt needs to cycle the correct corner.'self'— a standalone cell reference (no:).'left'/'right'— the operands of a range. A single-cell rangeA1:A1is still a range, so its two cell tokens are'left'and'right'— NOT'self'(coords alone can't tell them apart).