There is a surprising inconsistency with how columns are represented in spreadsheets I have never thought about. There is A, B, ..., Z, AA, AB, ..., BA, ...; if we assume that column indexes start from 0 (like rows), then A = AA = AAA etc.
That's clearly incorrect, so the table rows must be indexed from 0 while table columns are indexed from 1, right? No! If A=1, then Z=27, so AA=28, but we've already determined, that A stands for 1, so AA is basically 28 + 1. Ergo, column labels in spreadsheets are not indexes and they are pure nonsense. QED. :)

Archos
in reply to Martin Bodlák 💙💛 • • •