https://bugs.documentfoundation.org/show_bug.cgi?id=87386
Matthew Francis <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #9 from Matthew Francis <[email protected]> --- Unfortunately this is simply not a proper use of general numbers, and will never work reliably. Floating point numbers just don't work that way. Format the columns as dates, and use the DAY(), MONTH() and YEAR() functions as appropriate - or if you must, format all the columns as text so that the text based dissection you are attempting has a chance of succeeding. Closing this bug again. -- 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
