HP Forums
All Spreadsheet column headers upper-case except g? - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: All Spreadsheet column headers upper-case except g? (/thread-18323.html)



All Spreadsheet column headers upper-case except g? - 8bit - 05-02-2022 09:27 PM

Prime G2 on 2021 12 02 firmware.

A niggly little thing but shows a lack of polish/attention to detail.

Has this been noted/reported before?


RE: All Spreadsheet column headers upper-case except g? - Joe Horn - 05-02-2022 09:45 PM

It was necessary, intentional, and documented. The HP Prime User Guide says, "Note that the alphabetic component of column names can be uppercase or lowercase except for columns g, l, m, and z. (G, L, M, and Z are names reserved for graphic objects, lists, matrices, and complex numbers.)".


RE: All Spreadsheet column headers upper-case except g? - 8bit - 05-02-2022 09:49 PM

Glad to know it’s by design.


RE: All Spreadsheet column headers upper-case except g? - Joe Horn - 05-02-2022 09:57 PM

Ooh, I forgot to include the important text following what I quoted above:

Quote:These must be in lowercase if not preceded by $. Thus cell B1 can be referred to as B1,b1,$B$1 or $b$1 whereas M1 can only be referred to as m1, $m$1, or $M$1.

So if you really want to use uppercase all the time, you can, if you remember to prepend the dollar sign. But it's easier to always omit the dollar sign and always user lowercase.