I realized that the following line cause the problem. Can you check it?
- Code: Select all
chart.ChartData.Clear(0, 0, categoryCount + 1, seriesCount + 1);
Template File:
Source code:
- Code: Select all
using Spire.Presentation;
using System.Linq;
using Spire.Presentation.Charts;
using System;
using System.Collections.Generic;
namespace PptxTesterPaidVersion
{
class Program
{
static void Main(string[] args)
{
PieChartEditDataCrashing();
}
private static void PieChartEditDataCrashing()
{
//Load template presentation
Presentation templatePresentation = new Presentation();
templatePresentation.LoadFromFile("template.pptx");
//Create New Presentation
Spire.Presentation.Presentation presentation = new Spire.Presentation.Presentation();
presentation.Slides.RemoveAt(0);
//Get slide from template presentation. index:1
ISlide cloneSlide = templatePresentation.Slides.ToArray().ElementAtOrDefault(0);
//---
//Get Chart
//IChart chart = templateSlide.Shapes.ToArray().FirstOrDefault(x => x.Name == "Content Placeholder 15") as IChart;
IChart chart = cloneSlide.Shapes.ToArray().FirstOrDefault(x => x.Name == "Chart 14") as IChart;
int seriesCount = 1;
int categoryCount = 2;
chart.ChartData.Clear(0, 0, categoryCount + 1, seriesCount + 1);
chart.ChartData[1, 0].Text = "Read a printed newspaper";
chart.ChartData[2, 0].Text = "Read a digital magazine";
chart.ChartData[0, 1].Text = "Total";
chart.ChartData[1, 1].NumberValue = 0.4315;
chart.ChartData[2, 1].NumberValue = 0.053899999999999997;
var startIndexAddSeries = chart.Series.Count + 1;
for (int i = startIndexAddSeries; i <= seriesCount; i++)
{
chart.Series.Append(chart.ChartData[0, i]);
}
if (chart.Series.Count > seriesCount)
{
for (int i = chart.Series.Count - 1; i >= seriesCount; i--)
{
chart.Series.RemoveAt(i);
}
}
chart.Categories.CategoryLabels = chart.ChartData["A2", "A" + (categoryCount + 1)];
for (int i = 0; i < seriesCount; i++)
{
string letter = GetColumnName(i + 1);
chart.Series[i].Values = chart.ChartData[letter + "2", letter + (categoryCount + 1)];
}
presentation.Slides.Append(cloneSlide);
//Save and launch to view the PPTX document.
presentation.SaveToFile("PieChartEditDataCrashing_01.pptx", Spire.Presentation.FileFormat.Pptx2010);
}
public static string GetColumnName(int index)
{
const string letters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
var value = "";
if (index >= letters.Length)
value += letters[index / letters.Length - 1];
value += letters[index % letters.Length];
return value;
}
}
}
