Issue 82727

Summary: Range of x axis too high in xy scatter, please make this customazable
Product: General Reporter: dudson <petertrypsteen>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: daniel.rentz, issues
Version: 3.4.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: 4.0.1
Developer Difficulty: ---
Attachments:
Description Flags
A, ods file which shows two example graphs none

Description dudson 2007-10-17 19:52:58 UTC 
When making a graph from some data in a calc sheet. 
The Graph wizard at the end makes the x-scale too large.
(see example, it should stop at 24 but for some reason it continues to 30)

This is not very pleasant behaviour, knowing there is space on paper wasted when
this is printed out.
Comment 1 dudson 2007-10-17 19:58:50 UTC 
Created attachment 48975 [details]
A, ods file which shows two example graphs
Comment 2 dudson 2007-10-17 20:25:25 UTC 
It always goes 6 too high on the x-axis
Comment 3 kla 2007-10-19 09:44:48 UTC 
@bm: I think the way we are use is the better one, but maybe we can discuss it.
Comment 4 dudson 2007-10-19 16:42:23 UTC 
The best way to settle this is making it a setting in settings/charts, 
then the user can specify how much extra space he or she wants on the x and
other axes.
Comment 5 dudson 2007-10-19 17:38:59 UTC 
Is what I described just above a good idea to solve this?
Comment 6 dudson 2007-10-20 17:27:21 UTC 
(for each diagram type independent settings please)
(This way each diagram has it's own settings because the different kinds of
diagrams are often being used with a certain function and there are differences
in if there should be extra space on the axes.)
Comment 7 bjoern.milcke 2007-10-23 13:00:33 UTC 
The behavior is the same as in Excel. However, I admit that it is not nice, the
extra tick on the right does not make much sense at the x-axis.

So, pro: looks better, con: different from Excel.

(see bool-flag  ScaleAutomatism::m_bExpandIfValuesCloseToBorder which controls
this behavior)
Comment 8 bjoern.milcke 2007-10-23 13:04:02 UTC 
... meaning pro and con for changing the behavior. An option would also be
possible to think of. Then, we can import Excel files correctly and still use a
better default. Would make sense to add this to the axis options dialog.
Comment 9 dudson 2007-10-27 15:54:32 UTC 
That's a good idea.
Together with other chart options in the settings menu.
Comment 10 dudson 2007-10-27 16:09:42 UTC 
But mayby this issue is than a duplicate of 
issue 12581: Customizable chart defaults
Comment 11 IngridvdM 2008-07-03 11:39:48 UTC 
change owner
Comment 12 dudson 2013-09-27 21:52:55 UTC 
It being able to set the axis ranges in the wizard would be the most practical thing.
Being able to set it with typing in numbers or referring to a cell.
And have as default the current value.
Defaults should be specifiable in options/settings of AOO.