Dynamic CrossTab cell width?

In the report I have a CrossTab with two "columns". For the last data item the second column contents are hidden and column should take no space. In the html this works fine and column doesn't exist (or at least takes no space). Problem arise when outputted to Excel as in there the column takes exactly the same space as all the other columns of same type. Is it possible to set cell width somehow with a script? I have tried onCreateCell method of CrosTab but didn't find any way to set cell instance width.

I have tried hiding the column by setting it's content cell display to "none". This prevents rendering of columns content, header and footer cells but space is still acquired in the Excel file. I suppose this might be somekind of bug in the Excel emitter.

I'm using Birt 2.6.1 with basic Excel emitter.

Any help appriciated,
Kalle

Find more posts tagged with

Comments

kallem

After seeing one other problem in Excel emitter I noticed that if column doesn't have size then it's size is set propotional to available space and number of columns without size. There is also no dropping if column doesn't have any content. Well, dropping might not be a good idea anyway.. Column autofit option would satisfy my needs but that cannot be done. So I suppose I have to mod the emitter to get either autofit working or to drop specific columns away.

mwilliams

Kalle,

You could always log a bug for this at http://www.birt-exchange.org/org/resources/bug-reporting/. You might check the bugs first to see if someone has already posted it though.