https://bugs.documentfoundation.org/show_bug.cgi?id=166014
--- Comment #3 from [email protected] --- Ahhh. The plot thickens and the difference is subtle: <c r="A46" s="29" t="n"> | <c r="A46" s="196" t="n"> <v>45454.9618055556</v> | <v>45454.96180555555</v> </c> | </c> Notice the final digit of the value. The XML on the left was written by LibreCalc. The XML on the right was originally written by LibreCalc but has subsequently been read and then rewritten with OpenPyXL (https://openpyxl.readthedocs.io/en/stable/). But ultimately the precision being used here is arguably way beyond what is useful for a datetime cell. Could/should datetime cell comparisons limit the precision somewhat to only what is useful in differentiating date/times? At least optionally perhaps with a user configurable precision perhaps as a filter option in the comparison widget? -- You are receiving this mail because: You are the assignee for the bug.
