Issue 100375 - When using logarithmic scales in charts straight vertical or horizontal lines do not show.
Summary: When using logarithmic scales in charts straight vertical or horizontal lines...
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: IngridvdM
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-19 18:40 UTC by rodejetta
Modified: 2013-02-24 21:20 UTC (History)
1 user (show)

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


Attachments
Left side image shows blue divider lines well on normal scales, right one with log scales does not; when changing only one scale to logarithmic, only one line shows. (133.91 KB, text/plain)
2009-03-19 18:45 UTC, rodejetta
no flags Details
Spreadsheet file with problem under tab TOCHI (1.50 MB, text/plain)
2009-03-23 10:59 UTC, rodejetta
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description rodejetta 2009-03-19 18:40:50 UTC
In an x-y plot, points only, a vertical or horizontal division line, entered as
a series, shows well in a chart with normal scales. When changing the scales to
logarithmic, those lines become invisible. I think it is a bug, but could be
overlooking something. Found nothing in the issues list. I do have a screen shot
that shows the problem; should you need the spreadsheet with data, I can provide
that also.
Comment 1 rodejetta 2009-03-19 18:45:17 UTC
Created attachment 61056 [details]
Left side image shows blue divider lines well on normal scales, right one with log scales does not; when changing only one scale to logarithmic, only one line shows.
Comment 2 kla 2009-03-20 08:01:33 UTC
@rodejetta: pls attach the doc Thx
Comment 3 rodejetta 2009-03-23 10:56:09 UTC
It is on sheet TOCHI. The numbers for the lines are above the rightmost chart. I
also tried to shift from e.g. off vertical with 10 - 20, but that also does not
show up on the log scales. 
(This file shows a little how well OO can be used!, Thanks)
Comment 4 rodejetta 2009-03-23 10:59:33 UTC
Created attachment 61110 [details]
Spreadsheet file with problem under tab TOCHI
Comment 5 rodejetta 2009-03-23 13:39:05 UTC
Aha! If in sheet TOCHI I change the value of cell s3 to 0.1, the line shows up
on the log plot, if I revert it to zero, the line vanishes. Even 0.01 works, so
it is likely the duality of zero possibly being seen as negative or positive.
Similarly with cell T3, change that to 0.01, and the line shows. Then I tried
0.000001, and there the line also shows, while the cell itself due to rounding
shows zero. That zero=negative problem showed also when I set the axes' lowest
value: zero was interpreted as negative. 
This means the issue has a work-around. Would it be reasonable to make zero by
default positive? 
Many thanks for all your efforts, what a great product OO is,

Hans
Comment 6 IngridvdM 2009-04-06 10:57:44 UTC
Zero or negative values are not a valid input for display on logarithmic scales.
Four your case it would be correct to choose a very small x value (compared to
your other values) instead of zero.
Comment 7 IngridvdM 2009-04-06 11:46:08 UTC
The chart works correct here.
Comment 8 IngridvdM 2009-04-06 11:47:58 UTC
closing