Hi Florent, On Saturday, 2012-04-28 06:53:34 +0200, Florent Gallaire wrote:
> Probably the problem is the global calc behaviour and won't be fixed. Wrong ;-) It is already fixed with the locale dependent date acceptance patterns recently implemented. Anyway, this is not really related to the "export as shown" option that is general to all number formats. > For me "=4/2" is the number "2", and "4/2" should always be the string > "4/2" and never the evil "02/04/12", which should only be the result > of "=DATE(2012;2;4)". Actually no. In en_US locale it is expected that the input of 4/2 results in 04/02/12, of course that is not desired in other locales that use a different date separator. What the fix mentioned is about. For details see http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
pgpqQD76gpHhC.pgp
Description: PGP signature
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
