To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84962 Issue #|84962 Summary|sum-button chooses wrong range if one contains another | summation Component|Spreadsheet Version|OOo 2.3.1 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|kirschsaft
------- Additional comments from [EMAIL PROTECTED] Thu Jan 3 14:29:08 +0000 2008 ------- If I select some data cells and click the sum-button in the toolbar (the one with the Epsilon sign) it should produce a "=SUM(RANGE)" formula for the selected cells. But if one of the selected cells contains another summation formula (i.e. an intermediate result) it doesn't select the correct range but uses only the last cell (=SUM(C4) if C4 is the last selected cell). How-To reproduce: 1. Open a new spreadsheet 2. Enter some values into a column 3. Append a formula to sum the values up. 4. Select all the values and the formula. 5. Click the sum-button in the toolbar => a new formula with an incorrect range is created. I'm going to attach an example document. I can reproduce this with a stock OOo 2.3.1 under Win2000, and an ooo-build OOo 2.3.1 under Linux. --------------------------------------------------------------------- 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]