We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Table cells: column Name, column Number, and column Index - how to convert?

asked 2020-11-29 18:33:20 +0200

Lupp gravatar image

updated 2020-11-29 18:38:27 +0200

This isn't actually a question, but a hook for an answer I posted to a very differently worded question.
The answer explains a few fundamental facts, and supplies user code (Basic macros) to convert column identification from the alphabetical representation to the numeric representation and reversely.

Interested users may find a suitable answer easier based on key words in this hook-question's title.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-11-29 18:37:18 +0200

Lupp gravatar image

You find my answer already mentioned in the question's text here:

The internal (technical) representation of columns by numbers prefers 0-based indices over the 1-based numbers you get in the user interface. That's the reason for what I listed both words.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-29 18:33:20 +0200

Seen: 45 times

Last updated: Nov 29 '20