To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116574 Issue #|116574 Summary|Calc not expanding references correctly Component|Spreadsheet Version|OOO320m18 Platform|Macintosh URL| OS/Version|Mac OS X, 10.6 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|formatting Assigned to|spreadsheet Reported by|bfallert
------- Additional comments from bfall...@openoffice.org Sun Jan 23 15:00:47 +0000 2011 ------- This issue was discovered in a spreadsheet when a column summation uses cells from the top row down and from a mid-column row to the bottom of the column. Example: Spreadsheet cell F7 needs to calculate SUM(F3:F6). Cell F15 needs to calculate SUM(F7:F14). The preference "Expand references when new columns/rows are inserted" is unchecked. Insert row above row 7. Cell F8 now shows SUM(F3:F6), which is no change. Cell F16 now shows SUM(F8:F15), which shows that all the cell references shifted down due to the row insertion. UNDO the insertion to reset the cell references. Change the preference "Expand references when new columns/rows are inserted" to be checked. Insert row above row 7. Cell F8 now shows SUM(F3:F7), which is correct. The cell references were expanded due to the row insertion. Cell F16 now shows SUM(F7:F15), which is incorrect. It should show SUM(F8:F15), having expanded the cell references down due to the row insertion. If this bug has been reported in error, please explain. Thanks. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org