How to keep number formatting with Excel output?

Elja · 2017-02-08T03:50:33+00:00

Hey. Is there a way to keep the number formatting of a Birt report when exported in Excel (xlsx)? In Birt I use this following format: Format Number * Format as: Fixed * Locale: English Fixed settings * Decimal Places: 2 * Rounding mode: Half up +…

Elja

Hey.
Is there a way to keep the number formatting of a Birt report when exported in Excel (xlsx)?
 
In Birt I use this following format:
Format Number
* Format as: Fixed
* Locale: English
Fixed settings
* Decimal Places: 2
* Rounding mode: Half up
+ Use 1000s separator
Preview with format: 1,234.56
 
With PDF and Word, the format seems to stay, but when exported in excel, the format is not the English style anymore.
It switches back to default Finnish style: 1 234,56.
 
So: is there a possibility to bend Excel to keep the formatting given in Birt?
 
- Elja.

Find more posts tagged with

Comments

micajblock

What version and which emitter are you using?

Sushma Gampa

Hi, 
 
I too have the same problem.
 
I think org.eclipse.birt.report.engine.emitter.prototype.excel_4.4.2.v201410272105 is the default emitter used. I could find the spudsoft plugin under my eclipse plugins but ,could find reference to the prototype excel emitter in the plugin.xml of the birt-runtime.jar
 
Any advise is greatly appreciated.
 
Regards,
Sushma