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]