Formula exception when loading XLSX file

Aspose.Cells Product Family
1

I get the following exception when I try to convert an MS/Excel .xlsx file into PDF format:

Convert: "Reasonability Test Tool-X.xlsx"

Unhandled Exception: Aspose.Cells.CellsException: Error in Cell: B5-Invalid formula:"=SUMPRODUCT(--(A9:A34=B1),--(B9:B34=B2),(C9:C34))".
 at Aspose.Cells.x40937ad35b1cf5f7.x1f490eac106aee12(Cell xe6de5e5fa2d44af5, String xef81f2df12e64618, Byte x804d9de34bfbea97)
at Aspose.Cells.Cell.set_Formula(String value)
at Aspose.Cells.OpenXML.x7661ca2b53df3da9.xb953ef709de3d2ab(XmlTextReader xb9763b0038341e6c, Int32 x3e0a106e44f5f6eb, Int32 x5b0d56b787e972e9)
at Aspose.Cells.OpenXML.x7661ca2b53df3da9.xd9c6f1ce6ced5eb4(XmlTextReader xb9763b0038341e6c)
at Aspose.Cells.OpenXML.x7661ca2b53df3da9.x5b9fbbb55c31a1b7(XmlTextReader xb9763b0038341e6c)
at Aspose.Cells.OpenXML.x7661ca2b53df3da9.x06b0e25aa6ad68a9(XmlTextReader xb9763b0038341e6c)
at Aspose.Cells.OpenXML.x9d49ab444acbddce.x72bde2882aefe5af(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)
at Aspose.Cells.OpenXML.x9d49ab444acbddce.xc3266f78bb6c4216(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)
at Aspose.Cells.OpenXML.x9d49ab444acbddce.x88ae89d546ee9fdf()
at Aspose.Cells.OpenXML.x9d49ab444acbddce.x06b0e25aa6ad68a9()
at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)
at Aspose.Cells.Workbook.Open(String fileName)
at BankOfAmerica.ECI.MSExcelToPDF.ConvertExcelToPDF(String inName, String outName, Boolean thisDir, Boolean verbose) in C:\Src\Visual Studio 2008\Projects\MSExcelToPDF\MSExcelToPDF.cs:line 181
at BankOfAmerica.ECI.MSExcelToPDF.Main(String[] args) in C:\Src\Visual Studio 2008\Projects\MSExcelToPDF\MSExcelToPDF.cs:line 104

This does not happen when I convert the file from its orginal XLS form. So is there a way to ignore reading the formulas when loading an XLSX file?

2

Hi,

Thanks for providing us the template files.

Please try the attached latest fix v4.7.1.15, I have tested the conversion (Excel-to-Pdf) using both of your Xlsx and xls files with it and it works fine without any issue/exception at all.

And please check the document how you can convert excel files to pdf format: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/converting-to-pdf-files-net.html

Thank you.

3

Yes, that version of the library seems to work better.

Thanks.