mike scott wrote:
On 14 Jun 2008 at 12:40, Harold Fuchs wrote:
2008/6/14 mike scott <[EMAIL PROTECTED]>:
On 14 Jun 2008 at 9:37, Harold Fuchs wrote:
2008/6/14 JOE Conner <[EMAIL PROTECTED]>:
In Calc I would like to format a cell containing a number such as
189.25 to
display such as 180 15.
This can represent 189 and 1/4 degrees displayed as 189 minutes 15
seconds.
...
(I assume, btw, the op wants to display "189 and 1/4 degrees"
displayed as "189 degrees 15 minutes" though, and not as stated!! )
You can include text in the format string. So, for example (using <> as
quotes for the purposes *only* of this message) <[HH]\° MM\"> gives <189°
15"> and <[HH] "degrees" MM "minutes"> gives <189 degrees 15 minutes>. The
backslashes merely "escape" the degree sign and the double quote (minute)
sign.
Yes, I know. But since the [] construct isn't documented (& how on
earth did you think to use this!!) I wonder what else is tucked away.
But I was really commenting in passing on the OP's typo. If he really
wants his angles formatted like that, he's going to lose his way
rather quickly :-)
But it's a nasty hack. The number format stuff should be flexible to
allow this formatting directly.
Motion seconded. I'm surprised there is no formatting for
degrees/minutes/seconds.
Yes. If bugzilla weren't so confusing I'd log an feature request.
Angles are hardly bleeding edge technology
Thanks to everyone who contributed. I attempted to submit a request for
enhancement to include this, but it had already been requested.
See http://www.openoffice.org/issues/show_bug.cgi?id=58369 if you want
to vote for it.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
