Formating excel cell as Text to geenrate BIRT xls report with more than 15 digits in a column

Hi All,I am having problem in displaying column values in excel report. In my table, each row for a particular column is having digits more than 15 and upto 30. When I generate excel report, excel is adding 0's after 15digits. I tried by adding apstophy(') before the number then its showing entire text but with apstophy which is not looking good (Customer doesn't like this). Can any body help me with a work around?. Thanks in advance.

Find more posts tagged with

Comments

GLO_FR

Hi, instead of using a simple binding, use a dynamic text fieldSee example

gsateesh

Hi,I have tried this option also but initially the generated excel report is showing entire number( even if it is having more than 15 digits) as a text. But when I click on the cell, excel is treating that as number stored as text and it is formatting as number by appending leading zeros.

GLO_FR

Which version of BIRT are you using ?

gsateesh

Hi,I am using BIRT 4.3.

GLO_FR

I've made different try but I didn't get it works like you want.The only way I found is to generate the output field as string, but you're right, when you convert text to number in Excel, it always put 0 after 15 digits.