https://bugs.freedesktop.org/show_bug.cgi?id=87386
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #3 from m.a.riosv <[email protected]> --- As indicated by the help: https://help.libreoffice.org/scalc/SC_HID_FUNC_DATUM?Language=en-US&System=WIN&Version=4.3#bm_id3149022 DATE use integers as parameters. MOD(C13,1)*100 = 8,999999999999999 8 is the integer part of the number, which is the value for DATE(). an option is ROUND(MOD(C13,1)*100) or I think better without numeric transformations extracting text. =DATE(RIGHT(D13;2);MID(D13;4;2);LEFT(D13)) =DATE(RIGHT(D13;2);MID(C13;4;2);LEFT(C13)) But perhaps the better is when importing CSV select properly the options to obtain directly date properly transformed. E.g. by selecting the original language use to create the csv. In any case I think it is not a bug. Please if you are not agree, reopen it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
