Summary: | Copying and Pasting Chart looses date formatting | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | skiani |
Component: | Chart | Assignee: | Kohei Yoshida <kohei> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | bombaj-79, gerard.fargeot, imtechm, jorendc, jumbo4444, skiani, stgohi-lobugs, winfrieddonkers |
Priority: | medium | ||
Version: | 4.1.1.2 release | ||
Hardware: | Other | ||
OS: | All | ||
See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=68942 https://bugs.documentfoundation.org/show_bug.cgi?id=119882 |
||
Whiteboard: | target:4.4.0 target:4.3.0.2 | ||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Here is the source spreadsheet an chart. Notice date in bottom axis
Here is the results if you paste that chart into another appication, notice how date is messed up. |
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 *** 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. *** |
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.