Issue 13733 - DataPilot (Pivot) - Various Requests
Summary: DataPilot (Pivot) - Various Requests
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.2
Hardware: PC Windows 2000
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-04-23 05:46 UTC by rodro
Modified: 2013-02-07 22:39 UTC (History)
4 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description rodro 2003-04-23 05:46:05 UTC
Hi, I've been trying to use the Data Pilot, and found out about a few things 
that need improving or would add functionality:

1. It chokes on large datasets or seems to take forever to respond
   (~100,000 records, TXT, DBF, SQL Server, etc.) (1).
2. It takes too long to start or restart the Data Pilot or to recalculate
   even the smallest datasets (1).
3. A PAGE section.
4. Unlimited fields in all sections (PAGE, ROW, COLUMN, DATA).
5. Could use a multi-select filter for field data in all sections a la
   Office XP (checkbox list).
6. Dynamic charts would be nice.

(1) OOo also takes up to 99% CPU time while doing this. Excel just flies. Don't
know if its the data access component in OOo or what.

In short, speed and functionality equal that of Office XP's Pivot tables
(Mostly there, just needs polishing).

Hope these can be addressed in OOo 1.5 or 2.0 or something
(maybe dyna-charts in 3.0? :-)).

OOo is great.  Keep up the good work.

Comment 1 frank 2003-04-23 09:11:37 UTC
Hi Bettina,

something for you.

Comment 2 rodro 2003-10-24 21:19:01 UTC
Just as an addition:

I think OOo has to retrieve all the data again whenever it needs to
recalculate the Pivot Table. I don't think it caches the data.

It seems Excel caches the last updated data in an invisible list
inside the file, not constrained by the 64K row limit, and when it
needs to recalculate when moving fields around, it does so without
accesing the data source, quite fast.

Thanks for your time.
Comment 3 mjneedles 2004-01-10 04:58:46 UTC
I filed a separate issue a long time ago about what you call "dynamic charts" or
as MS calls it, "Pivot Charts." See issue 14506

Comment 4 utomo99 2006-12-12 09:47:20 UTC
hi rodro
Can you please make separate issue for a suggestions/ problems ? 
Comment 5 bettina.haberer 2010-05-21 14:48:53 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".