Issue 86103 - Order of range data
Summary: Order of range data
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows Vista
: P4 Trivial (vote)
Target Milestone: ---
Assignee: niklas.nebel
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2008-02-14 14:56 UTC by rusivi
Modified: 2017-05-20 10:02 UTC (History)
4 users (show)

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

Attachments
Chart Wizard Screen Shot (582.06 KB, image/bmp)
2008-02-14 15:13 UTC, rusivi 		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 rusivi 2008-02-14 14:56:03 UTC 
In Calc, plotting column data via Graph Wizard Line Chart: 

Graph Wizard>Chart Type>Data Range

Calc plots column data from column top to bottom (left to right of the graph)
($Sheet1.$I$2:$I$4018), irrelevant to user specified inputs
($Sheet1.$I$4018:$I$2) indicating column bottom to top plotting (left to right
of the graph).
Comment 1 rusivi 2008-02-14 15:13:38 UTC 
Created attachment 51513 [details]
Chart Wizard Screen Shot
Comment 2 kla 2008-02-25 11:18:32 UTC 
@IHA: pls have a look if its possible to change the plots.
Comment 3 IngridvdM 2008-02-28 13:24:00 UTC 
This is the way all ranges in calc are handled. It is not a decision of the
chart in which order the values are given for a certain range strings.
->Niklas, is there something planned for the behavior of ranges in calc thus
A1:B2 is not equal B2:A1 ?
Comment 4 Edwin Sharp 2014-02-28 11:40:58 UTC 
Please attach spreadsheet.
Comment 5 Edwin Sharp 2014-03-12 12:41:37 UTC 
No info from author.
Comment 6 Andreas Säger 2014-03-14 17:55:12 UTC 
Like most users who have some problem with a line chart, the reporter wants an x/y-scatter chart which has a _numeric_ x-scale where the x values appear according to their numeric value rather than their position on the sheet.