nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data triming while exporting the report output to .csv

nsuraj

Hi
I am Using BIRT for reporting in my project.
The report shows correct value for amount(String) as 123456789123, but when i try to export the same report into csv, the csv file shows same amount as 1.234E11.
I want to value as 123456789123 in csv too.
Please help
Thanks

Find more posts tagged with

Comments

mwilliams

What's your BIRT version?

nsuraj

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="110111" data-time="1349312050" data-date="03 October 2012 - 05:54 PM"><p>
What's your BIRT version?<br /></p></blockquote>
3.2.17

mwilliams

It seems to be an issue with the formatting in Excel. If you open the csv file in notepad or something, it shows the whole number. Also, if you change the format of the cell, in Excel to "number", the entire number is showed. You might be able to edit the csv emitter to set this by default.