Eclipse Community Forums: BIRT » Excel export of crosstab

Help

Home

Home » Archived » BIRT » Excel export of crosstab(Error when empty cell due to data type)

Show: Today's Messages :: Show Polls :: Message Navigator

Excel export of crosstab [message #519358]

Mon, 08 March 2010 15:46

Missing name Missing name

Messages: 94
Registered: November 2009

Member

Hi,
I have a crosstab that shows integers in the cells. There can be scenarios where some cells are empty but I just replace the NULL value with zero, which is fine.
However, when I export the crosstab to excel, the empty cells get a zero value (as expected) but they have an error "The number in this cell is formatted as text or preceded by an apostrophe".

Is there anyway I can force BIRT to export it as an number? The cell within the crosstab has type Integer and i've tried setting a custom number format on it but that doesnt work.

Any ideas?
thanks

[Updated on: Mon, 08 March 2010 15:47]

Report message to a moderator

Re: Excel export of crosstab [message #519381 is a reply to message #519358]

Mon, 08 March 2010 11:50

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Trevor,

Can you log a bug for this?

Jason

TREVOR.HIGGINS@FINEOS.COM wrote:
> Hi,
> I have a crosstab that shows integers in the cells. There can be
> scenarios where some cells are empty but I replace the value with zero,
> which is fine.
> However, when I export the crosstab to excel, the empty cell get a zero
> value (as expected) but they have an error "The number in this cells is
> formatted as text or preceded by an apostrophe".
>
> Is there anyway I can force BIRT to export it as an number? The cell
> within the crosstab has type Integer and i'v tried setting a custom
> number format on it but that doesnt work.
>
> Any ideas?
> thanks

Report message to a moderator