Bug 57697

Summary:	EDITING: Can't modify chart y-axis scale
Product:	LibreOffice	Reporter:	James Evensen <green_jaed>
Component:	Impress	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	1st2be, alexpikptz, jorendc
Priority:	medium
Version:	3.6.3.2 release
Hardware:	All
OS:	All
Whiteboard:	(target:4.2.0)
Crash report or crash signature:		Regression By:
Attachments:	The chart in question

Description James Evensen 2012-11-29 19:53:16 UTC

I'm not sure how I did it, but I managed to put a chart I created in Impress into a state where I can not modify the scale of the y-axis of the chart.

A summary of what I did:
  On a presentation slide, I clicked on the icon to insert a graph.  I changed the chart type to scatter plot.  Then, I entered in two data sets.  I then modified the x-axis scale without problem.  I then try to modify the y-axis.

  I go to Format -> Axis -> Y axis and then to the "Scale" tab.  I uncheck "Automatic" for Minimum, Maximum, and Major Interval so I can enter values.  When I input values in either the Minimum or Maximum fields and click OK, I get an error message saying "Numbers are required. Check your input."  When I try inputting values for the Major Interval and click OK, I get the error message "The Major Interval requires a positive number. Check your input."  These error messages appear regardless of the what I input.

I have generated other graphs in Impress and they are not affected by this problem.  So far, I have not been able to reproduce the steps I took that lead to this bug.

Comment 1 Rob Snelders 2012-12-02 19:31:38 UTC

Can't reproduce the problem with LO 3.6.0.1 on Ubuntu 12.04 x86_64

Comment 2 James Evensen 2012-12-04 02:49:28 UTC

Created attachment 70980 [details]
The chart in question

I've added the Chart that is exhibiting the problem.

Comment 3 Jorendc 2013-01-04 12:44:11 UTC

I can reproduce with your attached file.

When following your steps, and enter a value for 'Minimum' ... this value disappears when I click on another field ('Maximum') for example.

Tested with Mac OSX 10.8.2 (-> not windows only) and 4.1.0.0.alpha0+ (Build ID: 6a393297ce6d99bbc4edefbf01ab9c5c6f0eff8)
TinderBox: MacOSX-Intel@1-built_no-moz_on_10.6.8, Branch:master, Time: 2013-01-04_01:05:31

Comment 4 Jorendc 2013-01-04 13:44:16 UTC

I'm not sure, but the 'bug' I can't enter something in the fields is triggered here: http://opengrok.libreoffice.org/xref/core/chart2/source/controller/dialogs/tp_Scale.cxx#404

Comment 5 Jorendc 2013-01-04 14:32:35 UTC

@Joseph Brown: regarding "Bug 51695 - RTL: graph/chart scale cannot be modified, due to number format issue" and your commit http://cgit.freedesktop.org/libreoffice/core/commit/?id=84a219020ca37a28799972cc60d9286c82ca7511 I put you in CC. 

I think this problem is triggered by following code: http://opengrok.libreoffice.org/xref/core/chart2/source/controller/dialogs/tp_Scale.cxx#595

Can you please have a look at this?
Thanks in advance,
Joren

Comment 6 Joseph Brown 2013-01-04 15:32:57 UTC

I experienced similiar issues when I pasted data from a web page into a spreadsheet.

The numbers were stored as labels.  Although they appeared as numbers, the data were actually labels.

The numbers may be stored as text values.  While the scale mode is automatic, that works fine, which was how it worked in the spreadsheet.  

When switching to manual scaling, the fact that the actual data (nubmers) are stored as labels, it becomes an issue.


In this example, there is a colum of "data labels" which is not used, but contains labels.  That may be the source of the issue.  

Converting from one chart type to another, may have intersperced labels with number data or possibly numbers are being stored as labels.

Comment 7 Alexandr 2014-07-16 09:53:20 UTC

I reproduce the bug with LibreOffice 3.5.4 from Debian Wheezy, but in LibreOffice 4.2.5 and 4.3.0.2 it works without any problem. 

I am not sure which patch solved the issue. The dialogue was seriously rewritten by Olivier Hallot (http://cgit.freedesktop.org/libreoffice/core/commit/?id=19956d09e0e97aa7357edf14fef2b79c2af11dc1). I set bugstatus to RESOLVED WORKSFORME. Please, set it to FIXED if you can verify patch or reopen it if you can reproduce the issue with LibreOffice 4.2 or later.