Re: [Libreoffice-ux-advise] Pivot Table data provider extension framework (removal possibility)

On Thu, Mar 14, 2013 at 5:44 AM, Olivier Hallot
<olivier.hallot@documentfoundation.org> wrote:

> Em 14-03-2013 06:31, Lionel Elie Mamane escreveu:
> > On Wed, Mar 13, 2013 at 09:48:32PM +0100, Eike Rathke wrote:
> >
> > > > I believe the same functionality can be achieve via database
> > > > connectivity, by having such external data provider register as a
> > > > database, and use it to act as a data provider for pivot tables.
> > > > So, I don't see a reason why we need to keep this as a separate data
> > > > source category.
> >
> > > IMHO the advantage of the data provider is that the actual data does not
> > > have to reside in the spreadsheet, allowing for massive amounts of data
> > > records but providing only the information necessary for the pivot
> > > table. This maybe could be accomplished as well using a registered data
> > > source, but currently we have no means to pull the data without actually
> > > storing it in the spreadsheet for further processing. Or isn't that the
> > > case?
> >
> > Naively, I don't immediately see why when using database connectivity,
> > you'd have to store the data in the spreadsheet?

I expanded on that in my post.  I wondered about that too, and pivot
table does generate its output directly from the database connectivity
but it *does* first create a cache from it internally, as part of the
calculation process. But it doesn't duplicate the source data in the
document.

Kohei