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.
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?
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.
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.
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.
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.
"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.
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)
java.lang.IllegalArgumentException: Invalid row or column index of range. at com.aspose.cells.Range.getCell(Unknown Source) at com.aspose.cells.NamedRange.getCell(Unknown Source)
This is a show stopper and due to this we are not able to know whether the other functionalities are working fine.
We want to sternly stress upon a point that the older version was working fine except for the issue we had stated in the previous mails. But the versions you keep sending us seems to have issues with the existing functionalities. Kindly make sure that the next version you send us to solve the issue and it does not affect the existing functionalities.