Hi,

We are using Aspose.cells Version 2.1.0.6.

In our Application, an excel template is being used to generate excel reports. The formatting for certain Cells in the template is 'Number’ with 1 decimal place . But after data filling in to that Cell it gets changed to 'Date Format'. We have not performed any format change in our code explicitly.

This undesired action is not happening consistently. An example has been attached to help in visualizing the scenario.

 

Note: This formatting change is not happening consistently. Please help us to resolve this Issue. Please find the attached excel file for your reference.

Thanks in advance.  

Thanks & Regards,

Karuppiah M

Hi,

Thank you for sharing the template file.

We will look into your issue and get back to you soon.

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. If you still face any issue, please share your sample code here to figure out the issue.

Thank You & Best Regards,

---

Nausherwan Aslam
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Nausherwan

Thanks for the response.

 We would like to clarify certain points with you.

1. The issue we reported emerged all of a sudden in the production environment which is running in "SUN SOLARIS-10". This is not at all replicable in offshore which is running in WINDOWS environment.

2. The application has been using this aspose.cells jar version" 2.1.0.6". Why did this issue arise all of a sudden and this issue does not arise frequently. Could you please give us the root cause?

3.  We are going to proceed with our tesing process shortly. So, we would like to know the specific fix presnt in this latest jar file that will rectify this issue?

Kindly do the needful.

Thanks & Regards

Karuppiah M

Hi,

It is not clear to us too why such issue occurs randomly. Before finding out the root cause of this issue, we are not sure whether it is fixed in the latest fix. I am afraid we need your help to verify it by using this new fix in your environment to check whether such issue will arise again. We have tested the version 2.1.0.6 with your template file by filling data into those cells but cannot find such issue at all. So I am afraid we need your test program to reproduce such issue so that we can figure it out soon. And, please provide us some other information about your environment such as OS/JDK vendor and version details etc, and so on. Using all our experience, there might be some strange behaviors with IBM's JDK which occur randomly. If so, we will provide you a special build for IBM's JDK which may avoid such issue.

Thanks for your understanding and help.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Right now testing in Production environment is not possible because the latest Aspose.Cells has to be deployed there, but i can give you the details of the production environment.

Operating System: Sun Solaris 10

JDK Version:  jdk142_05

Issues with the latest Aspose: As part of the Initial testing with the latest Aspose.Cells (version 2.1.1.24) at windows environment, the functionality which used to work fine seems to have some issues now, particularly in NamedRange.getCells() and  Worksheet.copy(Worksheet). Attached the Error log  for your reference. Please do the needful to rectify all. 

We would like to bring to your notice that with many issues popping up, we would not be able to proceed with the latest Aspose.Cells (version 2.1.1.24). As, Excel reporting functionality is very essential for our application,we will for now continue to work with the old version(2.1.0.6) and wait for the fixes for the excel formatting issue from you.

If you could resolve this issue as early as possible, since it is a production issue, we would appreciate it.

Thanks & Regards

Karuppiah M

Hi,

Thanks for providing us the details with error log file.

We will look into it and get back to you soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Hi,

We have fixed the issue of copying Worksheet/Workbook and the ArrayIndexOutOfBoundsException that caused by 2.1.1.24 version. Please try the attached version and let us know if it works fine now.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

We are going to do the regression testing with the latest Aspose.Cells.jar (version:2.1.1.26).

Please let us know whether you have come across any such scenarios before that throws up this formatting issue. Knowing this would help us in narrowing down on this issue. 

And also please do let us know, whether we need to do anything in the excel template/code/setting to avoid such issue.

We will keep you updated on the proceedings of our testing.

Thanks & Regards,

Karuppiah M

Hi,

"Please let us know whether you have come across any such scenarios before that throws up this formatting issue. Knowing this would help us in narrowing down on this issue. "

Well, we have not found or we are not reported (by the users) such issues before.

"And also please do let us know, whether we need to do anything in the excel template/code/setting to avoid such issue."

There is no special instructions for your template file or for writing code what so ever, it should be normal as other users do. Actually, we could evaluate the main reason why you are finding such an issue, so we cannot give you further instructions.

Please try the latest version (we attached previously) and let us know if you still find the issue.


Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Copying Worksheet/Workbook is working fine with the latest Aspose.Cell.jar(version:2.1.1.26)

But the issue does not seem to be fixed for ArrayIndexOutOfBoundsException. Still we are facing ArrayIndexOutOfBoundsException with latest Aspose.Cell.jar (version:2.1.1.26) for some reports which used to work earlier.

Below error log for your reference. 

java.lang.ArrayIndexOutOfBoundsException: 0
 at com.aspose.cells.C.i(Unknown Source)
 at com.aspose.cells.C.a(Unknown Source)
 at com.aspose.cells.Rows.getRow(Unknown Source)
 at com.aspose.cells.Cells.getCell(Unknown Source)
 at com.aspose.cells.Cells.getCells(Unknown Source)
 at com.aspose.cells.Range.getCells(Unknown Source)
 at com.aspose.cells.NamedRange.getCells(Unknown Source)

Could you please fix.

Thanks & Regards,

Karuppiah M

Hi,

Thanks for your feedback,

We will further look into it and get back to you soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

We have found the possible cause for ArrayIndexOutOfBoundsException, we will fix it soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

We have fixed the issue of ArrayIndexOutOfBoundsException, please try

this update.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us