Grab from bug #71075 the test file: https://bugs.freedesktop.org/attachment.cgi?id=88396 Now paste-as-GDI-metafile the data; notice that the chart x axis legends instead of being textual dates are numbers: not ideal :-)
Tested and confirm in L.O. 4.1.3.2 x86. Not only date format but also comma-seperated number formats are changed to general numbers. Text format seems not affected.
As with any other chart bugs, this one is also hard-to-solve both conceptually and implementation-wise.... Workaround is to uncheck the "Source Format" in the number format dialog for the X-axis option dialog, then the format will get carried over just fine.
Already spent close to a week on this. Hopefully the end is near.
This seemingly innocuous little mis-behavior is caused by a collection of many different issues each of which is non-trivial to solve... :-(
Finally got to the bottom of this. What a journey...
Thank you very much, Koei :-)
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1d38cb365543924f9c50014e6b2227e77de1d0c9 fdo#71076, fdo#71767: Preserve number formats when charts are copied. 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.
4.3 backport: https://gerrit.libreoffice.org/9835 https://gerrit.libreoffice.org/9836
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=01dd299bded81700bc976881c6ea954a09015f9f fdo#71076: Write test for this. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=22cd19eeeb476c40b68bb1ff040fce6103fdeba4&h=libreoffice-4-3 fdo#71076, fdo#71767: Preserve number formats when charts are copied. It will be available in LibreOffice 4.3. 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.
Fixed in 4.3.
*** Bug 68940 has been marked as a duplicate of this bug. ***
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=388f2fa9fcabe1b2adaff282fa9509216f3af6de&h=libreoffice-4-2 fdo#71076, fdo#71767: Preserve number formats when charts are copied. It will be available in LibreOffice 4.2.7. 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.
*** Bug 68942 has been marked as a duplicate of this bug. ***