TransparencyTolerance Property (ImageCellType)

Visual Basic
C#

'Declaration
 
Public Property TransparencyTolerance As Integer

'Usage
 
Dim instance As ImageCellType
Dim value As Integer
 
instance.TransparencyTolerance = value
 
value = instance.TransparencyTolerance

public int TransparencyTolerance {get; set;}

Property Value

Integer tolerance value

The transparency tolerance determines how close the red, green, and blue components of a color must be to the TransparencyColor to be transparent in the rendered image. For example, if the TransparencyColor is Color.White (255,255,255) and the TransparencyTolerance is 1, then the color (254,254,254) is rendered transparent.

This examples illustrates the setting of this property of an image cell type.

C#

FarPoint.Win.Spread.CellType.ImageCellType icelltype =new FarPoint.Win.Spread.CellType.ImageCellType();
icelltype.Style = FarPoint.Win.RenderStyle.Stretch;
icelltype.TransparencyColor = Color.Black;
icelltype.TransparencyTolerance = 100;
fpSpread1.Sheets[0].Rows[0].CellType =icelltype;
System.Drawing.Image image = System.Drawing.Image.FromFile("D:\\alphaomega3.jpg"); 
System.IO.MemoryStream stream = new System.IO.MemoryStream();
byte[] bytes;
string str;
image.Save(stream,System.Drawing.Imaging.ImageFormat.Jpeg);
stream.Seek(0, System.IO.SeekOrigin.Begin); 
bytes = stream.GetBuffer();
str = System.Convert.ToBase64String(bytes);
fpSpread1.Sheets[0].Cells[0,0].Value = image;
fpSpread1.Sheets[0].Cells[0,1].Value = bytes;
fpSpread1.Sheets[0].Cells[0,2].Value = str;

Visual Basic

Dim icelltype As New FarPoint.Win.Spread.CellType.ImageCellType
icelltype.Style = FarPoint.Win.RenderStyle.Stretch
icelltype.TransparencyColor = Color.Black
icelltype.TransparencyTolerance = 100
FpSpread1.Sheets(0).Rows(0).CellType = icelltype
Dim image As System.Drawing.Image = System.Drawing.Image.FromFile("D:\alphaomega3.jpg")
Dim stream As New System.IO.MemoryStream
Dim bytes As Byte()
Dim str As String
image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg)
stream.Seek(0, System.IO.SeekOrigin.Begin)
bytes = stream.GetBuffer()
str = System.Convert.ToBase64String(bytes)
FpSpread1.Sheets(0).Cells(0, 0).Value = image
FpSpread1.Sheets(0).Cells(0, 1).Value = bytes
FpSpread1.Sheets(0).Cells(0, 2).Value = str

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ImageCellType Class
ImageCellType Members