Free Support Forum - aspose.com

Can't access MarkerType in chart

Hello, I have a template presentation in which there is a Chart.
The formating of the chart in my template is perfect but when I modify the data in the sexcel sheets, I'm losing the marhertype I originally identified.
Can you tell me what am I doing wrong and/or how to set the markertype of my line in my chart.
Thank you
PS: I'm using Aspose Slide Net2.0 date 2011-02-07

Here is my code:
public void GeneratePpt(List variables)
{
var fichier = Server.MapPath(@"\\Files\PowerPoint\Template\ExecutiveKpiWithChartAndTable.pptx");
var fs = new FileStream(fichier, FileMode.Open, FileAccess.Read);
var myPres = new PresentationEx(fs);
fs.Close();

// Accessing a slide
var mySlide = myPres.Slides[0];

foreach (var var in variables)
{
var shapes = mySlide.Shapes;

for (int i = 0; i < shapes.Count; i++)
{
var shape = shapes[i];

if (shape is ChartEx)
{
var ch = (ChartEx)shape;
var ws = ch.ChartData.Workbook.Worksheets[0];

for (var j = 0; j < 12; j++)
{
var cell = ws.Cells[1, j + 1];
cell.PutValue(var.Data[0].MonthlyActual[j]);
var style = cell.GetStyle();
style.Number = AsposeTools.ReturnCellType(var.Format);
cell.SetStyle(style);

var cell2 = ws.Cells[2, j + 1];
cell2.PutValue(var.Data[0].MonthlyTarget[j]);
var style2 = cell.GetStyle();
style2.Number = AsposeTools.ReturnCellType(var.Format);
cell.SetStyle(style2);

var cell3 = ws.Cells[3, j + 1];
cell3.PutValue(var.Data[0].MonthlyActual[j + 12]);
var style3 = cell.GetStyle();
style3.Number = AsposeTools.ReturnCellType(var.Format);
cell.SetStyle(style3);
}

//ch.ChartData.AddSeries("A2:M2", ws);
//var series1 = ch.ChartData.GetSeries(0);
//series1.GetType().MakePointerType().m
//series1.Name = "PREAPPROVED";
//series1.Line.Weight = WeightType.SingleLine;
//series1.MarkerStyle = ChartMarkerType.None;
//series1.MarkerSize = 8;
//series1.MarkerForegroundColor = System.Drawing.Color.Blue;
//series1.Line.Color = System.Drawing.Color.FromArgb(79, 129, 189);
//series1.MarkerBackgroundColor = System.Drawing.Color.Transparent;


}
}
}

// Prepare output stream to receive a PowerPoint Presentation
Response.ContentType = "application/vnd.ms-powerpoint";
Response.AppendHeader("Content-Disposition", "attachment; filename=ExecutiveKpi.ppt");

var st = Response.OutputStream;

// Send the finished presentation to the page output stream
myPres.Write(st);
Response.End();
}

Hello Dear,

I have worked with the presentation and code snippet shared in detail. I regret to share that at the moment the support for accessing and changing chart markers is unavailable in Aspose.Slides. I have also found the issue of chart series markers getting changed on saving presentation. An issue with ID 25492 has been created in our issue tracking system as investigation to see why the chart makers getting changed. A separate issue with ID 24591 has been added as a new feature request to add the chart series marker support in Aspose.Slides for .NET charts. These threads have been linked with this issue so that you may be automatically notified, once these issues are resolved.

We are sorry for your inconvenience,

Hello,

I bought a licence for Aspose Cells and Aspose Slides and I was wondering whne is this issue will be corrected.

Thank you

Hello Dear,

Please accept my apologies for the delayed response.

I have verified from our issue tracking system and like to share that the issue has not yet been resolved. I have requested our development team to share any possible ETA for the issue. As soon as some information is shared, I will be obliged to share with you. I also like to share that we are in phase of re-implementing the chart support in Aspose.Slides for .NET by completely isolating it from Aspose.Cells for .NET and we are expecting it to be completed by end of Q2 or during Q3 of 2011. We will share further information with you as soon as it is shared by our development team.

Thanks and Regards,

The issues you have found earlier (filed as 25491) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.