From 3c4d5b9c2bd1a532ce57539688fe97a3f8609596 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Alain=20B=C3=A9arez?= <abearez@apache.org>
Date: Sun, 5 Jan 2020 23:54:12 +0000
Subject: [PATCH] Clear all chart's properties as if newly created

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1872363 13f79535-47bb-0310-9956-ffa450edef68
---
 .../poi/xddf/usermodel/chart/XDDFChart.java   | 87 +++++++++++++++++++
 1 file changed, 87 insertions(+)

diff --git a/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChart.java b/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChart.java
index 8b93f41eaf..0b662e42f2 100644
--- a/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChart.java
+++ b/src/ooxml/java/org/apache/poi/xddf/usermodel/chart/XDDFChart.java
@@ -188,6 +188,21 @@ public abstract class XDDFChart extends POIXMLDocumentPart implements TextContai
         return chart.getPlotArea();
     }
 
+    /**
+     * Clear all properties, as if a new instance had just been created.
+     * @since POI 4.1.2
+     */
+    public void clear() {
+        axes.clear();
+        seriesCount = 0;
+        if (workbook != null) {
+            workbook.removeSheetAt(0);
+            workbook.createSheet();
+        }
+        chart.set(CTChart.Factory.newInstance());
+        chart.addNewPlotArea();
+    }
+
     /**
      * @return true if only visible cells will be present on the chart, false
      *         otherwise
@@ -477,6 +492,78 @@ public abstract class XDDFChart extends POIXMLDocumentPart implements TextContai
         return series;
     }
 
+    /**
+     * Clear all chart series, as if a new instance had just been created.
+     * @since POI 4.1.2
+     */
+    public void clearChartSeries() {
+        CTPlotArea plotArea = getCTPlotArea();
+
+        for (int i = plotArea.sizeOfAreaChartArray(); i > 0; i--) {
+            plotArea.removeAreaChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfArea3DChartArray(); i > 0; i--) {
+            plotArea.removeArea3DChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfBarChartArray(); i > 0; i--) {
+            plotArea.removeBarChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfBar3DChartArray(); i > 0; i--) {
+            plotArea.removeBar3DChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfBubbleChartArray(); i > 0; i--) {
+            plotArea.removeBubbleChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfDoughnutChartArray(); i > 0; i--) {
+            plotArea.removeDoughnutChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfLineChartArray(); i > 0; i--) {
+            plotArea.removeLineChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfLine3DChartArray(); i > 0; i--) {
+            plotArea.removeLine3DChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfOfPieChartArray(); i > 0; i--) {
+            plotArea.removeOfPieChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfPieChartArray(); i > 0; i--) {
+            plotArea.removePieChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfPie3DChartArray(); i > 0; i--) {
+            plotArea.removePie3DChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfRadarChartArray(); i > 0; i--) {
+            plotArea.removeRadarChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfScatterChartArray(); i > 0; i--) {
+            plotArea.removeScatterChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfStockChartArray(); i > 0; i--) {
+            plotArea.removeStockChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfSurfaceChartArray(); i > 0; i--) {
+            plotArea.removeSurfaceChart(i - 1);
+        }
+
+        for (int i = plotArea.sizeOfSurface3DChartArray(); i > 0; i--) {
+            plotArea.removeSurface3DChart(i - 1);
+        }
+    }
+
     private Map<Long, XDDFChartAxis> getCategoryAxes() {
         CTPlotArea plotArea = getCTPlotArea();
         int sizeOfArray = plotArea.sizeOfCatAxArray();
-- 
2.39.5