ArgumentException thrown when interacting with excel worksheet: 'Can't set current serie to secondary axis'

[Michael J]

HI, i am access an excel workbook from a memorystream (having accessed it via database access).

the workbook has only one worksheet with several charts on it. I modify the values and print the sheet to pdf as report which the user can download using javascript to their browser.

when access the workbook i got this error: 'Can't set current serie to secondary axis'

I implemented the ExcelParseOptions.ParseWorksheetsOnDemand  and that gets the workbook to open. but as soon as I access/modify any ranges or charts on the worksheet it throws this error again.

I never had this problem with previous versions of syncfusion blazor components but since upgrading to 20.4 i am getting this error.  this is a major problem as my users on the website need to be able to print this report.

what should i do?

sincerely,

Michael

[Konduru Keerthi Konduru Ravichandra Raju]

Michael, the new version of Syncfusion XlsIO (20.4.0.42) is now available to download from nuget.org. Kindly upgrade to this new version, check, and let us know if the issue is resolved.

Latest NuGet Package:https://www.nuget.org/packages/Syncfusion.XlsIO.WinForms/20.4.0.42