Apache OpenOffice (AOO) Bugzilla – Issue 100375
When using logarithmic scales in charts straight vertical or horizontal lines do not show.
Last modified: 2013-02-24 21:20:27 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.
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.
@rodejetta: pls attach the doc Thx
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)
Created attachment 61110 [details] Spreadsheet file with problem under tab TOCHI
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
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.
The chart works correct here.
closing