Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » CSV export in BIRT 2.1.1 performs unwanted data formatting
CSV export in BIRT 2.1.1 performs unwanted data formatting [message #232712] Fri, 06 April 2007 15:15 Go to next message
Eclipse UserFriend
Originally posted by:


I'm using BIRT 2.1.1 and trying to export data from the BIRT viewer. I
have fields that are defined as string in the BIRT report definition
that contain leading zeros. The export treats that data as numbers -
trimming off the leading zeroes ... and worse yet, if the data ends with
an "e" and a number, converts it to exponential notation. (e.g.
00000000092e2 turns into 92.0E+2).

I guess it would be a nice feature if the fields I was exporting were
identified as decimal in the report, but I want them treated as strings.

Is this a bug, is it intended to work this way, or is there some way
around this?

Re: CSV export in BIRT 2.1.1 performs unwanted data formatting [message #780146 is a reply to message #232712] Tue, 17 January 2012 09:09 Go to previous message
Chuscazo  is currently offline Chuscazo Friend
Messages: 3
Registered: October 2011
Junior Member
I found it !!
At least a temporary solution.

if (dataSetRow["NAME"] != null) String.fromCharCode(160)+""+dataSetRow["NAME"]

Whith this caracter String.fromCharCode(160), excel not delete the leading zero.

Best regarts
Previous Topic:Is it possible to Link OCL Queries to report on an EMF model?
Next Topic:Emdeb word document in Birt Report?
Goto Forum:

Current Time: Wed Jun 20 13:45:27 GMT 2018

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

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

Back to the top