Description: I create an XY chart with Lines and Points in Calc with the X-values being dates. I can hover over the points in the chart and it will show the date in the proper format in Values (Ex. 2017-09-05). I copy/paste that chart into Writer using the default Paste (Start Object Descriptor (XML)) and when I hover over a point it shows the date as an integer (Ex. 42983) Steps to Reproduce: 1. create an XY chart with Lines and Points in Calc with the X-values being dates 2. copy/paste that chart into Writer using the default Paste Actual Results: when I hover over a point in the chart in Writer it shows the date as an integer (Ex. 42983) Expected Results: when I hover over a point in the chart in Writer it shows the date as a date with the correct format (Ex. 2017-09-05) Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36
Created attachment 136041 [details] copy/pasted chart in Writer
Created attachment 136042 [details] original chart in Calc
The option "Source format" in tab Numbers in the properties of the x-axis is checked as default. When you copy the chart to Writer, the connection to the Spreadsheet is removed. Then the chart does not know that the value has to be presented as date. Uncheck the option and format the dates manually before you copy the chart to Writer. I cannot confirm the described behavior for Version: 6.0.0.0.alpha0+ Build ID: 6c68f38bc28bb55a4f0d53b8f38957516d3935d1 CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2017-09-04_22:05:26 Locale: de-DE (de_DE); Calc: group For me copy&paste works the workaround to uncheck the option. Someone with Mac OS has to test it.
Hello Michael, Could you please test it unchecking the option mentioned by Regina in comment 3? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the problem still persists.
Regina, I'm not sure what you mean by "format the dates manually". Do you mean setting the date format in the X-Axis dialog box, after unchecking the Source Format box? I did this and then copy/pasted it into Writer and the problem still exists (dates show up as integers in Writer). Also, the problem doesn't happen if I use a Bar chart instead of an XY chart with Lines and Points. When I create a Bar chart with dates for the x-axis in Calc and copy/paste it into Writer, the dates show up with the proper format in Writer. This happens even if the Source Format box is checked in the X-Axis dialog Numbers tab of the Bar chart.
Created attachment 136067 [details] with Source Format unchecked
Created attachment 136068 [details] with Source Format unchecked
Created attachment 136069 [details] bar chart
Created attachment 136070 [details] bar chart
The attached files look correct here. So the problem might be OS dependent or something is broken in your user profile. Have you already tried to reset it? https://wiki.documentfoundation.org/UserProfile. Do you have access to a different PC to test it there?
I tried resetting my user profile and using a different machine (32-bit Windows 7) and the problem still exists. I created an XY chart with Lines and Points in Calc with the X-values being dates and I unchecked the Source Format box (created the same file as the "with Source Format unchecked" attachment). When I pasted it into Writer the dates lost their format and showed up as integers when I hover over the data points.
I think, I understand your problem now. You do not speak about axis or labels but about the yellow tooltip box, which is available only in edit mode of the chart. Yes for these boxes I see the wrong number format too.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Dear Michael Viveros, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Same in OOo 3.3 -> inherited. Still reproduced in recent trunk build: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 709866a3b8e073fab4937dcf91dcd33ff1d2bc13 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded Somewhat similar to bug 142108.