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

[Kohei Yoshida]

On Thu, Mar 14, 2013 at 5:44 AM, Olivier Hallot
<olivier.hallot at 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