https://bugs.documentfoundation.org/show_bug.cgi?id=127170
--- Comment #15 from Albrecht Müller <[email protected]> ---
(In reply to Jaromir / [email protected] from comment #14)
> In my opinion -45 minutes should be always treated as "-00:45" (that is
> [HH]:MM).
How would you then represent something like "1899-12-29 23:15:00" or - a more
common case - like "2020-04-23 19:33:05"?
> Involving reference points makes a mess: you always have to
> remember your "startpoint".
This was never a problem for me: Not I have to remember the reference point but
the spreadsheet program has to know where it is. But I understand that this may
cause trouble as there are different conventions. How would you define points
in time without some reference point?
> Yes, it is possible to maintain double (float/integer) operations for each
> time/date value. But for the price of unnecessary overloading.
I don't understand this argument: Depending on the context time may be seen as
continuous process or a sequence of countable ticks. So both a float and an
integer representation may be adequate. In the context of date and time
calculations the error recovery mechanism is not very complicated.
> Let's use it only in very situations: when backward compatibility is required.
I consider this a pretty important use case. If written on paper you can read
calculations that are hundreds of years old. How long should it be possible to
access contents of spreadsheets?
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
