System.OverflowException occurred open workbook

[Allen Modine]

I am trying to open a workbook with many worksheets and pivot tables. It used to work with version 8.4.0.10 but does not work with either 9.1.0.20 or 9.2.0.138. Since there are so many worksheets it is hard to narrow down what cell is causing the OverflowException. Can I send the file to you to review?

var excelEngine = new ExcelEngine();
var application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2007;

var workbook = excelEngine.Excel.Workbooks.Open(Path.Combine(_path, @"Template\" + SsrTemplate));




System.OverflowException occurred
Message=Value was either too large or too small for an unsigned byte.
Source=mscorlib
StackTrace:
at System.Byte.Parse(String s, NumberStyles style, NumberFormatInfo info)
at System.Xml.XmlConvert.ToByte(String s)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParseCacheRecordRow(XmlReader reader, PivotCacheImpl cache, Int32 currentRow, Int32 iFieldsCount)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParseCacheRecordRows(XmlReader reader, PivotCacheImpl cache, Int32 rowCount)
at Syncfusion.XlsIO.Implementation.XmlReaders.PivotTables.PivotCacheParser.ParsePivotCacheDefinition(XmlReader reader, PivotCacheImpl cache, IWorkbook book, String path, RelationCollection relations)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCache(String strWorkbookPath, String relationID, String& strItemName)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParsePivotCaches(String strWorkbookPath)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseWorkbook(List`1& themeColors)
at Syncfusion.XlsIO.Implementation.XmlSerialization.FileDataHolder.ParseDocument(List`1& themeColors)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseExcel2007Stream(Stream stream, String password)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStream(Stream stream, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseFile(String fileName, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, String strFileName, ExcelParseOptions options, Boolean bReadOnly, String password, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, String strTemplateFile, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String filename, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(String filename)
at MorningSSRReportCreator.Program.ProductReport(Boolean fullReport) in D:\2008\MorningReportCreator\MorningSSRReportCreator\Program.cs:line 142
InnerException:

[Jawahar Jeevanandan J]

Hi Allen,

Thank you very much for using syncfusion products.

Could you please update us the input file that reproduces the issue, so that we can analyze in detail and provide you a proper solution.

Please let us know if you have any clarifications.

Thanks,
Jawahar.

[Allen Modine]

here is the file, thanks



SSRTemplate_b80f2e22.zip

[Jawahar Jeevanandan J]

Hi Allen,

Thank you very much for your update.

We have tried to open the excel file with our essential studio version 8.4, 9.1 and 9.2. But we could not able to see the reported issue form our side posted in your last update. We have placed the sample tested at our side along with video snap shot for the same in the below link. Please try this at your side and let us know if this helps you.

Sample link: http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=Sample-1379753302.zip

Video link: http://www.syncfusion.com/uploads/redirect.aspx?&team=support&file=OverflowException-413911702.zip

Please let us know if you have any clarifications.

Thanks,
Jawahar.

[Administrator]

Hi everybody,

I've got exactly the same problem.

Have you found an issue of it?

That's very important for me.

Thanks for your help.

[Sridhar]

Hi Nicolas,

We are sorry for the delay in getting back to you.

Could you please get back to us with the excel file which reproduces the above reported Overflow exception so that it will be helpful for us to proceed further on this. Also, please get back to us with the Stact trace of an above error and the Essential Studio version to analyze more on this.

Please let me know if you require any further clarifications.

Thanks,
Sridhar.S