Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Export to Excel, data formatting issue.
torjoshi
I am using BIRT 2.6.0 and XLS emitter is org.uguess.birt.report.engine.emitter.xls_2.5.1.201001221050. Excel 2007.
Report shows up fine in PDF and HTML. Issue shows up in the Excel spreadsheet. Numeric field with 14 numbers is represented in Scientific notation. Does not happen to the first row, subsequent rows show the behavior. Why?
Example..
GTIN <--- Column Heading.
58665127204 <--- First row.
8.01977E+11 <--- Second row.
7.55282E+11 <--- Third row.
7.89516E+11 <--- Fourth row.
RJ
Find more posts tagged with
Comments
mwilliams
Hi RJ,
According to the data above, your first line is 11 digits long and the rest are 12. If you go to Excel and put in a 12 digit number, does it automatically make it scientific notation? If you expand the column out to fit the data, does it remain scientific notation? Or does it then display the whole number?
Let me know.
torjoshi
Hi Michael,<br />
<br />
Thank you for the quick reply. <br />
<br />
"<span style='color: #0000FF'>According to the data above, your first line is 11 digits long and the rest are 12.</span>" - You are right the 11 digit appears complete as numbers, whereas the 12 (and higher) are in scientific notation.<br />
<br />
"<span style='color: #0000FF'>If you go to Excel and put in a 12 digit number, does it automatically make it scientific notation?</span>" - Yes it does make it to a 12 digit one to scientific notation.<br />
<br />
"<span style='color: #0000FF'>If you expand the column out to fit the data, does it remain scientific notation? Or does it then display the whole number?</span>" - It always displays the scientific notation, never the whole number. However on selecting the cell, in the display at the top (along with the toolbars, next to the fx sign), it displays the correct number.<br />
<br />
Thank you once again.<br />
<br />
RJ<br />
<br />
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71626" data-time="1293025397" data-date="22 December 2010 - 06:43 AM"><p>
Hi RJ,<br />
<br />
According to the data above, your first line is 11 digits long and the rest are 12. If you go to Excel and put in a 12 digit number, does it automatically make it scientific notation? If you expand the column out to fit the data, does it remain scientific notation? Or does it then display the whole number?<br />
<br />
Let me know.<br /></p></blockquote>
torjoshi
Some more tests that I did ..<br />
<br />
Tried to format the column as General Number, Fixed and Currency ;-). None of them worked.<br />
<br />
RJ<br />
<br />
<br />
<blockquote class='ipsBlockquote' data-author="'torjoshi'" data-cid="71659" data-time="1293040584" data-date="22 December 2010 - 10:56 AM"><p>
Hi Michael,<br />
<br />
Thank you for the quick reply. <br />
<br />
"<span style='color: #0000FF'>According to the data above, your first line is 11 digits long and the rest are 12.</span>" - You are right the 11 digit appears complete as numbers, whereas the 12 (and higher) are in scientific notation.<br />
<br />
"<span style='color: #0000FF'>If you go to Excel and put in a 12 digit number, does it automatically make it scientific notation?</span>" - Yes it does make it to a 12 digit one to scientific notation.<br />
<br />
"<span style='color: #0000FF'>If you expand the column out to fit the data, does it remain scientific notation? Or does it then display the whole number?</span>" - It always displays the scientific notation, never the whole number. However on selecting the cell, in the display at the top (along with the toolbars, next to the fx sign), it displays the correct number.<br />
<br />
Thank you once again.<br />
<br />
RJ<br /></p></blockquote>
mwilliams
RJ,
It sounds like it's something that Excel is doing. I doubt there is anything you can do in BIRT to change this.
