We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Invalid formula error

Hi,

Im trying to read a xlsx file. Im attaching the same here. While trying to read the file im getting Invalid formula error. Aspose version : 7.7.0

Kindly look into the problem.

Hi Praba,


Thank you for contacting Aspose support.

We have checked your provided spreadsheet and it seems to be corrupted/damaged because MS Excel application is unable to load the contents without repairing the damaged areas. After repairing and re-saving, Aspose.Cells can load the file just fine. Attached is a snapshot of the error for your reference.

Hi,

I could see the error message. Can you find the column/ formula which causes the problem.

And one more issue which returns the following trace :

Exception:20014-06-02T00:00:00Z cannot be parsed. at DateTime.b(LN:-1) at DateTime.a(LN:-1) at e.h(LN:-1) at zr.b(LN:-1) at zr.e(LN:-1) at zr.d(LN:-1) at zr.a(LN:-1) at aac.y(LN:-1) at aac.a(LN:-1) at aab.a(LN:-1) at Workbook.a(LN:-1) at Workbook.(LN:-1) at new com.aspose.cells.Workbook(inputstream)

Can you point out the case in which this error occurs

Hi Praba,


Thank you for writing back.

We have logged an investigative ticket (CELLSJAVA-40842), providing your spreadsheet to the core development team for thorough analysis. Please spare us little time to check out the problem cause. In the meanwhile, we will keep you posted with updates in this regard.

Hi Praba,

Thanks for using Aspose.Cells for Java.

Now we give more meaningful message that can point out which cell and formula cause the issue for the Exception when reading your damaged template file.

Please download and try this fix: Aspose.Cells for Java v8.1.0.1 and let us know your feedback.

The issues you have found earlier (filed as CELLSJAVA-40842) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.