https://bugs.freedesktop.org/show_bug.cgi?id=61634
--- Comment #10 from [email protected] --- "Expand references when new columns/rows are inserted" might change the behavior, but based on my understand of that option, it really shouldn't. From the help documentation: "Specifies whether to expand references when inserting columns or rows adjacent to the reference range. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction. Example: If the range A1:B1 is referenced in a formula and you insert a new column after column B, the reference is expanded to A1:C1. If the range A1:B1 is referenced and a new row is inserted under row 1, the reference is not expanded, since there is only a single cell in the vertical direction. If you insert rows or columns in the middle of a reference area, the reference is always expanded." That all has to do with inserting rows and columns and having it affect/adjust existing references/formulas. In my reported bug example, at the point before the subtotals function is activated, there are no formulas or references at all. And no rows or columns are being inserted by the subtotal function. The fact that the "Expand References" option affects the behavior at all is very curious (and helpful observation), but it is not really a solution, nor does it explain why this is happening. Plus, that option is not selected in OpenOffice when I tested there, and yet there were no such issues with subtotaling in OpenOffice, just LibreOffice... Also, based on the description of the "Expand References" option, I would never want that option "on", anyway. I am guessing most people would not want that "on". -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
