Background Image not getting exported to Excel

12 posts, 0 answers
  1. Touzi
    Touzi avatar
    6 posts
    Member since:
    Mar 2014

    Posted 18 Sep 2015 Link to this post

    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,

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 22 Sep 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 20 Jul Link to this post

    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.

  5. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 21 Jul Link to this post

    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.

  6. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 22 Jul Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  7. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 26 Jul Link to this post

    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.

     

  8. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 26 Jul Link to this post

    Sorry, forgot attachements.

    Regards

  9. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 27 Jul Link to this post

    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

     

  10. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 27 Jul Link to this post

    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

  11. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 27 Jul Link to this post

    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
  12. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 28 Jul Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  13. Diego
    Diego avatar
    8 posts
    Member since:
    Mar 2015

    Posted 01 Aug Link to this post

    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.

Back to Top
DevCraft banner