Date is not properly conveted

Aspose.Cells Product Family
21

Dear Johnson,


Thank you for your reply.

We understand your concern. But maintaining the format while converting the file is a basic need for any sort of application. If you can not maintain the format, it would be a big trouble for us as we can not answer our customers. It would be much more helpful, if you can maintain the formatting as it in the CSV file. If not, at least provide us an option to export all date values as text until you fix this problem (As you are doing earlier). Let the numbers alone formatted till then. Hope you can understand our problem.

Coming to the custom parser, we can not assure the data inside the file. It can have any type of data and in any format. So, this solution might not helpful for us.

Awaiting the fix.

Thanks,
Kiran Kumar
22

Hi,

We have fixed the bug of NullPointerExcepton for TxtLoadOptions.ConvertNumericData=false. So as a workaround currently, please use this option to open you csv template file to keep the original string value for cells.


Please try our latest fixed version: v7.0.3.4


Thank you.

23

Dear Amjad Sahi,


I have tested this jar you have mentioned, but it does not solves our purpose. Because, we want the format to be maintained, without this the data would be inconsistent and we cannot answer our customers. Obviously we will be at loosing end. Atleast if you can provide us the API to treat DATE alone as text, it will be good (We always want the numbers to be formatted). In other words, we do not want to break any of the existing functionality (Earlier we are using v2.5.4.8). Please understand our situation. This is highly risky to not to maintain the format in conversions.

Only thing that bothers me most here is, the team which has build such an amazing tool can identify the DATE while converting but can not maintain the same format after conversion. I do not think, this is impossible for your team.

We are hoping for the best from you.

Thanks,
Kiran Kumar
24

Hi,

Thanks for your feedback you concerns.

We have logged it to attach with your existing issue. I have reopened your issue “CELLSJAVA-40055” again. We will look into soon.

Thank you.

25

Hi,

We will provide a new option: TxtLoadOptions.ConvertDateTimeData=false for you to keep only date values as string. We will give a new fix for it in this week. Hopefully, that can fit your requirement.

Thank you.

26

Dear Amjad Sahi,


Thank you for your reply. That would be great.

Awaiting the fix.

Regards,
Kiran Kumar
27

Hi,


We have supported TxtLoadOptions.ConvertDateTimeData for your requirement, please try the new fix (attached) with this option set as false.

Thank you.

28

Dear Amjad Sahi,


Thank you for providing the fix.

I have tried using the new jar, but it is throwing the below error,

Caused by: javax.servlet.ServletException: Cannot find black listed licenses resource or black list is invalid. Please report this error to Aspose.

Please look into it at the earliest possible.

Thanks,
Kiran
29

Hi,


Could you confirm when you used v7.0.3.4 in your environment, you don’t get this issue. And, when you use this new version v7.0.3.5, you got this issue on the same environment? We have done nothing in the Licensing module in that fix at all.

Also, you may just comment out the licensing code and execute your program to check if everything is fine. Also give us your license expiry date (you may open your license file into notepad and check the expiry date). You cannot use Aspose.Cells for Java version that is released after your subscription expiry date.

Thank you.
30

Dear Amjad Sahi,


I do not know, how I came across the issue which I have reported earlier. Now, the things are looking to be working great. I have just did what you have told me, commented license code and do the conversion, it works but with a warning. Later, I uncommented the license code and tried the conversion, surprisingly it works. At present I do not find any issues with this new jar. If and all I came across the issue again, I will get back to you.

Coming to the license expiry, we have the license till Feb 2012.

Thanks,
Kiran
31

Hi,


That’s really a good news that your issue is resolved!
32

The issues you have found earlier (filed as CELLSJAVA-40055;CELLSJAVA-40055) have been fixed in this update.

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

Dear Team,


Thank you for the update. Can we know, when can we have the build which can properly converts the date in to the format which CSV has? As a proper date not as text. This is a breakage you have made. Definitely we will get more requests from our users, why date is exporting as text? To answer them, we like to have a expected date for this fix.

Thank you again for your reply.

Regards,
Kiran
34

Hi,

We have put this task into our plan list of next year.

We will try to rebuild our parsers to convert most of numeric/datetime values correctly in the coming year.

35

Hi,

Please download and use the latest version: Aspose.Cells for Java v7.1.2.2

Now we have supported to maintain most date formats for reading csv template files.

36

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