# CALC: Undocumented cell format found, for astro-nav calcs in degrees:minutes:seconds 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?

you

request soonwhat?wrt your "inquiry": please be more specific which format you use, which values give you what, and why it's incorrect. The description you gave uses some strange format specifiers possibly valid for your area, but not for calc.