XLSIO Removes Chart Legends...WHY?!

[Adrian White]

So, my latest issue with xlsio is that it removes the legends from my charts in the template .xls file. Effectively, it''s as if it defaults the "Show Legend" option to False.

Why does it do this?
What do I need to do to workaround this very annoying issue?

Any help received would be greatly appreciated.

[Ramu]

Hi Adrian, This has been identified as a bug and I have filed a bug report with the development team. You can track the live status of this issue here http://www.syncfusion.com/support/issues/xlsio/Default.aspx?ToDo=view&questId=1149 If you are not modifying any chart properties using XlsIO then please use the option to not parse excel charts while opening the template IWorkbook workbook = excelEngine.Excel.Workbooks.Open ("Template.xls",ExcelParseOptions.DoNotParseCharts); Herewith i attach a sample. Please take a look and let me know if you have any questions. f38052ChartLegend.zip Thanks, Ramu.K

[Adrian White]

Ramu

I just wanted to say thanks. Your suggested workaround works beautifully, not only do my legends remain but xlsio no longer interferes with the chart axis, data labels, etc.

Marvellous.

Thanks again

Adrian