Bad validation on Scales box on Axis (chart properties)

[Duncan Clough]

1) lsb_release -rd
Description: Ubuntu quantal (development branch)
Release: 12.10

2) apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.6.1~rc2-1ubuntu5
  Candidate: 1:3.6.1~rc2-1ubuntu5
  Version table:
 *** 1:3.6.1~rc2-1ubuntu5 0
        500 http://archive.ubuntu.com/ubuntu/ quantal/main i386 Packages
        100 /var/lib/dpkg/status

3) What is expected to happen in a terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1026356/+attachment/3227705/+files/GraphExample.ods && localc --nologo GraphExample.ods

1. Double click on the graph
2. Right click on the y-axis > Format Axis
3. Select the Scale tab
4. Uncheck Automatic for any of the values and try enter a number (You must change the value).
5. Click OK and it works.

4) What happens instead is you will see an error message stating that numbers are required.

These are the steps I used to create the sample spreadsheet:

1. Create new spreadsheet
2. In column A write the numbers 1 to 5 on rows 1 to 5.
3. In column B write the numbers 1 to 5 on rows 1 to 5.
4. Select all the numbers > Format > Cells.
5. In the Numbers tab select "Text" under the list of Categories.
6. Click OK.
7. Click the chart button (with the numbers still selected)
8. Select an XY scatter graph (I've tested with "points-only" and "points with lines")
9. Click Finish. You now have a graph that gives the error message when trying to change the scale.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice-calc 1:3.5.3-0ubuntu1
ProcVersionSignature: Ubuntu 3.2.0-26.41-generic 3.2.19
Uname: Linux 3.2.0-26-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu8
Architecture: amd64
Date: Thu Jul 19 00:15:50 2012
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Beta amd64 (20120328)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[Erik Perkins (perkins)]

I put two columns of data in an xy scatter plot by selecting the cells and choosing

Insert > Chart...

from the menu bar. Once the chart is made, I try to adjust the scale of the y-axis by right-clicking and selecting

Format Axis > Scale

and unchecking the Automatic boxes next to the Minimum and Maximum settings. If I enter new values, the program responds with the error message

``Numbers are required. Check your input."

This happens even if I simply re-enter the default values. However, if I uncheck the boxes *without* editing the default values, I do not get this error message.

[Dclaessens (dclaessens)]

Created attachment 64837
Screenshot of input box % pop-up

[Dclaessens (dclaessens)]

I can fully confirm the behaviour as reported by <email address hidden>

OS WIN7/74 on Intel core i3 system.

LibreOffice 3.5.5.3
Build ID: 7122e39-92ed229-498d286-15e43b4-d70da21

The erroneous input validation is not occuring ALWAYS when switching from automatic to manually setting graph scale. Both X- and Y-axis manual scaling are affected.

This behaviour seems to be generic and was also reported for Ubuntu systems.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Will Furnass (willfurn)]

Please find attached another example of graphs where the y axis limits cannot be changed. The error message is as quoted in the previous comment. Note that the x axis limits can be adjusted. The plotted data are just decimals that are formatted as 'Number (general)'.

FYI I'm using LibreOffice Calc 1:3.5.4-0ubuntu1 on Ubuntu 12.04 (64-bit).

[Dclaessens (dclaessens)]

Further to my previous report.

The same erroneous error message pops up when changing the Y-axis (range 0..100) from linear to logarithmic scale. Simply clicking the "logarithmic" checkbox causes the "numbers are required" message.

[Christina Roßmanith (chrrossmanith)]

Not reproducible here:

Version 3.7.0.0.alpha0+ (Build ID: 784302d)
Linux

Maybe it has been fixed between 3.5.5.3 and my master build.

[penalvch (penalvch)]

Duncan Clough, thank you for taking the time to report this bug and helping to make Ubuntu better. The issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions verbatim at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about the status. Thanks in advance.

Helpful Bug Reporting Link:
https://help.ubuntu.com/community/ReportingBugs#Bug_Reporting_Etiquette

[KennoVO (kenno-xs4all)]

I linked this to upstream bug #49987 , but on second thought, upstream bug #57697 contains more recent and relevant info (they ought to mark one a duplicate of the other).
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57697

Between the 2 upstream reports, it appears the bug occurs in 3.5.x and 3.6.x, but is fixed from 3.7 onwards.

The upstream info also led me to find a workaround (for my specific instance, anyway): in the "Format Axis" dialog, one can click on the "Numbers" tab, uncheck "source format" (if it's checked), then choose Category: Number and Format: General. Then click "OK" and open the "Format Axis" dialog _again_, and then everything should work as expected. This workaround has been a life-saver for me as I'm on a machine I currently can't upgrade, and Ubuntu Precise is still supported till 2017...

[KennoVO (kenno-xs4all)]

Warning: launchpad's autogenerated hyperlinks in my previous post are wrong; the explicit "https://" link is the only correct one.

[Björn Michaelsen (bjoern-michaelsen)]

Both fdo#49987 and fdo#57697 are marked as resolved upstream:

 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57697#c7

so it should be fixed in at least 4.3.0. We are shipping newer versions, thus marking as fix released.