Issue 27694 - free choice of minimum and maximum for Logarithmic scale
Summary: free choice of minimum and maximum for Logarithmic scale
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: oooqa
Depends on:
Reported: 2004-04-12 10:41 UTC by ivand
Modified: 2013-02-24 21:22 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Uploading your demonstration Calc file, to make things simpler for people. (7.85 KB, application/vnd.sun.xml.calc)
2004-04-24 21:03 UTC, sjb90
no flags Details
A real microphone measurement - log scale demo (5.02 KB, image/png)
2004-06-06 16:53 UTC, ivand
no flags Details
A screenshot of X marks in m213. I couldn't get any better result. (11.10 KB, image/png)
2007-06-11 09:21 UTC, ivand
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ivand 2004-04-12 10:41:41 UTC
When drawing an XY graph, it is impossible to set Axis scale in Spreadsheet when
axis is logarithmic. The software changes these values although it has been set
manually. OpenOffice will reset the Minimum, Maximum values in the input boxes
to its own pleasure.

Reproducible steps:

* Download the demo at forementioned URL and open it.
* Note the X Axis scale that is currently 10 - 100000.
* Doubleclick the graph in order to edit it.
* Start editing Object properties of X Axis (clicking on the X axis, then
rightclicking, choosing "Object properties...")
* Choose "Scale" tab.
* at "Scale axes" tick off Automatic (if not already) for Minimum, Maximum.
* Enter 20 for "Minimum", 20000 for "Maximum".
* Click "OK".
* Note the X Axis scale that is AGAIN 10 - 100000.
* Reopen X Axis Object properties, Scale. As you can see, the Minimum, Maximum
boxes contain "10", "100000" again.

Note also that it is required to majortick values 10, 100, 1000, 10000 as seen
by now (not 20, 2000, 20000 as you might feel seduced). The problem is just with
the "borders" of the graph.

Motivation: for example audio engineers worldwide are used to work with graphs
with logarithmic X axis starting at 20 Hz, ending at 20.000 Hz.
For your inspiration look at technical sheet of Sennheiser MD441 microphone
(used by your favourite pop star, your prime minister/president/king etc.)
Comment 1 sjb90 2004-04-24 21:03:28 UTC
Created attachment 14752 [details]
Uploading your demonstration Calc file, to make things simpler for people.
Comment 2 sjb90 2004-04-24 21:16:17 UTC
Hi Ivan,

Having reproduced this in 1.1.1 and 680_m34, I agree that it would be useful to
be able to adjust the min/max values of the axis -- and your example of audio
frequency response graphs is a great example. As you say, the x-axes of these
graphs generally have major units of 100, 1000 and 10000Hz, but are cut short at
20 and 20,000Hz.

Marking this issue as new, but changing to "enhancement" rather than "defect"
because Calc is currently working as intended -- programs such as Excel behave
in the same way.

Comment 3 kla 2004-05-07 10:54:59 UTC
Set target
Comment 4 kla 2004-06-04 10:17:34 UTC
HM, i think its an duplicate to 26819 and 26869. So i close it.

*** This issue has been marked as a duplicate of 26819 ***
Comment 5 kla 2004-06-04 10:17:53 UTC
closed as duplicate
Comment 6 ivand 2004-06-04 11:23:20 UTC
With all respect:  author of 26819 feels satisfied that Max=250000 gets
transformed to 1000000. It's about some rounding problem. Author of 26869 is
about ticks. My problem is to really force the graph to respect the entered min
and max (20 Hz - 20 kHz in my case).

I don't think that I am duplicate with the forementioned issues.
Comment 7 kla 2004-06-04 12:26:14 UTC
Hi Ingrid,
pls have a look.
Comment 8 kla 2004-06-04 12:26:42 UTC
Hi Ingrid,
pls have a look.
Comment 9 IngridvdM 2004-06-04 12:42:23 UTC
Comment 10 ivand 2004-06-06 16:53:20 UTC
Created attachment 15701 [details]
A real microphone measurement - log scale demo
Comment 11 ivand 2004-06-06 16:59:25 UTC
I noticed that the original link has disappeared so I rather added the attachment. 
Comment 12 phil82 2004-12-21 09:28:06 UTC
I've also found this bug lately. It makes logarithmic scales nearly unusuable
for scientific perposes. I was really annoyed. My graph went from 60 to 130.
Actually you are just allowed to take the minimum distance between 10, 100 and
1000. For my graph this meant that I had a small line in the middle and huge
space left and right. Is this issue really so unimportant that you don't want to
bring it into OO-2.0?! I think it's elementary for scientific perposes and I
can't wait for this funktion for years.
Comment 13 askoorb 2004-12-22 13:35:27 UTC
Adding my vote...
Comment 14 IngridvdM 2005-12-09 16:30:06 UTC
This issue is fixed in the new chart component, which is targeted for OOo 3.0.

Fixed in Childworkspace chart2mst3.
Comment 15 IngridvdM 2006-01-18 17:26:32 UTC
Ready for verification in CWS chart2mst3.

re-open issue and reassign to
Comment 16 IngridvdM 2006-01-18 17:28:11 UTC
reassign to
Comment 17 IngridvdM 2006-01-18 17:28:53 UTC
reset resolution to FIXED
Comment 18 ivand 2006-03-12 16:14:30 UTC
Hmm, I may sound noisy but couldn't this fix really make it to 2.0.3 ? According 
to I will have to stick with Excel 
for minimum another year...
Comment 19 bjoern.milcke 2006-06-23 10:46:11 UTC
Changed target to 2.x
Comment 20 IngridvdM 2007-01-18 11:54:04 UTC
changed target to 2.3
Comment 21 IngridvdM 2007-03-01 23:40:24 UTC
needed some additional code changes
Comment 22 IngridvdM 2007-03-07 10:59:59 UTC
->Thomas, please verify.
Comment 23 kla 2007-05-04 11:24:56 UTC
TCS will be added to i 26869
Comment 24 2007-06-10 06:36:45 UTC
It's OK for me with m213
-> I close this issue

Comment 25 2007-06-10 06:50:05 UTC
I'm not authorized to close this issue
-> ivand or kla : can you close this issue ?
Comment 26 ivand 2007-06-11 09:13:55 UTC
I am sorry, but I can't still close this ticket. It is true that the scale is
now exact, but the labelling is still wrong:

* Open freq_response_demo.sxc
* Change X scale to min=20, max=20000
* What you get is a scale with labels 20, 200, 2000, 20000... with short marks.

Correct me if I'm wrong, but I didn't find a way to change the text labels to either
- 20, 100, 1000, 10000, 20000
- 20, 50, 100, 200, 500, 1000, 2000, 5000, 10000, 20000

which is what any engineer worldwide would expect.

Please compare your results with KM53.png.
Comment 27 kla 2007-06-11 09:20:56 UTC
@Ivand: Pls perform a new issue for this. The first written "free choice of
minimum and maximum for Logarithmic scale" works realy fine and so this issue
can be closed.
Comment 28 kla 2007-06-11 09:21:23 UTC
Comment 29 ivand 2007-06-11 09:21:40 UTC
Created attachment 45795 [details]
A screenshot of X marks in m213. I couldn't get any better result.