Issue 103007 - Chart Data Table incorrectly plotted in Standalone x-y scatter data plot
Summary: Chart Data Table incorrectly plotted in Standalone x-y scatter data plot
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 All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-22 15:37 UTC by mathuhenry
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

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


Attachments
OP's example data (16.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-06-23 02:44 UTC, tomwb
no flags Details
Text document with pasted chart (Star Object Descriptor(XML)) before edit (16.61 KB, application/vnd.oasis.opendocument.text)
2009-06-23 02:47 UTC, tomwb
no flags Details
Example showing altered pasted chart after entering edit mode (16.60 KB, application/vnd.oasis.opendocument.text)
2009-06-23 02:48 UTC, tomwb
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mathuhenry 2009-06-22 15:37:56 UTC
Note: I don't see how to upload the original files here. I'm not confident that
this bug is consistent.

1) In spreadsheet, I make a simple x-y scatter plot of the data listed at the
end. Define each set of y data according only to the applicable x data. (Exempi
gratia, Y2 only includes x values 0 through 4.) If the whole x and y column for
each series is included, then the Chart Data Table will show only 1 x column,
and the plot will be correct.
2) I copy (ctrl c) and paste (ctrl v) the figure into a text file. The figure is
altered such that the third plot is correct, but the other two are offset by one
point.
3) I enter the Chart Data Table and see that the data is still correct. However,
there are no "Data Labels" and each series has its own (correct) x column.
4) I try to alter the x-axis data, and no change is observed (y-axis responds fine)

Speculation: I think this bug was introduced after OpenOffice.org 3.0 (which is
when I started using this feature). I think this is strictly a viewing problem
because I see no evidence that the actual data is being altered.

X	Y1	Y2	Y3
0	0.0278	0.0049	0.0663
1	0.1585	0.0729	0.193
2	0.3172	0.3411	0.2676
3	0.3052	0.5811	0.2411
4	0.1621	0	0.144
5	0.0292		0.0658
6	0		0.0164
7			0.0047
8			0.001
9			0.0001
10			0
11			0
12			0
13			0
14			0
15			0
16			0
Comment 1 tomwb 2009-06-23 02:44:12 UTC
Created attachment 63152 [details]
OP's example data
Comment 2 tomwb 2009-06-23 02:47:22 UTC
Created attachment 63153 [details]
Text document with pasted chart (Star Object Descriptor(XML)) before edit
Comment 3 tomwb 2009-06-23 02:48:57 UTC
Created attachment 63154 [details]
Example showing altered pasted chart after entering edit mode
Comment 4 tomwb 2009-06-23 02:52:49 UTC
Confirmed that pasted chart into odt document is altered after entering edit mode.
Documents attached showing changes.

TomW
OOO310m11 Vista SP2
Comment 5 IngridvdM 2009-06-24 16:25:02 UTC
I can confirm the problem also and also on windows. This is the same problem as
already reported with issue 102428. Empty cells in the charts data table are
wrongly taken as text content and produce an invalid input for the x-values. If
issue 102428 is fixed this will be fixed also. Thanks for the report!

*** This issue has been marked as a duplicate of 102428 ***
Comment 6 IngridvdM 2009-06-24 16:25:46 UTC
closed as duplicate