stringFromColumnIndex and columnIndexFromString

May 28, 2008 at 9:29 AM
Edited May 28, 2008 at 9:33 AM
And again .. I got something! I suppose it's a bug, but it could be a feature :)

: long = 1
: string = "B"

Maybe this is just the way it's designed, but I would expect both functions to start at an columnIndex of 0 or 1, but for columnIndexFromString A=1 and for stringFromColumnIndex A=0.

It's a little tricky to change the code - it could break existing scripts.
May 28, 2008 at 10:48 AM
This more like a historical bug... It's been in there for too long, and changing this would definately break someones scripts. Make sure too read the API docs, as it states base 0 and base 1.