We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Issue with 0000000E0021 data format

The issue with 0000000E0021 data : In CSV file we can see the correct string i.e 0000000E0021 after merging CSV it is showing 0000000E+0000,0000000E+0000
instead of 0000000E002,0000000E0023. I am attaching CSV files and Base template and also issue template along with my java program where i can reproduced the issue.

Ramesh.AsposeIssue.zip (4.8 MB)

I have created the output file with shared data and code snippet. Output xlsb file is attached so could you please share screenshot and column/row name where issue is occurring. Also explain your expected output. We will analyze it and provide our feedback accordingly.
output.zip (5.5 MB)

column/row is B1537, B1539 etc…
Expected out put is : 0000000E0021,0000000E0023 and also attached screenshot.scrrenshot.png (14.8 KB)

We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSJAVA-43220 - Issue with 0000000E0021 data format


We evaluated your issue further.
Such kind of data will be parsed as numeric value “0” without the original format too. To keep the original format, you may use TxtLoadOptions.ConvertNumericData=false option, or use your own parser by using TxtLoadOptions.PreferredParsers for your needs.