https://bugs.documentfoundation.org/show_bug.cgi?id=91173
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #2 from GerardF <[email protected]> --- (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? -- 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
