hello,
i have a doubt about how to write a switch case for a big program like spreadsheet wherein i give the values starting from A=0,B=1,C=2,...Z=25,AA=26,AB=27,....AZ=..and so on up to ZZ=701
i am not understanding how to write such a big switch case.could someone help me out with the logic.
Regards,
cutelucks
First of all, you probably don't want to do it that way!
Second, what is it you are having trouble with - it seems straight forward enough, aside from being very tedious and longwinded.
--
Mats
Compilers can produce warnings - make the compiler programmers happy: Use them!
Please don't PM me for help - and no, I don't do help over instant messengers.
700 cases?
Surely the model for a spreadsheet looks something like a 2D array, and you perform some calculation to turn say "AB" into an array subscript.
If you understand base 10, then this would be base 26.
If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
If at first you don't succeed, try writing your phone number on the exam paper.
