Post Reply 
HMS numbers in the Spreadsheet App [SOLVED]
09-03-2018, 05:51 PM (This post was last modified: 11-01-2018 10:41 AM by JMB.)
Post: #1
HMS numbers in the Spreadsheet App [SOLVED]
I was working with the Spreadsheet App, when I found that HMS numbers cannot be entered directly into cells, because the [shift] [a b/c] key does not work.

I want to enter 8°30' in cell A1, so I press [8] and then [shift] [a b/c], but this key does nothing (the ° does not appear after the 8).

I have found two workarounds:
  1. Inside the Spreadsheet App I can Type →HMS(8.5) [Enter], and I get 8°30'00" in cell A1.
  2. In HOME I type 8°30' using [shift] [a b/c] as usual, then I start de Spreadsheet App and use [shift] [Menu] to paste 8°30' from HOME into cell A1.

So, is it really not possible to use [shift] [a b/c] inside the Spreadsheet App, or am I doing something wrong?

Josep Mollera. HP PRIME, HW: C, SW: 2.1.14425 (2020 01 16).
Find all posts by this user
Quote this message in a reply
09-03-2018, 06:16 PM
Post: #2
RE: HMS numbers in the Spreadsheet App
(09-03-2018 05:51 PM)JMB Wrote:  I was working with the Spreadsheet App, when I found that HMS numbers cannot be entered directly into cells, because the [shift] [a b/c] key does not work.

I want to enter 8°30' in cell A1, so I press [8] and then [shift] [a b/c], but this key does nothing (the ° does not appear after the 8).

I have found two workarounds:
  1. Inside the Spreadsheet App I can Type →HMS(8.5) [Enter], and I get 8°30'00" in cell A1.
  2. In HOME I type 8°30' using [shift] [a b/c] as usual, then I start de Spreadsheet App and use [shift] [Menu] to paste 8°30' from HOME into cell A1.

So is it really not possible to use [shift] [a b/c] inside the Spreadsheet App, or am I doing something wrong?

I use the template key (It's also Shift Units or Alpha C)
HMS template is in the lower right corner
It gives you all of the separators at once,
but you have to move the cursor
Find all posts by this user
Quote this message in a reply
09-03-2018, 06:30 PM
Post: #3
RE: HMS numbers in the Spreadsheet App
(09-03-2018 06:16 PM)CyberAngel Wrote:  I use the template key (It's also Shift Units or Alpha C)
HMS template is in the lower right corner
It gives you all of the separators at once,
but you have to move the cursor

Thanks, your workaround is better than the ones I found.

Josep Mollera. HP PRIME, HW: C, SW: 2.1.14425 (2020 01 16).
Find all posts by this user
Quote this message in a reply
09-04-2018, 05:00 AM
Post: #4
RE: HMS numbers in the Spreadsheet App
Thanks, you question reminded me to fix this.

It now will work anywhere in an editor while the CAS indicator is not lit up.

TW

Although I work for the HP calculator group, the views and opinions I post here are my own.
Find all posts by this user
Quote this message in a reply
11-01-2018, 10:41 AM
Post: #5
RE: HMS numbers in the Spreadsheet App
(09-04-2018 05:00 AM)Tim Wessman Wrote:  Thanks, you question reminded me to fix this.

It now will work anywhere in an editor while the CAS indicator is not lit up.

Solved in new version 2.1.14181 (2018 10 16). Thanks Tim!

Josep Mollera. HP PRIME, HW: C, SW: 2.1.14425 (2020 01 16).
Find all posts by this user
Quote this message in a reply
Post Reply 




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