Webi export to excel misaligned border free cell

[Former Member]

Hi

I'm using Webi XI 3.1 SP3 FP 3.3.

I've a report in which I've put border using a Free standing cell. When I export this report in Excel format (browser/rich client), the border comes as empty at the start of the excel and after which the report blocks/data come.

Why is this happening?

Thanks

Deep

[Former Member · Accepted solution]

hi Deep,

Blank Cell is not treated as block.

Whereas Chart and tables are treated as blocks.

Hence the relative positioning between the blocks is preserved.

But not blank cell.

This can be observed by looking at properties tab of Chart/Table. You will see 'name' as block

But this doesn't holds good for Blank cell.

That's the reason Excel treats it as a separate entity.

Regards,

Vamsee

[Former Member]

It seems you need border on Page/Table.

Did you try putting Border on Table through table/block property. Also you can check the page property as well.

[Former Member]

Hi srrachna

I'd like to have some gap between the block and the border. Border using table/block/page property is not useful because I can not set gap.

Thanks

Deep