<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#c4">Comment # 4</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:Katarina.Behrens@cib.de" title="Katarina Behrens (CIB) <Katarina.Behrens@cib.de>"> Katarina Behrens (CIB)</a> <pre> > The format has to be precised. > A1=42971 > B1=TEXT(A1;"DD/MM/YY") > 24/08/17 with English (USA) pattern Well it doesn't have to be specified in MS Excel. If it is not specified AND the formula is written in this odd missing arguments notation, the default (General, @) format is used It just won't work in Calc and this is a real issue for a customer who wants to migrate their spreadsheets from MSO + xlsx to LibO + ods (fwiw we already advised them to use =TEXT($address, "@") workaround) > Maybe this depens on the character used as separator for dates on the > Locale, with Spanish '/'. and yes, it depends on locale (or user settings, Tools > Options > LibO Calc > Formula), you have to use locale-specific argument separator</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>