To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82928 Issue #|82928 Summary|worng results in dragging elements in formulas Component|Spreadsheet Version|OOo 2.3 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|scagni
------- Additional comments from [EMAIL PROTECTED] Wed Oct 24 12:30:08 +0000 2007 ------- Create and compute any simple formula with fixed references to some cells, for example: =SUM($B$1+$A$3+$B$5) Now double click on it so that it opens and all the cells it is referring to are outlined with different colors. If you drag any of the outlined cells, the reference in the formula is moved accordingly. This should work also for fixed (i.e. with a preceding dollar sign, like the one above) references, since this is a manual dragging, and fixed references should not change automatically but it should be possible for the user to voluntarily do so. However if in the formula above you try to, say, drag the reference $B$1 to the cell below, you don't get $B$2, but instead $B$2:B2, which is inconsistent with reference notations for formulas, and in many cases causes errors or unwanted results. --------------------------------------------------------------------- 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]