Issue 21651 - XY charts wants X values to be sorted
Summary: XY charts wants X values to be sorted
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-24 10:11 UTC by yourcat
Modified: 2013-02-24 21:18 UTC (History)
2 users (show)

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

Attachments
Chart parametrix XY plot example Excel file (16.50 KB, application/octet-stream)
2003-10-24 10:14 UTC, yourcat 		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 yourcat 2003-10-24 10:11:50 UTC 
When plotting an XY series with Chart, Chart insists that
the X values must be in monotonic increasing order.

This makes Charts unable to show parametric two-valued functions,
very often used in scientific and engineering applications.

Excel'97 and ApplixWare 4.2 both allow any arbitrary order of
points. Importing an Excel file with a chart of non-monotonic
X values will naturally result in a broken (and, in OOo, irreprodicble)
chart. I attach a small Excel file, the chart should show a spiral
(and in Excel'97 it does).
Comment 1 yourcat 2003-10-24 10:14:23 UTC 
Created attachment 10599 [details]
Chart parametrix XY plot example Excel file
Comment 2 Regina Henschel 2003-10-24 20:32:35 UTC 
I guess, that it is an import-problem from Excel to OOo. If you create
the chart in OOo you get a spiral, you only have to say "no" when you
are asked whether OOo should sort the values.
Opening your file I get a broken chart too, OOo1.1RC?? and SO7.0 on Win98.
Comment 3 yourcat 2003-10-25 00:43:18 UTC 
Indeed. I have tested it and as it turns out, it is not the
Excel import. Chart can plot the piral if you use line
segments. However, if you want to use cubic spline or B spline,
it bombs out. You can try it easily: In the imported chart
change chart type to XY line segments, it will be OK.
If you create a separate chart with the data in the sheet,
change the type to XY spline, the OOo created chart will be just
as broken as the imported one.

Therefore, I close this issue as INVALID and open an other one,
severity Bug, about the cubic and B splines being broken on
XY xharts.
Comment 4 kla 2004-05-24 12:42:53 UTC 
tk-> Yourcat: i close it for you.