HP Forums - 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:

Inside the Spreadsheet App I can Type →HMS(8.5) [Enter], and I get 8°30'00" in cell A1.
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?

(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:

Inside the Spreadsheet App I can Type →HMS(8.5) [Enter], and I get 8°30'00" in cell A1.

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

(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.

Thanks, you question reminded me to fix this.

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

(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!