Calc currently does not recognize "Jan1, 2015" as a valid date format. Sadly excel recognizes it which causes some interop problems.
@Eike: would it be easily possible to recognize that as number format without fully supporting it? Like mapping it during format recognition to the same one as "Jan 1, 2015"?
That already worked at some time..
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=fe2c7b25152df4c89e44c6516081d43d68075736 Resolves: tdf#91420 "Jan1, 2015" is a valid date It will be available in 5.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4e7a17ad3a0c0f30d70bd4166f075e6c253debad&h=libreoffice-5-0 Resolves: tdf#91420 "Jan1, 2015" is a valid date It will be available in 5.0.0.0.beta2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review at https://gerrit.libreoffice.org/16018 for 4-4
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bd4f115484e9955045a50131c84685823a5af078&h=libreoffice-4-4 Resolves: tdf#91420 "Jan1, 2015" is a valid date It will be available in 4.4.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/356628a18e44574810ebad27dc2d499b718094bc tdf#34724, tdf#91420: svl_qa_cppunit: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.