Excel spreadsheet end at 1048576 and XFD

[life24]

Hello,
Can you explain XFD is 14bit? How calculate it?
How much space each letter is?
Why first letter end at X and second end at F and third to D ?
I can't understand it,Columns.Count = 2^14
But A through X is 27 , A through F is 6 and A through D is 4.
27*6*4 = 647 Possible permutations
Why 2^14 ?

 

[sweenish]

Because you're counting it completely wrong.

It'd be really easy to just yourself, anyway.

 

[life24]

Because you're counting it completely wrong.

It'd be really easy to just yourself, anyway.

Can you explain it? :\

 

[mpo]

Can you explain it? :\

I'll give you a hint. Column ZZ is column 702. This is the same as (26^2) + 26.

 

[cabri]

Hello,
Can you explain XFD is 14bit? How calculate it?
How much space each letter is?
Why first letter end at X and second end at F and third to D ?
I can't understand it,Columns.Count = 2^14
But A through X is 27 , A through F is 6 and A through D is 4.
27*6*4 = 647 Possible permutations
Why 2^14 ?

Given that there are 26 characters in the alphabet; how can X be 27 😕