Created attachment 115458 [details] Example of a pivot table that do not respect the range of the named range HOW TO REPRODUCE Create a global named range In attachment example, I create the named range Test as $A$1:$C3 Notice the absence of $ before the last row number This is intentional to allow the range to increase adding rows Use it as source for a pivot table Add a new row of data following the named range The named range gets correctly updated adding one or more rows as needed You can check this using ctrl+F3 But the pivot table do not get data from the updated range WORKAROUND Do not use named range when range is dinamic. Put a range directly as the source of the pivot table with a lot of rows and ignore empty cells TESTED ON: OSX 10.9 LibreOffice version 4.3 4.4.2 4.4.3 Ubuntu 15.04 LibreOffice version 4.4.2.2
However if the range is modified via the define names dialog (Ctrl + F3), pivot table takes data from the updated range correctly.
(In reply to vice from comment #0) > In attachment example, I create the named range Test as $A$1:$C3 > Notice the absence of $ before the last row number > This is intentional to allow the range to increase adding rows There is no need to use mixed reference for named range. Named range is expanded with absolute reference. However using relative reference is problematic in this case (and many others) as "test" range is not the same depending on where you use this name (pivot table or formula). If you want to know what I try to esplain, do this: In cell F1, write "=test" (without quotes) and validate with Ctrl+Shift+Enter. Now do the same un cell F15. Did you see what I mean?
Already reported and closed by dev. :( *** This bug has been marked as a duplicate of bug 74052 ***
Sorry... wrong bug. :(
I see. Thanks for the quick answer. Sorry for the noise.
Some explanations here: https://bugs.documentfoundation.org/show_bug.cgi?id=76402&redirected_from=fdo#c4 Only absolute references for named ranges are adapted when inserting, deleting, etc. inside their range. Relative references are not modified.