Spreadsheet column labels as base-26 numbers

It was suggested during the meeting that spreadsheet column labels can be interpreted as base-26 numbers.

I can't immediately see how this is supposed to work.

The typical sequence is A, B, C, ... Z, AA, AB, AC, ...

What is the zero-digit here? It can't be A, because then A would be 0 and AA would also be 0.

If A=1, with radix=27, then Z=26 and AA=28 so there is a gap in the sequence.

While the sequence is logical and practical, I can't see any way to interpret the column label as a base-N number.

Michael Kay
Saxonica

Received on Tuesday, 25 April 2023 20:29:03 UTC