Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Convert MS PivotChart to DataPilot Chart|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||aladdin, bharath.ag1984, cmoulin, dmcamens, issues, kyoshida, marc.galmard, matthias.mueller-prove, michael.feehilly, mikey, olivier.hallot.ooo, pagalmes.lists, steve.b.wardell, stp, tony.galmiche.ooo|
|Version:||3.3.0 or older (OOo)||Keywords:||ms_interoperability, rfe_eval_ok|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description mjneedles 2003-05-16 01:17:22 UTC
I request the addition (soon) of pivot charts for Calc. Opening an Excel sheet of a pivot chart displays a meaningless chart with no data plotted. Attachment will follow. Thanks Matt Needles
Comment 1 mjneedles 2003-05-16 01:27:37 UTC
Created attachment 6218 [details] Excel Workbook with a pivot chart on one Sheet based on a pivot table on another sheet
Comment 2 kla 2003-05-28 11:24:42 UTC
Hi Bettina, one for you.
Comment 3 oc 2003-07-28 09:48:48 UTC
*** Issue 17453 has been marked as a duplicate of this issue. ***
Comment 4 bettina.haberer 2003-10-15 16:09:35 UTC
Hello, Björn. As this concerns the interoperability, I suggest it for OO.o 2.0. But you will see. Please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 5 bjoern.milcke 2003-10-15 17:24:32 UTC
The implementation of pivot charts is a quite complex task. As our schedule for OOo 2.0 is already rather tight, I will postpone this after the release of 2.0.
Comment 6 okapi1253 2004-02-18 02:47:04 UTC
The issue does occur for me as well.
Comment 7 bettina.haberer 2004-11-29 18:15:03 UTC
Reassigned to Ingrid.
Comment 8 stp 2005-03-06 18:44:03 UTC
Rewrote summary since issue is about converting PivotCharts to DataPilot charts. DataPilot is similar to PivotChart and DataPilot is an existing feature.
Comment 9 IngridvdM 2005-04-15 12:49:45 UTC
Comment 10 stp 2005-04-22 21:08:39 UTC
Issue 4077 could be set as a duplicate of this (or vice versa). I recommend keeping this issue as it is described better than in 4077.
Comment 11 IngridvdM 2005-04-25 10:37:42 UTC
->thing: No, the issues are not duplicate. Issue 4077 is about what the calc has to do and this Issue 14506 is about what the chart has to do. See the component field of both Issues. Thanks.
Comment 12 mjneedles 2006-06-14 15:02:26 UTC
Cannot this be closed, as this is working fine now?
Comment 13 IngridvdM 2006-06-28 15:41:05 UTC
->mjneedles: Using one of the latest milestones (SRC680m172) the bug still occurs for me. The chart on the second page is still empty. Which version did you use?
Comment 14 mjneedles 2006-06-29 05:25:52 UTC
I just tested the file again on _m173, and got the same results as when first tested. The Pivot Chart function does not work yet. Also, the Data Pilot (Pivot Table function in OOo) does not look as nice or complete as Excel's. For example, when this workbook is opened in Excel (XP), the source table for the Pivot Table has the source data selected with a gray background, making it plain that the pivot table is based on that part of the table. Calc does not do that, rather, it leaves no visual indication of what part of the table was used to create the pivot table.
Comment 15 IngridvdM 2006-06-29 09:50:42 UTC
->mjneedles: Thanks for the fast response! I would like to have this issue about the wrong chart only. Could you please write another issue for the missing selection in calc to nn. Thanks a lot.
Comment 16 pagalmes.lists 2007-07-30 12:01:18 UTC
I think that issue 43460 is a duplicate from this one. Can someone confirm it and then close the issue accordingly?
Comment 17 IngridvdM 2007-07-30 12:19:50 UTC
No, it is not duplicate. This one is about displaying charts on pivot tables, the other one is about manipulating pivot tables via chart interface.
Comment 18 jbasc19921jbkas 2008-03-20 19:41:05 UTC
"DataPilot is similar to PivotChart and DataPilot is an existing feature." I disagree! What I really want is a genuine DataPilotChart i.e. one that displays the results of a DataPilot not just the cells which it currently occupies i.e. if I refresh the DataPilot and it now has extra columns (e.g. for data for a new month) the chart needs to automatically refresh also to include the data in these new cells?
Comment 19 jmason_yamato 2008-05-23 18:31:48 UTC
OS and Platform chould be change to 'All', as this enhancement remedies a feature missing in all OOo platforms.
Comment 20 IngridvdM 2008-06-02 12:17:18 UTC
changed OS and platform
Comment 21 jmason_yamato 2008-06-02 17:28:48 UTC
Thanks, Ingrid. So, how about changing the Target milestone to OOo 3.1 ?
Comment 22 IngridvdM 2008-07-22 14:20:38 UTC
reset to new
Comment 23 kyoshida 2009-01-30 02:54:04 UTC
*** Issue 98534 has been marked as a duplicate of this issue. ***
Comment 24 ohallot 2009-06-29 19:39:57 UTC
cc'ing myself. Pivot charts are a must-have.
Comment 25 yohana22 2009-07-23 14:49:54 UTC
We’ve tried version 3.1 and the error is still in there.
Comment 26 yohana22 2010-03-25 16:45:52 UTC
We’ve tried version 3.2 and the error is still in there.
Comment 27 oooforum (fr) 2014-11-17 10:34:36 UTC
*** Issue 125862 has been marked as a duplicate of this issue. ***
Comment 28 Doug Camens 2015-05-10 19:13:25 UTC
I have OpenOffice 4.1.1 and it looks like pivot charts are still not supported. I tried to create a normal chart on the pivot table data and the chart is not very readable. Pivot chart would be a valuable enhancement for OO.