Comment on Converting numbers is easy
lemmydripzdotz456@lemmy.world 1 week ago
I cannot imagine that a significant percentage of Excel power users care what column number ABC is. You use either A1 notation or R1C1 notation based on your need. You don’t have to convert between the two. You can even use the INDIRECT() function to reference a cell either way regardless of your general settings. In VBA, you can use Range(“A1”) or Cells(1,1) to reference cells with either notation. Either are always options. Conversion is not necessary.
Why do you assume I’m doing this inside Excel? I was importing a data sheet into other software. By the time I got my hands on the data, it was an object of the sort {A: [/*data*/], AA: [/*data*/], B: [/*data*/]}. I had to sort the keys for presentation purposes.
In retrospect, sure, there would’ve been easier ways. But at the time I wasn’t aware yet that converting Excel columns to numeric indices isn’t as straightforward as a simple base conversion (like, e.g. from hex to decimal).
Ah, that does make a lot of sense. Excel does not play well with others. It can’t even play nicely with CSV.
phdepressed@sh.itjust.works 1 week ago
This isn’t a question of functionality but just whether a system whether basic arithmetic, music, etc makes logical/intuitive sense.
Imperial measurements using feet, yards, mph, etc instead of metric centimeters, meters, kph, etc. Sure imperial works but it doesn’t make the same sense that metric does. Math can be done in base 2, base 60 or whatever it doesn’t make the same sense as base 10.