Posted 12 April 2021, 9:07 pm ESTis it possible to insert picture into one cell and show the pciture as the new value of the cell?
inserting pictures into cells
Posted by: baloghbencefacebook on 12 April 2021, 9:07 pm EST
Replied 13 April 2021, 10:43 pm ESTHi,
You may use backgroundImage property of style class for the required functionality. Please refer to the following code snippet and let us know if you face any issues.
var style = new GC.Spread.Sheets.Style();
style.backgroundImage = "./css/images/quarter1.png";// url
Style Demo: https://www.grapecity.com/spreadjs/demos/features/cells/basic-style#demo_source_name
Replied 15 April 2021, 2:08 pm ESTHi,
This is expectd behaviour since the background image does not prevent cell value. What you could is set the null value using setValue method.
//after adding style
sheet.setValue(row, col, null)