Am working on BIRT-2.3.2 . I am able to generate the reports in excel
format.
But the problem is, it shows formula error on the grids in excel sheet ,
saying - "The number in this cell is formatted as text or preceded by an
apostrophe" .
This error is shown for the fields like SSN and zipcode which are always
numerical in nature.For an alphanumeric field like adddress, it does not
show this error.
I have set the datatype of these fields as String and not integer.
Because, if i set it to integer , it shows the values as for eg :2,333 for
zipcode or SSN fields which does not make sense.
How do i get rid of this error .
Can anybody please help me out.