https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #41 from Albrecht Müller <albrecht.muel...@astrail.de> --- (In reply to Regina Henschel from comment #40) > ... > How would you then solve the request to have functions, that behave like > Excel? Due to the way the ODF specification is written this problem is not so easy to solve as it looks. It may help trying to analyse it thoroughly before taking action. Eike probably is against the rounding specification because he knows that this will make the YEAR, MONTH, DAY etc. functions inconsistent with the specifications of many other functions that somehow do date and time calculations. On the other hand this implies that all these functions may show pseudo random results caused by truncation. For an example see the last paragraph of my comment #37. As a consequence all date and time related functions need an overhaul… Just my 2 ¢. -- You are receiving this mail because: You are the assignee for the bug.