Apache OpenOffice (AOO) Bugzilla – Issue 123239
Incorrect copy/paste diagrams from Calc to Writer
Last modified: 2015-05-28 23:55:23 UTC
Created attachment 81521 [details] An archive with an .ods source file and an .odt destination file. I try to build a Bar diagram in Calc and then to paste it into Writer. I use a vertical block of data (floats) as Y-values of a series and other vertical block of data (integers) as categories. Ok, the bar chart is successfully drawn, then I copy/paste it into a Writer document. The pasted picture has in Writer incorrect X-axis labels (categories) which are now not the integer values but dates (e.g., "40 45 50 55 60" has been transformed to "31.12.1989 01.01.1900 02.01.1900 03.01.1900 04.01.1900".
As given in description but with dates 02/08/1900, 02/15/1900, 02/22/1900. Rev. 1520602 Win 7
Reproduce in AOO 3.4.0 and AOO 3.4.1 as well In OOo 3.3.0 the complete X-Axis labeling is lost.
are you going to do something it's f....ng 2015???
It is not as worse as you think, when you know the reason. The chart has an axis format setting "Source format" in tab "Numbers". It is checked as default. It means, that the formatting of the axis labels are taken from the source range of the spreadsheet. When you now copy and paste the chart over to writer, the connection to the spreadsheet is lost and in turn the information which number format to use. So simple uncheck this option and format the numbers directly in the chart if necessary, before you copy the chart. *** This issue has been marked as a duplicate of issue 122714 ***
(In reply to Regina Henschel from comment #4) > It is not as worse as you think, when you know the reason. The chart has an > axis format setting "Source format" in tab "Numbers". It is checked as > default. It means, that the formatting of the axis labels are taken from the > source range of the spreadsheet. When you now copy and paste the chart over > to writer, the connection to the spreadsheet is lost and in turn the > information which number format to use. So simple uncheck this option and > format the numbers directly in the chart if necessary, before you copy the > chart. > > *** This issue has been marked as a duplicate of issue 122714 *** oh, thx