Formatting of Exel Cell changed from Number to Custom ([h]:mm:ss)/Custom (mm:ss) format after data filling

Aspose.Cells Product Family
21

So this was not handled in older version, but its handled as part of an enhancement for the merge() method. So we should not do any merging on the merged area.

Any way we remove the merged section from the template excel.

Thanks for the explanation.

Thanks & Regards

Karuppiah

22

Hi,

One of our reports we are getting the below exception when we do

worksheet.getCells().copyCellRange(.........)

Encountered an Exception
com.aspose.cells.CellsException: Invalid parent XF: 36
at com.aspose.cells.Workbook.c(Unknown Source)
at com.aspose.cells.Workbook.b(Unknown Source)
at com.aspose.cells.eu.a(Unknown Source)
at com.aspose.cells.Cell.a(Unknown Source)
at com.aspose.cells.Cells.copyCellRange(Unknown Source)
at

We are not able to findout the root cause of the above issue. Please clarify how to avoid and what is the root cause of this Invalid parent XF: 36 issue.

Thanks & Regards

Karuppiah

23

Hi,

Kindly post your template file (if you have) and paste your sample code here to reproduce the issue you have mentioned. We will check your issue soon.

Thank you.

24

Hi Amjad,

We found the root cause of this issue.

Root cause: The name of the NamedRange has some special charactes (test(name)). So its not allowing to do CopyCellRange in the latest version. Even in MS Excel also it will not allow to find the NamedRange has special character.

We have modified our code to handle this special character. Now its working fine.

Thanks & Regards

Karuppiah

25

Hi Amjad,

Still we have the same issues even we removed the NamedRange special characters.

com.aspose.cells.CellsException: Invalid parent XF: 36

at com.aspose.cells.Workbook.c(Unknown Source)

at com.aspose.cells.Workbook.b(Unknown Source)

at com.aspose.cells.eu.a(Unknown Source)

at com.aspose.cells.Cell.a(Unknown Source)

at com.aspose.cells.Cells.copyCellRange(Unknown Source)

PFA, the demo program with the template excel files for the issue replication(Below are the files).

1) DEMOASPOSETESTING.java

2) targetWorkbook.xls

3) templateWorkbook.xls

Note: We are wondering If we open the Both Excels and simply save, then its not throwing any exception.

Please resolve this issue ASAP.

Thanks & Regards

Karuppiah

26

Hi,

I can find the issue (using your sample files and code segment) as you have mentioned initially. I have logged your issue into our issue tracking system with an id: CELLSJAVA-18628. We will look into your issue soon.

Thank you.

27

Hi,

Please try the attached version, we have fixed an issue of copying cells.

Thank you.

28

Hi Amjad,

With the latest Aspose(version 2.3.1.1) which you have given has basic issues in it. We are getting exception at

Worksheet.copy(Worksheet); and

Cells.insertColumns(int,int) are not working.

PFA, files(demo program with template and target Excels) for the issues replication.

As you must have known, we have raised several issues before. Each time you provide us with a new jar as solution, it always had new issues which were not present in the previous versions. Due to this our testing effort increases exponentially.

Why do the issues stated in the above para come up time and again?

We request you to provide with newer versions that you are sure will contain all the previously working functionalities in the older versions. This will help both of us to resolve the issue in an easier way.

We need you to resolve these issues in the latest version provided to us ASAP as there will be schedule deviations on our side to the customer.

Thanks & Regards

Karuppiah

29

Hi Karuppiah,

Thanks for sharing the sample files with code.

Well, we have found the issue as you mentioned demonstrated by your test files and code. We are sorry for the problem. Actually, it is not newly introduced bug of the last fix 2.3.1.1, but, as a matter of fact, it has been there from some previous fixes/versions. When we give a new version/fix to the users, we always conduct many tests or uses many test cases. However, sometimes, our test cases might not be sufficient and cannot cover all the situations the users might have in their environments for their needs. Also, for some scenarios we might not implement them all. This is again some limitation put forth by the diverse situations or multiple environments. Anyways, we will try to extend our testing system if we can. And, for this particular issue, we will try to provide a fix asap.

Thanks for your understanding!

30

Hi Amjad,

I appreciate your timely response. Waiting for the solution.

Thanks & Regards

Karuppiah

31

Hi Amjad,

Any updates on this ?

Thanks & Regards,

Karuppiah

32

Hi,

<span style=“font-size: 10pt; font-family: “SimSun”,“serif”;”>we
have gathered more template files into our test cases and we are testing this
feature thoroughly with those cases. Hopefully we can provide a new fix in 1-2
days.<o:p></o:p>

Thank you.


33

Hi Amjad,

We are going to move the latest jar in to Production as soon as you provide us with it. Since we are going to move it quickly, there can only be sanity and basic round of testing done from our side. So, we expect that the jar you provide us do not have any issues with the existing fuctionalities and also free of regression issues. Although we have a production move, we are not hurrying you because we expect thorough testing to be done from your side.

Also please do let us know the Expected Time of Completion(ETC) to us so that we can share it with our client.

Thanks & Regards,

Karuppiah

34

Hi,

We have made improvements for copying cells and tested this feature with more test cases. From our side we have not found any exception while copying by all our test cases with this new fix (attached). Please try it.

Thank you.

35

Thanks Amjad,

We are using this jar. We will get back to you incase of any issues.

Regards,

Karuppiah

36

Hi,

We are using the latest Aspose.Cells (version 2.2.1.4). As part of the testing we found an issue while using the method cell.getStringValue()

Issue description:

We have a date which is in the custom format of yyyy/m/d h:mm AM/PM ("3/12/2009 7:50:02 PM"). When I use the method(cell.getStringValue()) to get the value. it is giving "39884.82641203704".


Please find the attached sample Demo program(DEMOASPOSETESTING.java) for this issue. Also sending you the Template Excel(sampleWorkbook.xls) .


Same kind of implementation is working fine the older Aspose.Cells (version 2.1.0.6)

Please let me know what cause this issue in the latest version which is not happening in older version of Aspose.Cells.

And also the performance is very bad when compared to the Old Jar.Please provide the fix for the performance fix too.

Thanks & Regards

Karuppiah

37

Hi,

I have found the issue as you have described. We will figure it out soon.

I have logged your issue into our issue tracking system with an id: CELLSJAVA-19057.

Thank you.

38

Hi Amjad,

We should have move this latest jar into production yesterday.Since we found the above issue, we didn't promote this jar to Production.Once you provide the latest jar, there can only be sanity and basic round of testing done from our side. So, we expect that the jar you provide us do not have any issues with the existing fuctionalities and also free of regression issues. Although we have a production move, we are not hurrying you because we expect thorough testing to be done from your side.

Also please do let us know the Expected Time of Completion(ETC) to us so that we can share it with our client.

Thanks & Regards,

Karuppiah

39

Hi,

We will off course conduct several tests to check your current issue should be fixed in all aspects. Also, we make other tests to scan it for regression bugs. We will try to give you an eta for the issue soon.

Thank you.

40

Hi Amjad,

Any updates on this ?

Thanks & Regards,

Karuppiah