Apache OpenOffice (AOO) Bugzilla – Issue 61367
Error creating a chart - repeating numbers in Y axis
Last modified: 2013-02-24 21:19:18 UTC
Open a new spreadsheet Enter numbers lower than 10 in cells A1, B1 and C1, for example Select the cells that contains data (the range A1:C1) Click on Cell... command on Format menu Change Leading zeroes from 1 to 2 (the format code will be 00) Click on OK button to close the box Click the Insert Chart icon on the Standard toolbar Drag open a rectangle in a place of spreadsheet Click the Create button on AutoFormat Chart dialog A chart will be created. Note that the Y axis is wrong, repeating numbers! (as 01, 01, 02, 02, 03, 03). If you change one number to a number greater than 9 (like 20), the problem will be solved.
Created attachment 33710 [details] File with an example of the error
confirmed with m154 on WinXP Pro SP2
Hi ivanmomm, the format code will show the solution. You Change from standard format code (with decimal places) to an code without decimal places. Now, the scaling (interval) of the Y-Axis is .5 and with a format code without decimal places the rounding works fine. (-: So i close the issue as works for me.
closed as worksforme