https://bugs.documentfoundation.org/show_bug.cgi?id=111992
--- Comment #4 from Katarina Behrens (CIB) <[email protected]> ---
> 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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
