Values not fetched properly using getStringValue()

Dear Amjad_Sahi,

This is Shin at XLsoft.

Trial users have announced about #17.
It seems that the sample code was flawed.
The value obtained by getStringValue() was not obtained.
Please check again as we will send you an input file and the modified sample code.

File 20200826.zip (16.8 KB)


・sample code:src/pmx0002/ExtractDataToolsXls.java、ExtractDataToolsXlsx.java
・input file:resources/pmx0002/Data-Tools.xls、Data-Tools.xlsx
・execution result:Output to the console
・expected value:Extracted as it looks


Please continue to investigate.

Best regards, Shin.

@xlsoftkk,
The issue can be observed with the XLS file and is logged in our database for further investigation. We will notify you here once any update is ready to share.

Issue is logged as:
CELLSJAVA-43279 - Values are not fetch properly using getStringValue()

Following output is obtained using the sample code:
XLSX
StringValue:リスト:
StringValue:管理者名
StringValue:DNPマスタ管理者
StringValue:日付:
DateTimeValue:2020年1月10日
StringValue:2020年1月10日
DateTimeValue:2020/10/10
StringValue:2020/10/10
DateTimeValue:1/1/20
StringValue:1/1/20

XLS
StringValue:リスト:
StringValue:管理者名:
StringValue:DNP案件管理者
StringValue:日付:
DateTimeValue:2020/10/10
StringValue:2/10/10
DateTimeValue:2020年1月10日
StringValue:2年1月10日
DateTimeValue:1/1/20
StringValue:1/1/02

Dear ahsaniqbalsidiqui,

This is Shin at XLsoft.

Thank you for contacting us.
I understood. Please continue to investigate.

Please contact me again once you have some updates.

Best regards, Shin.

@xlsoftkk,
Please elaborate your expected result for the files? We did not find the issue. Please note, for xls, there are regional settings saved in the template file and for “Data-Tools.xls” the saved region is Japan. So, no matter the environment’s regional settings of the application, cells in “Data-Tools.xls” will be formatted according to Japan locale.

For “Data-Tools.xlsx”, there is no regional information in the template file, so by default cells in it will be formatted according to the locale of the environment.

To get the same formatted result for both files, you need to reset the regions of them to the same one by Workbook.Settings.Region/Locale.

Dear ahsaniqbalsidiqui,

This is Shin at XLsoft.

Thank you for your frequent investigation.
We inform trial users about the status of the investigation.

Best regards, Shin.

@xlsoftkk,
You are welcome.

Dear asad.ali,

This is Shin at XLsoft.

The results and expected values ​​of the sample code executed in the trial user environment are listed. please confirm.


[execution result]
StringValue:リスト:
StringValue:管理者名:
StringValue:DNP案件管理者
StringValue:日付:
DateTimeValue:2020/10/10
StringValue:32/10/10
DateTimeValue:2020年1月10日
StringValue:32年1月10日
DateTimeValue:1/1/20
StringValue:1/1/32


[expected value]
StringValue:リスト:
StringValue:管理者名:
StringValue:DNP案件管理者
StringValue:日付:
DateTimeValue:2020/10/10
StringValue:2020/10/10
DateTimeValue:2020年1月10日
StringValue:2020年1月10日
DateTimeValue:1/1/20
StringValue:1/1/2020


Best regards, Shin.

@xlsoftkk,
We have recorded your feedback along with the ticket and will consider it while working on this issue.

Dear ahsaniqbalsidiqui,

This is Shin at XLsoft.

Thanks for the reply.
Please continue the investigation. We apologize for your trouble.

Best regards, Shin.

@xlsoftkk,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Dear Amjad_Sahi,

This is Shin at XLsoft.

Thank you for contacting me.
Please let us know if you have any progress.

Thank you very much for your investigation.

Best regards, Shin.

@xlsoftkk,

As we told you (in our previous reply) that your issue has been resolved. You may expect the fix/new version in the next few days.

@xlsoftkk,

Please try our latest version/fix: Aspose.Cells for Java v20.8.9 (attached)

Your issue should be fixed in it.

Let us know your feedback.
aspose-cells-20.8.9-java.zip (7.2 MB)

Dear Amjad_Sahi,

This is Shin at XLsoft.

Thank you for contacting us about the new version.
I will tell the trial user this new version.

Best regards, Shin.

@xlsoftkk,

Please take your time to evaluate the new fix for your scenario. Hopefully it will fix your issue.

Dear Amjad_Sahi,

This is Shin at XLsoft.

Regarding question # 17, he tried a new version and it was solved successfully.
I got a call from a trial user.

Thank you for your support. Please close “CELLSJAVA-43279”.

Best regards, Shin.

@xlsoftkk,
Thanks for your feedback and using Aspose.Cells. It is good to know your issue is resolved now. Let us know if you encounter any issue, we will be glad to look into it and help you further.

The issues you have found earlier (filed as CELLSJAVA-43279) have been fixed in Aspose.Cells for Java v20.9. This message was posted using Bugs notification tool by ahsaniqbalsidiqui.
You may also get the new version @ Maven repos. (On Premise File Format API Releases | Aspose)