Yet another error reading a workbook

Aspose.Cells Product Family
1

Hi again, We have tried opening more workbooks with the Aspose and found a new
error. This one we have been unable to track down to a particular sheet - we try
removing sheets until the error goes away, but when we try to leave only that
sheet in place and remove all the others the error also goes away. Attached is
the complete file.

Note: The template file is posted via email.

This message was posted using Email2Forum by Amjad Sahi.
2

Hi,

We have received you template xls file, thanks.

We have found the issue “NullPointerException” while reading/opening the file. We will fix your issue soon.

Thank you.

3

Hi,

If it's of any help, we have now added stacktrace to our error handling and see the following as part of the error message:

java.lang.NullPointerException caught: null
java.lang.NullPointerException
at com.aspose.cells.DataLabels.c(Unknown Source)
at com.aspose.cells.DataLabels.(Unknown Source)
at com.aspose.cells.aw.b(Unknown Source)
at com.aspose.cells.y.a(Unknown Source)
at com.aspose.cells.y.a(Unknown Source)
at com.aspose.cells.y.a(Unknown Source)
at com.aspose.cells.bo.a(Unknown Source)
at com.aspose.cells.bo.a(Unknown Source)
at com.aspose.cells.bo.a(Unknown Source)
at com.aspose.cells.ex.a(Unknown Source)
at com.aspose.cells.ex.b(Unknown Source)
at com.aspose.cells.ex.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.a(Unknown Source)
at com.aspose.cells.Workbook.open(Unknown Source)
at com.jovus.erpro.server.excel.AsposeCellsErproSheetReader.fileIsValid(AsposeCellsErproSheetReader.java:386)
at com.jovus.erpro.server.excel.ErproSheet.getInstance(ErproSheet.java:60)
at com.jovus.erpro.server.excel.ExcelServiceServlet.doUploadErproSheet(ExcelServiceServlet.java:283)
at com.jovus.erpro.server.excel.ExcelServiceServlet.doPost(ExcelServiceServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:204)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)

4

Hi,

Thanks for the stack trace,

We are already looking into the issue and will provide a fix when it is resolved.

Thank you.

5

Hi,

Thank you for considering Aspose.

Please try the attached latest fix (2.1.0.20), we have fixed the bug of NullPointerException. But for the file “MA model_postQ2 v1_Jovus.xls”, the resaved file will show a warning dialog: “Data may have been lost”. We are still tracing it. It seems a bit complex to figure the issue out and I am afraid we need more time.

Thank You & Best Regards,

6

Hi,

Thanks for the update. We did some initial testing and see that MA sheet uploads without any obvious error. However before we do any detailed testing on data in the sheet we want to see if you can get further with the 'Data may have been lost' warning - you are probably in a better position to identify the potential loss than we are.

So we will wait for your results.

Thanks very much for all your efforts.

7

Hello,

We are wondering if you have any update for us on this issue.

Thanks very much.

8

Hi,

We will update you soon regarding the issue.


Thank you.

9

Hi,

Thank you for considering Aspose.

Please try the attached latest fix of Aspose.Cells. We have fixed the bug that causes “Data may has been lost” error.

Thank You & Best Regards,

10

Thank you. We will test with this over the next several days.

11

The issues you have found earlier (filed as 11006;11007) have been fixed in this update.

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

Many thanks. We will test with this update.