Issue 123239 - Incorrect copy/paste diagrams from Calc to Writer
Summary: Incorrect copy/paste diagrams from Calc to Writer
Status: CLOSED DUPLICATE of issue 122714
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Major with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-09-11 18:35 UTC by pvozerski
Modified: 2015-05-28 23:55 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Attachments
An archive with an .ods source file and an .odt destination file. (20.88 KB, application/zip)
2013-09-11 18:35 UTC, pvozerski 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pvozerski 2013-09-11 18:35:04 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".
Comment 1 Edwin Sharp 2013-09-12 05:25:46 UTC 
As given in description but with dates 02/08/1900, 02/15/1900, 02/22/1900.

Rev. 1520602 Win 7
Comment 2 Oliver-Rainer Wittmann 2013-09-12 11:45:25 UTC 
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.
Comment 3 e_g1gor 2015-05-26 23:19:31 UTC 
are you going to do something it's f....ng 2015???
Comment 4 Regina Henschel 2015-05-27 19:40:05 UTC 
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 ***
Comment 5 e_g1gor 2015-05-28 23:55:23 UTC 
(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