To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106514 Issue #|106514 Summary|Wrong SUM range after copy / insert row range / Paste Component|Spreadsheet Version|OOo 3.1.1 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|rainerbielefeld
------- Additional comments from [email protected] Sat Oct 31 17:28:27 +0000 2009 ------- I found this problem with "Ooo 3.1.1 WIN XP DE-multilingual version German UI activated [OOO310m19 (Build 9420)]" to see how it should work you should open my sample.ods (a calculation for a quotation) with 2.4.1, where everything works as expected. Steps to reproduce: 1. open sample.odw 2. Click on row heading '20' to select complete row 3. Scroll to row 100, press <shift> and click row heading '100' to select range row 20 ... row 100 4. <cntrl>+<c> for Copy 5. Menu 'Insert -> Rows' to insert 80 new lines and shift old contents down 6. <cntrl>+<v> for Paste 2 Identical version of quotation in rows 20 ... 89 and 101 ...170 7. Now compare results in rows 84 and 165 and additionally SUM formulas. Result (Price) should be the same and SUM formula should add identical ranges in assigned quotation table, range for SUM never exceeds assigned quotation Now do the same with 3.1.1 until step 6: In step 7 you will find SUM calculations starting row 101 completely messed up, all SUMs in column M and also for result in row 165 and following include Copy of quotation in Rows 20 ... 100. That makes calculation completely unreliable. --------------------------------------------------------------------- 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]
