https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #36 from Albrecht Müller <albrecht.muel...@astrail.de> --- (In reply to Eike Rathke from comment #35) > Anyway, the Excel design of using floating point values to express date+time > is fundamentally wrong, and with that inaccuracies are inevitable. Rounding > in one or the other direction will produce wrong values for some cases no > matter what and is only cosmetic to calm the user. The real solution would > be to get rid of that and use a proper DateTime type instead and convert to > floating point only when needed, e.g. when exporting to Excel file formats > or calculations require it or if a floating point display is requested. Calculations with date and time are so complicated that you probably can think that any specification of doing this kind of calculations is wrong. What makes a difference is that some specifications may be wrong in a way that is more useful than other ways. I fear that there are not enough resources to write a solid specification of the proper DateTime type you want to use. To illustrate this I collected some more or less random links to the documentation of various date and time related Java classes and packages. You can think that these mechanisms are also wrong: In order to be able to do exact calculations they use integer multiples of some basic time unit, e.g. milliseconds. This is not compatible with a physical interpretation of time where you need for example the division operation. And there are leap seconds and the irregular rotation of the earth, relativistic effects due to gravity, etc. ... Some Java classes https://docs.oracle.com/javase/8/docs/api/java/util/Date.html https://docs.oracle.com/javase/8/docs/api/java/sql/Date.html https://docs.oracle.com/javase/8/docs/api/java/text/DateFormat.html https://docs.oracle.com/javase/8/docs/api/java/util/Calendar.html https://docs.oracle.com/javase/8/docs/api/java/util/Calendar.Builder.html https://docs.oracle.com/javase/8/docs/api/java/util/spi/CalendarNameProvider.html https://docs.oracle.com/javase/8/docs/api/java/util/GregorianCalendar.html Some entry points to Java packages https://docs.oracle.com/javase/8/docs/api/java/time/package-summary.html https://docs.oracle.com/javase/8/docs/api/java/time/chrono/package-summary.html https://docs.oracle.com/javase/8/docs/api/java/time/format/package-summary.html https://docs.oracle.com/javase/8/docs/api/java/time/temporal/package-summary.html https://docs.oracle.com/javase/8/docs/api/java/time/zone/package-summary.html -- You are receiving this mail because: You are the assignee for the bug.