To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77683
------- Additional comments from [EMAIL PROTECTED] Wed Jul 18 13:04:42 +0000 2007 ------- How to reproduce: Open the attached bug.ods, and go back to the "Start" version. Observe that on the taxes sheet the references are like =Sales.E9 Save to a new file (I don't know if there is another way to make it read-write again) Then switch to the sales sheet, enter today's date in cell A14 Then I select cell D14. From the menu: Data/Subtotals. Make sure that in 1st Group you Group by year, calculate subtotals for amount and tax columns, use Sum function. In 2nd Group you Group by quarter, calculate subtotals for amount and tax columns, use Sum function. Click OK. Sales page is fine, the old subtotals are kept intact and a new one was created. Open taxes page, and you can see that B2, B3 and B4 are all went bad. Instead of =Sales.E9 for example, you have =Sales.E#REF! My guess is that the field Sales.E9 was deleted before creating the new subtotals, and at this point Taxes.B3 has lost its reference. But since the same subtotals are created again on the same spot, I think this is a mistake. I have expected the links to stay stable at least, or even follow the subtotals, if the subtotals end up one row down for example. Cheers, 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]
