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)
Timestamp Milliseconds in Excel
Ingo
Hi.
I'm currently facing the problem of exporting timestamp data with milliseconds to an excelfile. In the Birt Designer I set the date time format to hh:mm:ss.SSS, which works fine for displaying values in HTML, but when I export the report to excel, the milliseconds get lost. The excel format for the specific cells is set to hh:mm:ss.ss which leads to a repetition of the seconds fraction. But no milliseconds at all. Is it possible to export timestamps to excel? The only way to get it work for me was to format the source data via sql to char fields, but this is not very useful for the other output formats...
Thanks,
Ingo
Find more posts tagged with
Comments
thuston
This is the correct Excel format hh:mm:ss.000.
If we cannot export like that, please file a Defect in Resources-Report Bugs.
Ingo
<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="68709" data-time="1285264396" data-date="23 September 2010 - 10:53 AM"><p>
This is the correct Excel format hh:mm:ss.000.<br />
If we cannot export like that, please file a Defect in Resources-Report Bugs.<br /></p></blockquote>
<br />
<br />
Hi.<br />
<br />
yeah I know the correct excel format. The question is, how can I set this format, maybe only when the output format is xls? How can I achive that? When I set ss.000 in Birt than suddenly I get three zero after the seconds fraction.<br />
<br />
Thanks,<br />
Ingo
thuston
You'd have to customize the emitter.
Please file a Defect so the built-in emitter can be corrected.
