Issue with 0000000E0021 data format

Aspose.Cells Product Family
1

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.

Thanks,
Ramesh.AsposeIssue.zip (4.8 MB)

2

@PrasunaKota,
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)

3

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

4

@PrasunaKota,
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
5

@PrasunaKota,

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.