Free Support Forum - aspose.com

Workbook.Open exception when opening Excel 2007 .xlsm fiile

Hi,

I’m getting an Invalid formula error when using the Workbook.Open function with an Excel 2007 .xlsm file. I’m able to open the offending file\worksheet when using the Workbook.LoadData function, but do to requirements need to use the Workbook.Open function.

The code I’m using is:

wb.CalcMode = CalcModeType.Manual;
wb.ReCalcOnOpen = false;
wb.Open(@fileName);

Also I’ve installed the Aspose.Cells.4.8.2.3 version that was posted earlier today, but still get the error. Any help or insight appreciated.

Thanks,
Dean


Error in Cell: C52-Invalid formula:"=-+Deprec!Y56*LPShare_OP".

Trace

at x9d2539cac3622db3.x40937ad35b1cf5f7.x1f490eac106aee12(Cell xe6de5e5fa2d44af5, String xef81f2df12e64618, Byte x804d9de34bfbea97)\r\n at Aspose.Cells.Cell.set_x899ab9e9fa6303bc(String xbcea506a33cf9111)\r\n at xabb58b8f2887ff8e.x7661ca2b53df3da9.xb953ef709de3d2ab(XmlTextReader xb9763b0038341e6c, Int32 x3e0a106e44f5f6eb, Int32 x5b0d56b787e972e9)\r\n at xabb58b8f2887ff8e.x7661ca2b53df3da9.xd9c6f1ce6ced5eb4(XmlTextReader xb9763b0038341e6c)\r\n at xabb58b8f2887ff8e.x7661ca2b53df3da9.x5b9fbbb55c31a1b7(XmlTextReader xb9763b0038341e6c)\r\n at xabb58b8f2887ff8e.x7661ca2b53df3da9.x06b0e25aa6ad68a9(XmlTextReader xb9763b0038341e6c)\r\n at xabb58b8f2887ff8e.x9d49ab444acbddce.x72bde2882aefe5af(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)\r\n at xabb58b8f2887ff8e.x9d49ab444acbddce.xc3266f78bb6c4216(x1f5f0dd7560ed867 xd9171314ec0b2957, String x7d11dcd405070662)\r\n at xabb58b8f2887ff8e.x9d49ab444acbddce.x88ae89d546ee9fdf()\r\n at xabb58b8f2887ff8e.x9d49ab444acbddce.x06b0e25aa6ad68a9()

\r\n at xabb58b8f2887ff8e.xe95a61e48a6637a3.x2e7f798eabefe5b4(Workbook xce16031e3118b903, Stream xcf18e5243f8d5fd3)\r\n at Aspose.Cells.Workbook.Open(Stream stream, FileFormatType type)\r\n at Aspose.Cells.Workbook.Open(String fileName)\r\n


Hi Dean,

Thank you for considering Aspose.

Please share your template file here. This will help us figure out the issue soon.

Thank You & Best Regards,