Spread Windows Forms 17
In This Topic
    IMAGE
    In This Topic

    This function returns an image within a cell.

    inserts images into cells, instead of floating on top. This way you can move and resize cells, sort and filter, and work with images easily.  

    Syntax

    =IMAGE(source,[alt_text],[sizing], [height],[width])

    Arguments

    The function has the following arguments:

    Argument

    Description

    source

    		 The location of the image on the web (Supported file formats include BMP, JPG/JPEG, GIF,TIFF, PNG, ICO, and WEBP) 

    alt_text

    		 [optional] Alternative text that describes the image.

    sizing

    [optional] Specifies the image dimensions. Possible values are as follows:

    • 0:   Fit the image in the cell and maintain its aspect ratio.
    • 1:   Fill the cell with the image and ignore its aspect ratio.
    • 2:   Maintain the original image size, which may exceed the cell boundary.
    • 3:   Customize the image size by using the height and width

    height

    		 [optional] Refers to the height of the image only when sizing 3 is used.

    width

    		 [optional] Refers to the width of the image only when sizing 3 is used.

    Remarks

    This IMAGE function can help you move and resize cells, sort and filter, and work with images easily.

    Data Types

    The function returns an image.

    Examples

    image-function

    Version Available

    This function is available in product version 16.0 or later.

    Note

    Spread for WinForms provides the GC.IMAGE function to place an image in a cell. For more information, refer to the Image Sparkline topic.