Series Border Color issue in the chart and Custom Labels issue in the chart's image

Aspose.Cells Product Family
1

Amjad,

Thanks for the information. After I sent this I found a few more things that may also be bugs. Let me know if I should open new issues for these.

1.In the example above, I changed my border to black and I noticed that the same thing is occuring with the border that is happening with the shadow. The settings show up when you look at the chart in the xls, but they are not visible until you modify them.

2. I added a lable to my Pie chart from the example above. I changed the font and font size on the lable and it shows in the xlsx, but when I save to image, the font changes did not take effect.

chart.NSeries(0).Points(0).DataLabels.Text = "test1"
chart.NSeries(0).Points(1).DataLabels.Text = "test2"
chart.NSeries(0).Points(2).DataLabels.Text = "test3"

chart.ChartArea.Font.Name = "Ariel"
chart.ChartArea.Font.Size = 5

3. The same issue as number 2 with the label font data not transfering to the image occured when I was working with the Bar graph type as well.

2

Hi,


Thanks for pointing out the issues.

1) After an initial test and using the below code I can find the issue as you have mentioned.

The black border is not there in the Pie chart’s series although the settings can be seen when clicking the Format Data Series options in MS Excel for the chart.

Sample code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Adding a chart to the worksheet
int chartIndex = worksheet.Charts.Add(Aspose.Cells.Charts.ChartType.Pie, 1, 7, 13, 11);

Aspose.Cells.Charts.Chart chart = worksheet.Charts[chartIndex];

chart.NSeries.Add(“A1:A3”, true);
worksheet.Cells[0, 0].PutValue(15);
chart.NSeries[0].Points[0].Area.ForegroundColor = System.Drawing.Color.PowderBlue;
worksheet.Cells[1, 0].PutValue(25);
chart.NSeries[0].Points[1].Area.ForegroundColor = System.Drawing.Color.GreenYellow;
worksheet.Cells[2, 0].PutValue(60);
chart.NSeries[0].Points[2].Area.ForegroundColor = System.Drawing.Color.Pink;

chart.NSeries[0].Border.IsVisible = true;
chart.NSeries[0].Border.Color = System.Drawing.Color.Black;
chart.NSeries[0].Border.Weight = WeightType.SingleLine;
chart.NSeries[0].Border.Transparency = 0.5;


chart.NSeries[0].Points[0].DataLabels.Text = “test1”;
chart.NSeries[0].Points[1].DataLabels.Text = “test2”;
chart.NSeries[0].Points[2].DataLabels.Text = “test3”;
chart.ChartArea.Font.Name = “Ariel”;
chart.ChartArea.Font.Size = 5;


chart.NSeries[0].Shadow = true;

Aspose.Cells.Drawing.ShapePropertyCollection shpt = chart.NSeries[0].ShapeProperties;

Aspose.Cells.Drawing.ShadowEffect shadowEffect = shpt.ShadowEffect;
CellsColor cellcolor = workbook.CreateCellsColor();
cellcolor.Color = System.Drawing.Color.Red;

shadowEffect.Color = cellcolor;
shadowEffect.Transparency = 0.6;
shadowEffect.Size = 1;
shadowEffect.Blur = 4;
shadowEffect.Angle = 90;
shadowEffect.Distance = 3;



chart.ShowLegend = true;
chart.PlotArea.Border.IsVisible = true;
chart.ChartArea.Border.IsVisible = true;

chart.ToImage(“e:\test2\new_mychartshadoweffect.emf”, System.Drawing.Imaging.ImageFormat.Emf);

workbook.Save(“e:\test2\new_mychartshadoweffect.xlsx”, Aspose.Cells.SaveFormat.Xlsx);

The output file is attached here. I have logged a ticket with an id:CELLSNET-40941. We will look into it soon.


2) I can find this issue as well in the output image. The code is same as above. I can see the issue in the chart’s image, the custom labels are not rendered fine.

This issue is logged with an id:CELLSNET-40942. We will look into it as well as for the Bar chart.

Thank you.
3

Hi,

Thanks for using Aspose.Cells for .NET.

We have fixed this issue.

Please download and try the latest version:

Aspose.Cells for .NET 7.3.1


Let us know your feedback.

4

Hi,


Please try the new release (you may download it @: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry405613.aspx)


The release includes all your fixes (CELLSNET-40941,CELLSNET-40942) for your needs.


Thank you.

5

Thanks for fixing this.

The Borders and Shadow effect are now showing in the Excel. Unfortunatly, the shadow is still not working in the toimage function which is where I really need it but I think that is another thread.

The fonts on the labels for the Pie, Bar, And ScatterPlot(I found this issue yesterday) all now appear to be fixed in both the XLS and the ToImage.

Thanks

6

Hi,


For:
“The Borders and Shadow effect are now showing in the Excel. Unfortunatly, the shadow is still not working in the toimage function which is where I really need it but I think that is another thread.”.

If you file the issue already in other thread, please follow up your other thread for it. If not, kindly create a new thread to post the issue with all the details, sample code and files, we will check and reply you there in your new thread.

Thank you.