Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Excel Date issue in BIRT Report(Excel Report date formatting for fr_CA locale)
Excel Date issue in BIRT Report [message #1805165] Tue, 09 April 2019 06:18
Lakshminarayana Golla is currently offline Lakshminarayana GollaFriend
Messages: 1
Registered: April 2019
Junior Member
Hello Everyone,

I am trying to display dates in excel report. the format to be displayed in MMM dd yyyy for both English and French(Canada). In report the desired date format is displaying but not as a date filed, it is displaying as a text field. due to this I am unable to format the those columns in excel.

I am using ExcelEmitters for this. Can you please help me in displaying those excel cell as date fields with format MMM dd yyyy.

For English: NOV 15 2018 (should be date but displaying as text)
For French: nov. 15 2018 ((should be date but displaying as text)

I have attached the file generated excel report.

Similarly I am facing the similar issue with number types like currency amount. after formatting with locale they are displaying as text but expecting number types.

Ex: If we double click on the dates then currency symbol should vanish in case of number types but due to text types unable to do further formatting
For English: $(10,000.00)
For French: $(10 000,00)

Can anyone please help me in displaying those fields as Date/Number fields other than text fields in Excel report.

Thank you in advance.

Best Regards,
Lakshminarayana Golla

  • Attachment: report.xls
    (Size: 53.50KB, Downloaded 25 times)
Previous Topic:Where i can find BIRT runtime version 4.8.0 for maven
Next Topic:Creating Multiple Tab in single Report
Goto Forum:

Current Time: Thu Sep 24 16:17:56 GMT 2020

Powered by FUDForum. Page generated in 0.06560 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top