Background Image not getting exported to Excel

[Touzi]

I created a report that contains a cell as an indicator (conditional formatting --> new rules --> If .... --> Background --< imagedata). When y try to export the report to excel format. The cell is emplty ?!! (it work when i export the report to pdf).

Any solution ?

Regards,

[Stef]

Hi Touzi,

Reports are rendered in Excel based on the Design Considerations for Excel Rendering.
Note that background images are not exported.

Regards,
Stef
Telerik

[Diego]

Hi Telerik Staff,

I have a problem for some days and i think it is related to this post. The problem is with a Background Image inside a table cell that has conditional formatting dependency of a boolean value of the datasource, depending on the value it shows one image or another one.

The problem is when exporting to different formats, in Excel i don´t get the Background Image but i had read it is not possible, i would like to say ok, but i can say only not bad. When exporting to PDF or printing, the Background Image is much smaller than showed on the web as you can see on images, am i missing anything? 

I´m working with Angular JS UI (so HTML5) and .Net ReportApi.

Thanks for help.

[Diego]

Hi again,

I would like to "translate" this column too or maybe having a non visible column with the boolean value in the web, to show this value when exporting to excel. But i don´t want to configure a full custom export to excel, if posible.

Thanks, best regards.

[Stef]

Hi Diego,

Background images are not supported on export in XLSX - Design Considerations for Excel Rendering.
Instead test using a PictureBox item. If you are visualizing data via Table item, you can place a Panel item in a cell in order to add a PictureBox and TextBox items in the cell.


About the produced PDF files, reports are processed and rendered on the server machine. Please check the DPI settings of the server machine and if the issue is reproducible if you export from other machine.
We will appreciate it if you open a support ticket and send us the problematic report and details about the server machine.


About modifying the report for different formats. On export from the viewer, you will get the report in its current state. Thus the user must have selected to hide the column from the report (updated the boolean parameter). Otherwise, you can export programmatically a separate instance of the same report which can be modified in code - Exporting Report Programmatically.

Regards,
Stef
Telerik by Progress

[Diego]

I couldn´t change DPI seetings of server because it is a virtual machine. However, as can you see, i got another image on the header thats shows in correct size, i´m pretty sure it is not about DPI settings.

Haven´t understand well about excel, but ok, i have to find another solution, so tell me:

How can i build a report with a table where a column will be filled with 2 different images depending (conditional formatting) on one datasource boolean column value? But the image had to be perfectly exported to excel and pdf.

I don´t know what support tickets are, do i have to pay for that? Anyway, if you answer me correctly to the previous question it is all done.

Thanks, best regards.

 

[Diego]

Sorry, forgot attachements.

Regards

[Diego]

Hi,

I almost solved the problem. I used a PictureBox inside the table cell and it works, but as you can see in attachments, i don´t see the "center" value of the "sizing" property of "pictureBox" working properly (not center). I see it correct in exported pdf and excel, but not in report viewer. Any ideas?

Thanks

 

[Diego]

The website crashed and i lost a big message :(

So i will resume, i almost got it with a picture box inside the table cell. But i don´t see "center" value of "sizing" property of "picturebox" working correctly. As you can see in attachments PDF an Excel export seems fine but Report Viewer is not centering the image correctly. Any ideas?

Thanks

[Diego]

The website crashed and i lost a big message (2 times), maybe attachments :(
So i will resume, i almost got it with a picture box inside the table cell. But i don´t see "center" value of "sizing" property of "picturebox" working correctly. As you can see in attachments PDF an Excel export seems fine but Report Viewer is not centering the image correctly. Any ideas?
Thanks

[Stef]

Hi Diego,

The available ImageSizeMode options can be checked here. There is Center option which places the image in the center of the PictureBox item. Stretch and SclaeProportional can center the image as well.

PictureBox items are rendered as native Picture object in MS Excel - Design Considerations for Excel Rendering.


About support tickets, by purchasing Telerik products you get access to the support ticketing system through your Telerik account. We try to monitor forums as well, but we cannot guarantee a response by Telerik representative here.

Regards,
Stef
Telerik by Progress

[Diego]

Hi Stef,

Thanks for the reply and sorry for repeated messages, the website crashed and i didn´t see them. About tickets i understand now but it is ok for me, I´m developing a lot of things and I just take a look here when i can. 

I have the PictureBox with "center" option. I will look again the documentation in the links you provided me to see if i missed something.

Thanks, have a nice week.