To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58369
Issue #:|58369
Summary:|Sexagesimal format codes
Component:|Spreadsheet
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|ENHANCEMENT
Priority:|P3
Subcomponent:|formatting
Assigned to:|spreadsheet
Reported by:|bobharvey
------- Additional comments from [EMAIL PROTECTED] Wed Nov 23 14:41:47 -0800
2005 -------
In a similar manner to issue 58309 I would like to suggest new format codes for
sexagesimal numbers. The basic units are degrees, minutes, seconds, but there
are various sub-versions in use both for mathematics and for navigation:
ddd mm ss degrees, minutes, seconds as separate integers
ddd mm sss.s ditto, but with decimal parts of seconds
(number of decimal places may vary)
ddd mm.m degrees, minutes and decimal minutes
In the past people have modified the time formats for minutes and seconds to
simuate sexagesimal numbering, but this does not allow the decimal seconds or
decimal minutes variations used in precise navigation.
http://en.wikipedia.org/wiki/Geographic_coordinate_conversion gives a thorough,
if brief, overview of the complications involved.
I would like to suggest that OOo formalises codes for different forms of
sexagesimal representation, including decimal minutes (with arbitrary or
selectable numbers of decimal places) and decimal seconds (ditto)
It should also be possible to have numbers entered in any of the accepted
formats converted to normal decimal numbers internally.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
