Home
Designing Analytics Reports
Export to Excel , dateTime has format tt.MM.jjjj HH:mm
Migrateduser
<p>Hello there,</p>
<p> </p>
<p>I have a report with some columns of type DateTime. When i export this report to Excel, the excel shows up a error message that there is a Format problem. After further investigation, we have observed that there is a style set in the report as following.</p>
<p> </p>
<p><NumberFormat ss:Format="[$-407]tt.MM.jjjj HH:mm"/></p>
<p> </p>
<p>this Format "tt.MM.jjjj HH:MM" is unknown to Excel and hence Excel cannot open this file.</p>
<p> </p>
<p>Can any one please help us on how to solve this?</p>
<p> </p>
<p>Thanks in Advance</p>
Find more posts tagged with
Comments
There are no comments yet