[Libreoffice-bugs] [Bug 137420] Pivot Table named range does not list database ranges

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Oct 14 19:40:41 UTC 2020


https://bugs.documentfoundation.org/show_bug.cgi?id=137420

--- Comment #6 from mshiner at uzerp.com ---
(In reply to m.a.riosv from comment #5)
> Because named ranges are no part of the Menu/Data/Define range and has
> nothing to do with it (Menu/Sheet/Named Ranges and expressions), to access
> database data, must be selected the option 'Data source registered' and from
> base file select the data.

I understand the registered database option for external data (I use them all
the time).

But (and with respect) if Calc is going to allow an option for 'normal' named
ranges as a source for a Pivot Tables  then surely database ranges must also be
allowed for consistency?

This is especially true if one is trying to use a database range based on a
link to another sheet (say a csv file).

M

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201014/2b5c9bf2/attachment.htm>


More information about the Libreoffice-bugs mailing list