Home
Designing Analytics Reports
How to keep number formatting with Excel output?
Migrateduser
<p>Hey.</p>
<p>Is there a way to keep the number formatting of a Birt report when exported in Excel (xlsx)?</p>
<p> </p>
<p>In Birt I use this following format:</p>
<p>Format Number</p>
<p>* Format as: Fixed</p>
<p>* Locale: English</p>
<p>Fixed settings</p>
<p>* Decimal Places: 2</p>
<p>* Rounding mode: Half up</p>
<p>+ Use 1000s separator</p>
<p>Preview with format: 1,234.56</p>
<p> </p>
<p>With PDF and Word, the format seems to stay, but when exported in excel, the format is not the English style anymore.</p>
<p>It switches back to default Finnish style: 1 234,56.</p>
<p> </p>
<p>So: is there a possibility to bend Excel to keep the formatting given in Birt?</p>
<p> </p>
<p>- Elja.</p>
Find more posts tagged with
Comments
There are no comments yet