Reported on the Forum that when I tried to set axes limits for a log scale below 1E-10, it defaulted to zero. Contributor "Opaque" carried out detailed tests and showed that it was related to Ubuntu 18.04 and LibreOffice, specifically the GTK3 Tookit. Several months ago I had been successfully using V6.4 so it may be that a Ubuntu update introduced the problem. The details are here: https://ask.libreoffice.org/en/question/278872/log-axes-in-calc/ Thanks, Carl Ross
Created attachment 174676 [details] Example file Can you give steps on how to see the problem with this file?
Thanks. Running Ubuntu 20.04.03, LibreOffice 7.0.4.2. Right click to change the y-axis scale to (say) 1e-15. Get a message saying the log scale requires positive numbers. Same message until 1e-10 and then OK. Carl
Thanks, so: 1. Double-click chart to edit 2. Select y-axis, right-click - Format axis 3. Scale tab, uncheck Automatic next to Minimum 4. Input 1e-15, OK Only seen with gtk3 (not on Windows either). Already in oldest of 6.4 bibisect repo.
Maximum doesn't seem to have the same problem, but doesn't seem obviously different to Minumum
aha, gtk_spin_button_set_value won't change the value if the new value is less than 1e-10 of a difference to the old value
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e8cef7a93170fdca1a66f80184e7c207d3ca376e tdf#138519 use gtk_adjustment_set_value instead of gtk_spin_button_set_value It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
fixed in trunk, backports to 7-2 and 7-1 in gerrit
Verified, thanks Arch Linux 64-bit Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: e8cef7a93170fdca1a66f80184e7c207d3ca376e CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 1 September 2021
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/91aab53081045ec0b09d97aa74809774bb2e5f7b tdf#138519 use gtk_adjustment_set_value instead of gtk_spin_button_set_value It will be available in 7.1.7. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/132603eb108a4e028ec0f41ada6defe777079ded tdf#138519 use gtk_adjustment_set_value instead of gtk_spin_button_set_value It will be available in 7.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.