Post Reply 
All Spreadsheet column headers upper-case except g?
05-02-2022, 09:27 PM
Post: #1
All Spreadsheet column headers upper-case except g?
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?
Find all posts by this user
Quote this message in a reply
05-02-2022, 09:45 PM
Post: #2
RE: All Spreadsheet column headers upper-case except g?
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.)".

<0|ɸ|0>
-Joe-
Visit this user's website Find all posts by this user
Quote this message in a reply
05-02-2022, 09:49 PM
Post: #3
RE: All Spreadsheet column headers upper-case except g?
Glad to know it’s by design.
Find all posts by this user
Quote this message in a reply
05-02-2022, 09:57 PM (This post was last modified: 05-02-2022 09:58 PM by Joe Horn.)
Post: #4
RE: All Spreadsheet column headers upper-case except g?
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.

<0|ɸ|0>
-Joe-
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 




User(s) browsing this thread: 1 Guest(s)