[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 #4 from Katarina Behrens (CIB) <Katarina.Behrens at cib.de> ---

> 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

-- 
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/03713b37/attachment.html>