CellsException: Invalid ValidationType

Aspose.Cells Product Family
1

Hi, I’m having issues tring to open an xslx file.
I’m getting the following error when i try to instantiate a new Workbook object with the attached file.

com.aspose.cells.CellsException: Invalid ValidationType string val
at com.aspose.cells.of.j(Unknown Source)
at com.aspose.cells.ld.w(Unknown Source)
at com.aspose.cells.ld.v(Unknown Source)
at com.aspose.cells.ld.a(Unknown Source)
at com.aspose.cells.kZ.d(Unknown Source)
at com.aspose.cells.kZ.b(Unknown Source)
at com.aspose.cells.kZ.s(Unknown Source)
at com.aspose.cells.kZ.a(Unknown Source)
at com.aspose.cells.kY.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)

May anyone help me?
Thanks

Mauro

p.s. I’m using aspose cell java vers 7.3.5.

2

Hi,


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

I have tested with it instantiating a new workbook using your attached file and it works fine.
e.g
Workbook newWorkbookTest = new Workbook(“112102-2038-4669-Check_List_Specifica_1+(1).xlsx”);

Thank you.

3

Hi,
sorry but I attached the wrong file :frowning: .

I download the new version (7.3.5.2) and try to open it (112102-2038-4669-Check_List_Specifica_1.xlsx) but I still get this error:

com.aspose.cells.CellsException: Invalid ValidationType string val
at com.aspose.cells.pW.k(Unknown Source)
at com.aspose.cells.mu.c(Unknown Source)
at com.aspose.cells.mu.a(Unknown Source)
at com.aspose.cells.mu.a(Unknown Source)
at com.aspose.cells.mq.d(Unknown Source)
at com.aspose.cells.mq.b(Unknown Source)
at com.aspose.cells.mq.u(Unknown Source)
at com.aspose.cells.mq.a(Unknown Source)
at com.aspose.cells.mp.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.(Unknown Source)
at report.xls.utils.AsposeReport.main(AsposeReport.java:71)

Mauro

4

Hi,


Thanks for the new file.

I tried opening the file into MS Excel 2007 and found the error: "Excel found unreadable… " and finally got the message that the file is corrupt, see the attached screen shot.

So, you file is corrupt file and either Excel or Aspose.Cells cannot open it fine.

Thank you.
5

Hi,
thank you for the quick reply, but I can open that file with MS Excel2010 14.0.6112.5000 (32bit)
and LibreOffice 3.5.7.2 (Build: 3215f89-f603614-ab984f2-7348103-1225a5b).

Mauro

6

Hi,


Could you try to open the file into MS Excel 2007 and let us know your feedback.

We will also evaluate your issue on our end for your mentioned Excel 2010 version.

Thank you.
7

Hi,
i cant’open the file with MS Excel 2007.

Mauro

8

Hi,


Your file seems to have corrupted data/records, so Aspose.Cells does not load it fine. Anyways, we will look into it if we can do something to read the file.

We will get back to you soon.

Thank you.
9

Hi,
any news??


Mauro

10

Hi,


Well, I have logged a ticket with an id “CELLSJAVA-40436” for your issue. We will investigate your issue in detail and get back to you.

Once we have any update on it, or we have some fix for it, we will let you know here.

Thank you.
11

Hi,

Please download and try this latest fix/version: Aspose.Cells for Java v7.4.0.3

We have fixed the issue now. Let us know your feedback.

Thanks.

12

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

This message was posted using Notification2Forum from Downloads module by aspose.notifier.