Apache OpenOffice (AOO) Bugzilla – Issue 77683
Subtotal recalculation voids references.
Last modified: 2017-05-20 11:13:06 UTC
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
Can you provide a attachment with example of problem? Pracslipkerm :-)
Created attachment 46887 [details] Spreadsheet with two versions. Start (good) and bad
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
Hi Eike, seems to be yours. Frank
> 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. Correct. > But since the same subtotals are created again on the same spot, > I think this is a mistake. The entire rows are deleted. The method doesn't know in advance where the new subtotals will be created, nor whether some will move or some will vanish completely. This is not a bug but an enhancement, and certainly nothing for 2.x, retargeting to OOoLater.
Reset assigne to the default "issues@openoffice.apache.org".