[Libreoffice-bugs] [Bug 111992] EDITING Can't enter formula in 'argument missing, use default value instead' notation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=111992

--- Comment #5 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170824/602fbbe3/attachment.html>