Geometry/Microsoft Excel Column Name Updates
Dear Prof Azeem
Do you feel Column Name changes from A, B, C to 1., 2., 3., 4. will have more advantages over the current
column name as A,B,C ... i.e. Similar to IP Address example 126.96.36.199
The Record/s names will remain the same as 1,2,3 ....
For example A1 refers to Column 1, Row 1 and has value as 3 so we refer the cell value as A1=3
Now instead of A1=3, we will refer as 1.1=3
For example C4 refers to Column 3, Row 4 and has value as Hello so we refer the cell value as C4=Hello
Now instead of C4=Hello, we will refer as 3.4=Hello
Since the column name is changed from character to whole number(integer), the values in the column can go take any limits.
For example :
999.56 refers to column 999 and row 56
3456.43 refers to column 3456 and row 43
Note : Column Name should be changed to 1. (i.e. 1 followed by a Dot) and not only 1 because if we keep only 1 then for example 123 creates a ambiguity of which is the column i.e. 1 or 12.
In this example 123 will lead to column 1 , row 23 or column 12, row 3
12.3 refers to column 12, row 3
1.23 refers to column 1, row 23
Awaiting your reply,
Thanks & Regards,
Prashant S Akerkar
It is a good idea for all the reasons you mentioned. Using a comma instead of a period would also be more fitting, depending on the region.
The reason this is not currently in place is because many spreadsheets do not use a very high number of columns. It is, for many, more comfortable to refer to a cell by a letter and a number than by two numbers. Also, when entering it as a formula, it is also a bit easier because we don't have only numbers.
Thanks for asking,