To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77683 Issue #|77683 Summary|Subtotal recalculation voids references. Component|Spreadsheet Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|gee
------- Additional comments from [EMAIL PROTECTED] Tue May 22 14:55:59 +0000 2007 ------- I have a spreadsheet. On the first page I have several lines, containing dates and values. I create subtotals for each year and for each quarter. On the second page I would like to list each quarter's subtotals from the first page in one column. So far everything works nice. Then I add some new lines on the first page, and I recalculate the subtotals. Since I always add new lines at the end (so the dates are from the current quarter), all the old subtotals stay the same. Same value, same position. But, the references on page 2 are broken. The best would be of course if the references to the calculated subtotals would move with the cells if I enter some new data related to the last quarter for example. But having to select the same old cells all the time I recalculate on page 1 is really bad. Regards, Gabor --------------------------------------------------------------------- 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]
