https://bugs.freedesktop.org/show_bug.cgi?id=83116
--- Comment #8 from ariel cornejo <[email protected]> --- (In reply to Owen Genat from comment #7) > (In reply to ariel cornejo from comment #5) > > I just tried with version 4.4.0.0.alpha0 > > (24fb87501ef9d5aa715d572de7eb5efe49a0d9c3). Values in rows > > 4,14,15,25,26,36-40 are imported as text: > > That is quite a strange result. I have no problem here using: > > v4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a > v4.2.6.3 Build ID: 3fd416d4c6db7d3204c17ce57a1d70f6e531ee21 > v4.3.2.2 Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d > v4.4.0.0.alpha0+ Build ID: e21f6e3838a64f6c2517479d021e943e2ffcab94 > TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: > 2014-10-10_09:04:45 > > Even selecting "Date (YMD)" on the column is unnecessary. The "Detect > special numbers" option seems to be sufficient to import all values as > dates, which can then be formatted to display as required. I just tried "Detect special numbers" and it works just like you say. Did you tick it for the tests you describe above? Anyway, it's not obvious that it should be used and the conversion otherwise definitely shouldn't depend on the *value* of the decimal part. Something is failing silently. I'm intrigued by m.a.riosv's suggestion in #1 but am clueless as to why the conversion works so differently depending on where it's called from. -- 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
