To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103784 Issue #|103784 Summary|Autofill does not work correctly for certain numbers. Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|tomwb
------- Additional comments from [email protected] Fri Jul 24 19:44:17 +0000 2009 ------- I will attach a bugdoc to illustrate the following problem. This only applies to using autofill by the drag handle. Menu | Edit | Fill | Series (Linear) works ok. I have found four numbers, that if used to start an autofill series, will not autofill as desired. Example: first cell = .3, second cell = .31, third cell = .32 If I select the three cells then try to autofill with the drag handle, the next value created is 1.3, not 0.34, then 1.31, followed by 1.32. The first digit is incrementing, not the last. The other decimal values that do not work as expected are 0.4, 0.6, 0.7. Another quirk to this is that for 0.3 and 0.6, if I enter them as .30 or .60, the sequence in the autofill is correct. This does not work with 0.4 or 0.7. You will notice in my above example that I did not put in a leading zero when describing the number sequence. This was to show that I did not type a leading zero when entering them into a cell. (Adding a leading zero to the left of the decimal point had no effect.) The bugdoc hopefully shows this more clearly. I did a search of the Issue Tracker for Autofill and found a few issues, but that did not seem the same as this. Issues 5550, 25368, 88119, 92292 were the closest. I found the same behavior on OO 3.0.1(Ubuntu version) on Linux and OO 2.4.1 on Vista SP2. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
