Issue 80356 - graphs: secondary grid is drawn over the primary one
Summary: graphs: secondary grid is drawn over the primary one
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Windows XP
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-08-04 19:13 UTC by dkrysiak
Modified: 2013-02-24 21:20 UTC (History)
1 user (show)

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


Attachments
Screen shot with the bug effect place pointed (31.44 KB, image/png)
2007-08-04 19:19 UTC, dkrysiak
no flags Details
Test doument with bug (12.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-08-04 19:20 UTC, dkrysiak
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dkrysiak 2007-08-04 19:13:47 UTC
I think I found a small bug in graphs drawing engine in OpenOffice 2.2 Calc
application.

When both primary and secondary grid is drawn for one value, the grid line looks
like the secondary grid, not like the primary grid.

Steps to reproduce the bug effect:
1. Create new spreadsheet with OOo Calc.
2. Create a simple data table:
x	y
1	600
2	800
3	1100
3. select all cells with data and insert a graph (using menu "Insert" ->
"Graph", ergo - using the wizard)
4. "Autoformatting the graph"(*) dialog window:
	4.1. (1st step) leave all as is, hit "next"
	4.2. (2nd step) Choose "XY graph" graph type; "data series in: columns", hit "next"
	4.3. (3rd) "grid lines" - select "Y axis"; click "Create"
5. right-click newly created graph, choose "edit" to open the graph edit mode
(all next steps will be done in this mode)
6. from "insert" menu choose "grids"
7. "Grids" window: select "Y axis" in "secondary grid" section; click "OK"
8. right-click somewhere in the graph area, from the context menu choose "axis"
and then "Y axis"
9. in "Y axis" dialog window:
	9.1. choose "scale" tab
	9.2. in section "scale axes" deselect "auto" in "minimum", "maximum", "main
range"(*), "secondary range"(*) (first 4 options)
	9.3. put your values in text fields which are now enabled - in "minimum": 0,
"maximum": 1500, "main range": 250, "secondary range": 100; (values are
important - I'll explain it later); hit "OK"
10. (optional) right-click somewhere in the graph area and choose "grids";
choose "main grid of Y axis"; make sure grid is "solid" and "black" (default
values); click "OK"
11. right-click somewhere in the graph area again, choose "grids" from the
context-menu again, but this time choose "secondary grid of Y axis"
12. we want secondary grid to be more "subtle" than main grid; choose "grey"
color, hit "OK"

The effect is that:
 - secondary horizontal grid lines are solid and grey
 - primary horizontal grid lines are solid black but not all(!)
 - primary grid lines which "collapse" with the secondary ones, are grey too(!)

For values of y, which are multiplies of 500, both primary and secondary grid is
drawn (this is what we needed the exact values of min/max and ranges in y axis
scale options). These grid lines look thiner/lighter - they are grey instead of
black. The should look like the primary grid lines (solid black), but they look
exactly like the secondary ones (solid grey).

It looks like for the values where both primary and secondary grid is drawn, the
"secondary grid" is drawn over the primary one - possibly it is drawn just after
the primary grid.

More:
 - The same problems appears in X grid.
 - The result are interesting when using "dashed" line style for one of prim/sec
grid also.
 - The unwanted effect is also visible in "print preview" mode (didn't print it
- I have no ink currently :P ).

(*) I've got polish (national language in Poland, code 'pl') version of
application, so original options/commands names can differ a little, sorry.
Comment 1 dkrysiak 2007-08-04 19:19:38 UTC
Created attachment 47315 [details]
Screen shot with the bug effect place pointed
Comment 2 dkrysiak 2007-08-04 19:20:18 UTC
Created attachment 47316 [details]
Test doument with bug
Comment 3 Regina Henschel 2007-08-04 23:23:12 UTC
Hi dkrysiak, I can see the problem too in the version OOo2.2.1 with the old
chart module. But a new chart module has been introduced, which will be
available in version 2.3 this autumn. You can already test a developer build
with the new chart module.
In the new chart module the situation you demonstrate can no longer occur,
because you now define the minor grid as number of parts from one main grid line
to the next and no longer as value distance of the axis.
Comment 4 frank 2007-08-06 08:54:13 UTC
wrong component and closed