Pie chart legend repeating

[Fathimath Nazma Rasheed]

I have done a pie chart in Excel using ExcelEngine and IChartShape. The legend of the pie chart is repeating.

Code:

            using (ExcelEngine excelEngine = new ExcelEngine())

            {

                IApplication application = excelEngine.Excel;

                application.DefaultVersion = ExcelVersion.Excel2013;

                IWorkbook workbook = application.Workbooks.Create(1);

                IWorksheet sheet = workbook.Worksheets[0];

                object[] yValues = new object[] { 2000, 1000, 1000 };

                object[] xValues = new object[] { "Total Income", "Expenses", "Profit" };

                //Adding series and values

                IChartShape chart = sheet.Charts.Add();

                //chart.Legend.IsVerticalLegend = false;

                //chart.Legend.Position = ExcelLegendPosition.Bottom;

                chart.HasLegend = false;

                IChartSerie serie = chart.Series.Add(ExcelChartType.Pie);

                //Enters the X and Y values directly

                serie.EnteredDirectlyValues = yValues;

                //serie.EnteredDirectlyCategoryLabels = xValues;

                application.DefaultVersion = ExcelVersion.Excel2013;

                application.XlsIORenderer = new XlsIORenderer();

                application.XlsIORenderer.ChartRenderingOptions.ImageFormat = ExportImageFormat.Png;

                MemoryStream stream = new MemoryStream();

                //Saving the chart as image

                chart.SaveAsImage(stream);

                stream.Position = 0;

                //Download the PDF document in the browser

                FileStreamResult fileStreamResult = new FileStreamResult(stream, "image/png");

                fileStreamResult.FileDownloadName = "Sample.png";

                return fileStreamResult;

            }

Attachment: New_folder_c0711df7.zip

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Fathimath, 

Greetings from Syncfusion. 

We are unable to reproduce the reported Pie chart legend repeating issue. The sample which we have tried at our end with the code snippet shared by you, can be downloaded from the following link. 

Sample Link: https://www.syncfusion.com/downloads/support/forum/149932/ze/F14993253225399.zip  

Please look into the following video screenshot for further reference. 

Video Screenshot: https://www.syncfusion.com/downloads/support/forum/149932/ze/SCREEN~1602277260.zip  

Kindly modify the sample and share us the issue reproducing one which will be helpful for us to investigate further and provide prompt solution at the earliest. Also, please confirm the version of Syncfusion XlsIO you are using. 

Regards, 

Keerthi. 

[Fathimath Nazma Rasheed]

hello,

I was using version 17.3.0.34.

Issue is fixed after changing version to 17.3.0.26

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Fathimath, 

Thanks for sharing the details. 

We are able to reproduce the reported Pie chart legend repeating issue in v17.3.0.34 and validating it currently. We will share the validation details on 20^th December 2019. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Fathimath, 

Thanks for the patience. 

We have confirmed the issue Chart legend is rendered twice in Chart to Image conversion and logged a defect report. We will provide the fix for this issue on 3^rd January 2020. 

Regards, 

Keerthi. 

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Fathimath, 

Thanks for your patience. 

We have fixed the issue Chart legend is rendered twice in Chart to Image conversion and generated custom assemblies in the version v17.3.0.34. The custom assemblies can be downloaded from following link. 

Custom Assemblies: https://www.syncfusion.com/downloads/support/forum/149932/ze/CustomeAssembly343876041.zip  

This fix will be included in our release version 17.4-SP1 which will be rolled out by end of January 2020.  

Regards,     

Keerthi.