Free Support Forum - aspose.com

Excel Cell Format Issue - Formatting of Exel Cell changed from Number to Date format after data filling

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,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for sharing the template file.

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

Thank You & Best Regards,

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,

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.

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.

Hi Amjad,

Please let us know any update on this issue.
Since it is a production issue, we would like to hear a solution from you as early as possible.
Thanks & Regards
Karuppiah M

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.
<o:p></o:p>


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.

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.

Hi,

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

Thank you.

Hi,

We have fixed the issue of ArrayIndexOutOfBoundsException, please try

this update.

Thank you.

Hi Amjad,

With the updated version of Aspose(2.1.2.0 version), we are facing the following issue which was working fine in Aspose 2.1.0.6(older version)

The issue is given below:

When we try to get the Cell from the NamedRange with the rowIndex and columnIndex we got the below error.

NamedRange namedRange = workbook.getWorksheets().getRangeByName("TEST__NAMEDRANGE"); Cell cell = namedRange.getCell(0, 0);

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.

Thanks in advance.

Thanks & Regards,

Karuppiah M

Hi Karuppiah.

Thanks for pointing out the issue.

After an initial test, I found the issue you have mentioned. It seems like a regression issue.

We will sort out the issue and try to make sure that there will be no regression bug/issue.


Your issue has been logged into our issue tracking system with an issue id: CELLSJAVA-14601.

Thank you.

Hi Amjad,

Thanks for the detailed response, Please send us the updated version of Aspose.Cells after the regression.

Thanks & Regards,

Karuppiah M

Hi,

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

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


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