Issue 106903 - Data-loss when copying chart from calc and pasting into writer
Summary: Data-loss when copying chart from calc and pasting into writer
Status: CLOSED DUPLICATE of issue 102428
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: IngridvdM
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-13 15:25 UTC by berst
Modified: 2013-02-24 21:20 UTC (History)
1 user (show)

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


Attachments
CSV-Data file to reproduce issue 106903 with calc and writer of open office v 3.1 (2.02 KB, text/csv)
2009-11-13 15:28 UTC, berst
no flags Details
example spreadsheet created from given csv data (29.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-11-17 15:37 UTC, IngridvdM
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description berst 2009-11-13 15:25:03 UTC
I'm having some trouble when copying charts out of a spreadsheet file into an
open document text file in open office 3.1.
Normally simple charts can be copied by ctrl+c and pasted by ctrl+v without
problems into writer-files. 
If I'm constructing more complex charts from scientific data the charts somehow
are broken in one or the other way. I have constructed a line-chart with 2
data-series, which looks perfectly right in calc but after copy-paste into
writer one of the 2 data-series is inverted for no reason.

To reproduce this issue use this sample-data in csv-Format:

,,,,
"x1","y1",,"x2","y2"
13.1,0.13187,,58.9,0.05144
13.4,0.13199,,58.4,0.05185
13.9,0.13208,,57.6,0.05209
14.6,0.13185,,56.7,0.05214
15.3,0.13171,,55.8,0.05240
16.1,0.13174,,54.9,0.05252
16.8,0.13145,,54,0.05269
17.6,0.13149,,53.1,0.05309
18.4,0.13142,,52.2,0.05357
19.2,0.13112,,51.3,0.05408
20,0.13126,,50.5,0.05516
20.8,0.13103,,49.5,0.05640
21.7,0.13091,,48.6,0.05817
22.5,0.13086,,47.7,0.06010
23.3,0.13074,,46.8,0.06342
24.1,0.13036,,46.2,0.06566
25,0.13016,,45.6,0.06816
25.9,0.13010,,45.2,0.07100
26.7,0.12979,,44.7,0.07385
27.2,0.12976,,44.2,0.07716
27.6,0.12953,,43.7,0.08055
28.1,0.12943,,43.2,0.08418
28.6,0.12929,,42.7,0.08797
29.1,0.12920,,42.2,0.09172
29.5,0.12909,,41.8,0.09538
30,0.12880,,41.3,0.09914
30.5,0.12857,,40.9,0.10260
30.9,0.12837,,40.4,0.10606
31.4,0.12811,,39.9,0.10890
31.9,0.12764,,39.5,0.11172
32.3,0.12750,,39,0.11411
32.8,0.12701,,38.6,0.11613
33.3,0.12677,,38.1,0.11798
33.8,0.12627,,37.6,0.11977
34.3,0.12569,,37.1,0.12100
34.7,0.12524,,36.7,0.12263
35.2,0.12450,,36.2,0.12361
35.7,0.12393,,35.8,0.12468
36.2,0.12296,,35.4,0.12529
36.6,0.12190,,35,0.12610
37.1,0.12061,,34.5,0.12688
37.6,0.11948,,34.1,0.12730
38.1,0.11789,,33.7,0.12764
38.5,0.11586,,33.2,0.12831
39,0.11388,,32.8,0.12865
39.5,0.11145,,32.4,0.12885
39.9,0.10870,,32,0.12920
40.4,0.10548,,31.6,0.12961
40.9,0.10222,,31.2,0.12987
41.4,0.09875,,30.8,0.12987
41.8,0.09500,,30.4,0.13026
42.3,0.09125,,29.9,0.13037
42.8,0.08713,,29.5,0.13039
43.3,0.08322,,29.1,0.13071
43.7,0.07912,,28.7,0.13071
44.2,0.07556,,27.9,0.13147
44.7,0.07227,,27.1,0.13173
45.1,0.06905,,26.3,0.13214
45.6,0.06616,,25.5,0.13226
46.3,0.06212,,24.7,0.13249
47.2,0.05879,,23.9,0.13260
48.1,0.05620,,23.1,0.13280
49,0.05434,,22.3,0.13292
49.9,0.05318,,21.5,0.13321
50.9,0.05234,,20.7,0.13316
51.8,0.05157,,19.8,0.13319
52.7,0.05135,,19,0.13351
53.7,0.05080,,18.2,0.13359
54.6,0.05083,,17.4,0.13385
55.5,0.05077,,16.6,0.13402
56.4,0.05049,,15.8,0.13420
57.4,0.05086,,14.9,0.13411
58.3,0.05067,,14.1,0.13434
59.2,0.05098,,,

Open this csv-file with calc, then copy the data into a new spreadsheet.
Create a chart of the type xy-scatter using the chart button in calcs toolbar.
Choose lines only, click next, ignore the field data range and click next.
Click add to add a new data-series.
Leave the name blank.
Use the column x1 as x-values for data-series one.
Use the column y1 as y-values for data-series one.
Click add to add a new data-series.
Leave the name blank.
Use the column x2 as x-values for data-series two.
Use the column y2 as y-values for data-series two.
Click finish.
Click anywhere in the spreasheet document to deselect the chart.
Then click on the chart to select it again and press ctrl+c to copy it.
Open a new writer document and paste the chart by pressing ctrl+v into it.
The graph of data-series one will be inverted, which should not happen.
Comment 1 berst 2009-11-13 15:28:22 UTC
Created attachment 66107 [details]
CSV-Data file to reproduce issue 106903 with calc and writer of open office v 3.1
Comment 2 IngridvdM 2009-11-17 15:37:27 UTC
Created attachment 66154 [details]
example spreadsheet created from given csv data
Comment 3 IngridvdM 2009-11-17 15:44:52 UTC
I can reproduce the problem with OOo 3.1. It is fixed already with issue 102428
for OpenOffice.org 3.2. As long as you use OOo 3.1 you can work around the
problem by deleting the last row containing the empty cells for the second
series or just fill in some values there. The empty cells are not correctly
handled in that version. Thanks for the report!
Comment 4 IngridvdM 2009-11-17 15:46:03 UTC
setting to duplicate of issue 102428

*** This issue has been marked as a duplicate of 102428 ***
Comment 5 IngridvdM 2009-11-17 15:46:49 UTC
closing issue as duplicate