To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58144 Issue #:|58144 Summary:|insert row(s) make referenses wrong Component:|Spreadsheet Version:|1.0.3 Platform:|All URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|ericnws
------- Additional comments from [EMAIL PROTECTED] Fri Nov 18 14:24:33 -0800 2005 ------- When right click on the digits in the left margin and in the menu that show up choise to put in one or more new rows then some references in the document afterwareds are wrong. Description to re... the "problem". [1.] open a new empty tabledocument [2.] in cell B5 write the text between the two "-signs: "1" [3.] pull the right lower corner down to B14 - then you should have all values from 1 to 10 [4.] in cell b2 write the formula "=summa(B$8:B$11)" [5.] hit ENTER and 22 show up as result of the formula [6.] mark tree two to eight by pulling the mouse from 3 to 8 in the left margin [7.] right click in the left margin [8.] in the menu that sow up, click on "insert row(S)" or what the name can be in english (in my swedish version the text is "infoga rader") [9.] B2 now shows me the value 28 because the formula has been shanged to "=summa(B$8:B$17)" /Eric Pettersson --------------------------------------------------------------------- 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]
