To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102727 Issue #|102727 Summary|Calc auto-fill by mouse does not accurately produce va |lue zero Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|sm8ps
------- Additional comments from [email protected] Fri Jun 12 23:33:40 +0000 2009 ------- Start with value -1 in cell A1, value -0.9 in cell B2. Using auto-fill by mouse (as opposed to by menu Edit>Fill) on this sequence will seemingly produce the right values -1, -0.9, -0.8, ..., 0, 0.1, ... However, at closer inspection, instead of zero the value reads -2.22044604925031E-016. This can also be reproduced by choosing different initial values like e.g. -1.2, -0.9 (same erroneous value) or -1.1, -1 (different value). The same behavior was observed in OOo2 and OOo3.0.1 It could not been reproduced with step sizes 0.5, 0.25, 0.125. The issue could not be reproduced by using the menu Edit>Fill with settings corresponding to the above situation. --------------------------------------------------------------------- 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]
