GrapeCity Forums

When in design environment selecting a picture cell and opening with right click the properties form there is an option to clear the cell.

How do I do the same in runtime (clear (remove) the picture from a specific cell)?

Yiannis

Yiannis,

You can use the ClearRange method of Spread at runtime and set it's DataOnly parameter to False, this will clear the data as well as the formatting information of the cell.

fpSpread1.Col = 1
fpSpread1.Row = 1
fpSpread1.CellType = CellTypePicture
fpSpread1.TypePictPicture = fpSpread1.LoadPicture("C:\Face.ico", PictureTypeICO)
fpSpread1.ClearRange 1, 1, 1, 1, False

Thanks

I have tried clearrange with false but it doesn't seem to work for picture cell type.

 Yiannis

Hello,

With Spread 8 v8.0.07 , the code  provided by Suresh seems to be working absolutely fine, I would request you to please test it with the same and feel free to share your observation.

The code I tried looks like,

Private Sub Command1_Click()
fpSpread1.ClearRange 2, 3, 2, 3, False
End Sub
Private Sub Form_Load()
fpSpread1.Col = 2
fpSpread1.Row = 3
fpSpread1.RowHeight(3) = 25
fpSpread1.ColWidth(2) = 5
fpSpread1.CellType = CellTypePicture
fpSpread1.TypePictPicture = LoadPicture("D:\ImagesIcon\ico\bin full.ico")
fpSpread1.TypePictStretch = True
fpSpread1.TypePictMaintainScale = True
End Sub

Clicking on the Command Button Clears the Cell Type from Cell(3,2).

Thanks,

My mistake. It does work but all cells in the range must be a picture cell type.

Yiannis