To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92030 Issue #|92030 Summary|Solver: Strange result when entering a cell reference |via mouse Component|Spreadsheet Version|OOo 3.0 Beta Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [EMAIL PROTECTED] Wed Jul 23 11:07:39 +0000 2008 ------- The Solver Dialog allows entering a cell reference using the shrinked mode or just by clicking on the spreadsheet in the background. This delivers very strange entries like $A$1:A1 Although there is no bad impact on the Solver´s function so far, this is confusing users very much. Step by Step: 1) Open the Solver Dialog 2) Set the cursor into the "Target Cell" field 3) Click to the spreadsheet in the background, for example click cell A1. The cell reference $A$1 will be shown in the "Target Cell" field. 4) Set the cursor into the "Value of" field 5) Click to the spreadsheet in the background, for example click cell A1. The cell reference $A$1 will be shown in the "Value of" field. Everything is fine so far. 6) Now, set the cursor into any other field, that is supposed to contain a cell reference, e.g. the fields "By changing cells", "Cell reference" or "Value". 7) Click to the spreadsheet in the background, for example click cell A1. What you get is: $A$1:A1 but you should get: $A$1 8) Drag a cell range in the spreadsheet in the background, for example drag from cell A1 to cell B5. What you get is: $A$1:B5 but you should get: $A$1:$B$5 I will attach a screenshot. --------------------------------------------------------------------- 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]
