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 22.214.171.124 and 126.96.36.199 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.
*** 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":
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:
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?
*** Bug 76477 has been marked as a duplicate of this bug. ***