https://bugs.documentfoundation.org/show_bug.cgi?id=111992
--- Comment #5 from Eike Rathke <[email protected]> ---
I don't see the problem (the result for me is "42971" today), and furthermore
this is a very odd example.. what actually happens is that the first omitted
argument is substituted with 0 and the second argument (the TODAY() result date
serial number) is converted to string, so TEXT(,A1) evaluates to
TEXT(0,"42971")
The assumption that in Excel an omitted first argument would lead to the
General format being used IMHO doesn't hold.
--
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
