Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Kohei,

On Tuesday, 2013-03-12 11:41:32 -0400, Kohei Yoshida wrote:

I'd like to ask whether someone actually uses this Pivot Table data
provider extension framework, because I'd like to remove this if
nobody is using it, or only few people are using it.

From what I remember that can be used to populate pivot tables with data
obtained from external resources like databases. Unfortunately you'll
hardly find such extensions in the wild but more within enterprises and
corporate users, so determining whether it's actually used or not is
nearly impossible unless someone knows who those customers are.

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?

The way it is currently implemented also makes it *extremely*
difficult for us to optimize the pivot table engine, because all its
functionality has to go through the UNO API which forces us to do
data conversion *twice* for every single transaction.  That's very
very expensive especially as the data size grows (and it always
does).

Seconded.

So, I'd *love* to get rid of this sooner rather than later, and I'd
like to know whether there are people who would absolutely need this
functionality, and if so why.  As I said above, I believe the same
functionality could be achieved via the database connectivity
backend even if we remove the extension backend.

I think there work needs to be done to pull the data and provide it in
a form that pivot tables can actually process. It may be viable, but I'm
really not familiar with pivot table topics.

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
New GnuPG key 0x65632D3A : 2265 D7F3 A7B0 95CC 3918  630B 6A6C D5B7 6563 2D3A
Old GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD
Support the FSFE, care about Free Software! https://fsfe.org/support/?erack

Attachment: pgpLgUSa97FOo.pgp
Description: PGP signature


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.