<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - EDITING Can't enter formula in 'argument missing, use default value instead' notation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111992#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - EDITING Can't enter formula in 'argument missing, use default value instead' notation" href="https://bugs.documentfoundation.org/show_bug.cgi?id=111992">bug 111992</a> from <a class="email" href="mailto:erack@redhat.com" title="Eike Rathke <erack@redhat.com>"> Eike Rathke</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>