Issue 61367 - Error creating a chart - repeating numbers in Y axis
Summary: Error creating a chart - repeating numbers in Y axis
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2006-01-30 14:32 UTC by ivanmomm
Modified: 2013-02-24 21:19 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
File with an example of the error (11.10 KB, application/vnd.sun.xml.calc)
2006-01-30 14:34 UTC, ivanmomm
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ivanmomm 2006-01-30 14:32:51 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.
Comment 1 ivanmomm 2006-01-30 14:34:48 UTC
Created attachment 33710 [details]
File with an example of the error
Comment 2 lars 2006-01-31 17:21:56 UTC
confirmed with m154 on WinXP Pro SP2
Comment 3 kla 2006-02-15 09:47:43 UTC
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.
Comment 4 kla 2006-02-15 09:48:22 UTC
closed as worksforme