Images in cells

1 Answer 140 Views
Spreadsheet
Albert Shenker
Top achievements
Rank 1
Veteran
Iron
Albert Shenker asked on 26 Oct 2022, 12:29 PM
Is there a way to insert an image (ostensibly a transparent background image) in a SpreadProcessing worksheet cell like there is in Excel? If not, is there a way to accomplish the same thing with Cell styles? Attached is an example.

1 Answer, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 31 Oct 2022, 10:59 AM

Hi Albert,

Using the Telerik Document Processing Libraries, it is possible to insert Images/Shapes into the worksheet. You can find instructions for that in the Shapes and Images - RadSpreadProcessing section of the documentation.

Those images, however, will not act as a background for the cell or the worksheet. They are rather additional objects that will lay over the worksheet independent of the cell.

 

By looking at the screenshot, I assume you are trying to mark a cell with a red triangle shape, is that right? That is what happens in MS Excel if you add a note.

 

If you'd like to add notes to cells, that is also possible using the RadSpreadProcessing. Instructions can be found in the Notes - RadSpreadProcessing section of the documentation.

 

Please let me know if you have any questions.

 

Regards,
Attila Antal
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Albert Shenker
Top achievements
Rank 1
Veteran
Iron
commented on 31 Oct 2022, 12:30 PM

I need different colored triangles to mean different things. I’ll take a look at the shapes and images feature. If i need to include a shape in many different cells, is it possible to clone a single shape object, or would i need to create new images from a memory stream for each?
Tanya
Telerik team
commented on 01 Nov 2022, 02:21 PM

Hi Albert,

From all the types of shapes, SpreadProcessing currently supports only images. Thus, to achieve that requirement, you will need to place images in the cells. Sharing a single image across different cells is not possible and you will need to keep different objects for each cell.

Hope this information is useful.

Tags
Spreadsheet
Asked by
Albert Shenker
Top achievements
Rank 1
Veteran
Iron
Answers by
Attila Antal
Telerik team
Share this question
or