This bug is still present in 12.04 and is easily reproducible. The workaround of changing the formatting to be "Number" does not work in all situations and sometimes you are stuck with being unable to adjust the axes.
I've attached a sample document with a contrived example (changing the formatting should fix the issue in this case). To see the error: 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. 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. Expected Behaviour: The widget should accept the new values as numbers regardless of the formatting of the chart data. ** Attachment added: "GraphExample.ods" https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/577658/+attachment/3218991/+files/GraphExample.ods ** Changed in: openoffice.org (Ubuntu) Status: Expired => Confirmed ** Also affects: df-libreoffice Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/577658 Title: Bad validation on Scales box on Axis (chart properties) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/577658/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
