Apache OpenOffice (AOO) Bugzilla – Issue 27694
free choice of minimum and maximum for Logarithmic scale
Last modified: 2013-02-24 21:22:08 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.) http://www.sennheiser.com/sennheiser/relaunch/icm_eng.nsf/root/00762
Created attachment 14752 [details] Uploading your demonstration Calc file, to make things simpler for people.
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. Stuart.
Set target
HM, i think its an duplicate to 26819 and 26869. So i close it. *** This issue has been marked as a duplicate of 26819 ***
closed as duplicate
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.
Hi Ingrid, pls have a look. thx
accepted
Created attachment 15701 [details] A real microphone measurement - log scale demo
I noticed that the original link has disappeared so I rather added the attachment.
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.
Adding my vote...
This issue is fixed in the new chart component, which is targeted for OOo 3.0. Fixed in Childworkspace chart2mst3.
Ready for verification in CWS chart2mst3. re-open issue and reassign to kla@openoffice.org
reassign to kla@openoffice.org
reset resolution to FIXED
Hmm, I may sound noisy but couldn't this fix really make it to 2.0.3 ? According to http://development.openoffice.org/releases/ I will have to stick with Excel for minimum another year...
Changed target to 2.x
changed target to 2.3
needed some additional code changes
->Thomas, please verify.
TCS will be added to i 26869
It's OK for me with m213 -> I close this issue
I'm not authorized to close this issue -> ivand or kla : can you close this issue ?
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.
@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.
closed
Created attachment 45795 [details] A screenshot of X marks in m213. I couldn't get any better result.