Issue 122714 - First column label values change to calendar date when copy/paste chart to other AOO application
Summary: First column label values change to calendar date when copy/paste chart to ot...
Status: CLOSED DUPLICATE of issue 121418
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal with 4 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 123239 123794 124100 124149 126192 (view as issue list)
Depends on:
Reported: 2013-07-10 09:34 UTC by Edwin Sharp
Modified: 2021-04-13 22:22 UTC (History)
12 users (show)

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

Sample Document (17.42 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2014-01-02 06:41 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Edwin Sharp 2013-07-10 09:34:43 UTC
Please refer to bug 112829
Comment 1 Armin Le Grand 2013-07-10 10:12:54 UTC
ALG: Thanks Edwin. I compared with OOO3.3. Main reason are the fixes for #120559# and #118840#.
In OOo3.3 the data is not copied at all, but this gets not visible immediately. The saved, last layout and graphic of the chart is used after paste. This leads to empty charts as soon as these get activated once.
In AOO4.0 the data is copied and the chart is re-layouted after paste. The initial copy of data happens when the copy is prepared (on CTRL-C) in a temporary model. In that stage the format of the cells may be ignored/handled wrong or even may not be copyable to the local chart data model at all, needs investigation.
This was probably never done/always wrong, but gets visible now as the data gets copied.
Comment 2 Rainer Bielefeld 2014-01-02 06:30:33 UTC
I haven't a clue concerning what problem this report might be - Bug 112829 mentions half a dozen problems ...
Comment 3 Rainer Bielefeld 2014-01-02 06:40:02 UTC
Steps how to reproduce with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions

1. Open attached sample document from AOO Start Center
2. click second chart
3. <control+c> for copy
4. Menu 'File -> New -> Text Document'
   > Writer document opens
5. <control+v> for paste
   Expected: normal number values at axis
   Actual: X-axis with dates 

Problem does not appear if you use first chart without checked "First column as label
Comment 4 Rainer Bielefeld 2014-01-02 06:41:29 UTC
Created attachment 82197 [details]
Sample Document

See comment above how to use
Comment 5 Rainer Bielefeld 2014-01-02 06:58:07 UTC
Already Reproducible with server installation of  "AOO 3.4.1 – Norvegian UI / German locale [AOO341m1(Build:9593) - Rev.1435053]" on German WIN7 Home Premium (64bit)", own separate user profile

Result was still ok with OOo 3.3.0 and OOo 3.1.1
Comment 6 Rainer Bielefeld 2014-02-05 17:49:45 UTC
I did an additional test, seems to happen during Copy-Process to clipboard:
* Copy chart from AOO Calc -> Paste to OOo 3.3.0 Writer shows the problem
 ** Date problem also appears when I paste to Softmaker Freoffice TextMaker
* Copy chart from  OOo 3.3.0 Calc -> Paste to AOO (4.0.1) Writer works fine

This one is a horrible mess (for me)
Comment 7 Rainer Bielefeld 2014-03-28 12:08:06 UTC
*** Issue 123794 has been marked as a duplicate of this issue. ***
Comment 8 jmpoo 2014-04-09 16:46:48 UTC
Pasting the second chart from the attached sample document into Writer looks as expected, if "Format > Axis > x-Axis > Numbers > source format" is disabled.

But opening the "Chart Data Table" shows date values.

Tested with AOO 3.4.1 and daily build AOO 4.1 r1573062 german
Comment 9 Paul 2014-06-19 17:49:38 UTC
It has been almost a year since this was reported, is there a fix/workaround for this issue?
Comment 10 jeffooo 2015-03-02 18:04:50 UTC
Already Reproducible with AOO 4.1.1 and AOO420m1(Build:9800)  -  Rev. 1658822 under Windows 7

If "Format > Axis > x-Axis > Numbers > source format" is disabled in Calc before paste on Writer, axis format in Writer is good (number, not date)

Please, adjust keyword = Regression

Comment 11 oooforum (fr) 2015-03-23 08:55:52 UTC
*** Issue 126192 has been marked as a duplicate of this issue. ***
Comment 12 Regina Henschel 2015-05-27 19:40:05 UTC
*** Issue 123239 has been marked as a duplicate of this issue. ***
Comment 13 Regina Henschel 2015-05-27 19:41:56 UTC
*** Issue 124149 has been marked as a duplicate of this issue. ***
Comment 14 Regina Henschel 2015-05-27 19:50:53 UTC
*** Issue 124100 has been marked as a duplicate of this issue. ***
Comment 15 Marcus 2017-05-20 10:44:23 UTC
Reset the assignee to the default "".
Comment 16 oooforum (fr) 2021-04-13 06:38:57 UTC
Problem seems related to 'Format -> Axis -> Numbers -> Source Format = ticked"
Once unchecked, the chart keeps its axis right.

*** This issue has been marked as a duplicate of issue 121418 ***