Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 15 Nov 2018 15:41:08 +0100CALC: Undocumented cell format found, for astro-nav calcs in degrees:minutes:seconds and decimal seconds. I request full info soon if available.https://ask.libreoffice.org/en/question/172538/calc-undocumented-cell-format-found-for-astro-nav-calcs-in-degreesminutesseconds-and-decimal-seconds-i-request-full-info-soon-if-available/As a beginner in astronomy, I understand that:
In astro-navigation etc., angles are usually written in degrees:minutes:seconds of arc, in the form [+-dd:dm:ds.s] for latitudes -90 to +90 degrees or [+-ddd:dm:ds.s] for longitudes 0 to 180 deg east or west, or their corresponding 'Hour Angles' [+-hh:mm:ss.s] usually between +-12 hours, there being 15 degrees longitude per hour.
I find that Calc allows these formats, not documented in the "Format: Cells: Number" menus or Help.
Calc sometimes automatically 'corrects negative angles wrong' as displayed, but fortunately without changing the content of the cell as entered. I found that inserting the text prefix ' for those angles, e.g. ['-ddd:dm:ds.s] surprisingly solves the problem, preventing 'automatic correction' of entered data while still allowing its use in calculations giving correct results.
For use in trig functions [SIN() etc.] it is necessary to convert such angles to decimal format, then to radians by multiplying the decimal angle by PI()/180, and the reverse for inverse trig functions ASIN() etc.
Can 'Cell Format' and Help info be updated?GilesWThu, 15 Nov 2018 15:41:08 +0100https://ask.libreoffice.org/en/question/172538/