Created attachment 89437 [details] Here is the source spreadsheet an chart. Notice date in bottom axis When copying and pasting a chart with dates as part of chart from Calc to other LO or other applications the the date gets converted to a code. There is no way to copy and paste without this loss. Only way is take screen shot and crop the bitmap. Not a very acceptable work around. I will add attachment to illustrate.
Created attachment 89438 [details] Here is the results if you paste that chart into another appication, notice how date is messed up.
In Calc (as in Excel), a Date is a number, formatted with a "date", "time" ou "datetime" format. Clearly in your copy the date value is copied (41308 is the 3rd of February 2013 00h00) but the format is lost. Impress also provides a way to format a number as a date (right clic on the graph X axis > Format Axis > Numbers > Category > Date/Time). Where both source and destination provide a date/time formatting, one could reasonably expect that the format is copied along with the values. IMHO Bug.
Just tested in 3.5.4. No problem there, so definitely a regression.
Reproducible with 4.1.3.2 and 4.0.6.2 when format of numbers/dates of X-Axis are dependant on Data series format : i.e Source format checked in Format Axis > Number. When this checkbox is unticked and date format set in this dialog (thus not related to the source), formatting is correctly pasted. Set to New as confirmed by different people.
I fixed this one as part of Bug 71076. Different root causes, but similar symptoms.
*** Bug 61805 has been marked as a duplicate of this bug. ***
Since auto commit notification didn't notify this one, here is the commit that fixes it. http://cgit.freedesktop.org/libreoffice/core/commit/?id=1d38cb365543924f9c50014e6b2227e77de1d0c9
4.3 backport: https://gerrit.libreoffice.org/9835 https://gerrit.libreoffice.org/9836
*** Bug 79145 has been marked as a duplicate of this bug. ***
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=aac149e4ad06e207e6c1b14f11867dbfbd343ab2 fdo#71767: 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.
No automatic notification, but this is now backported to the 4.3 branch.
*** Bug 80554 has been marked as a duplicate of this bug. ***
Is Bug 68942 the same cause? If so, any plan to backport the commit to 4.2? Thanks.
*** Bug 76477 has been marked as a duplicate of this bug. ***