Webi 4.1 - Excel export with non wanted Blank images

[Former Member]

Hi all,

I face an issue when I'm exporting webi reports to Excel.

When the background of a cell is blue without value, in the excel exported file I found rectangular images with same color as the background.

The red arrow show the undesired bleu square image.

Attached the exported excel file.(remove .txt extention)

Any idea who to avoid this behavior ?

thanks

issueexportexcel.xlsx.txt.zip

[former_member184594 · Accepted solution]

You avoid this by inserting your own custom CSS file to WebI.

Check the link below:

[Former Member · Accepted solution]

Problem solve for all users in the platform :

I updated the server's Default CSS in : \SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\images\WebIDefaultStyleSheet.css

I changed in TABLE > :zone(header) > CELL and TABLE >  :zone(h-header) > CELL :

background-fill:bitmapAndColor; to background-fill:color;

and deleted /*background-image: boimg://TopHeaderBlue.png;*/ and /*background-image: boimg://LeftHeaderBlue.png;*/

[amitrathi239]

Hi,

Right click on the cell and click on format cell.In the Appearance select "Pattern" None.After that try.

by default with this cell is taking image.

Amit

[Former Member]

Thank you,

Is there any way to avoid this for all new reports (for all user and not only webi rich client)?

(I'm administrator of the platform)

[amitrathi239]

Hi,

I am not very sure how you can avoid for all reports. Better to raise a ticket with sap support. They will provide you the answer if this is product behaviour or any work around.

Amit