Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Cells / Working with Pattern and Gradient Fill Effects
In This Topic
    Working with Pattern and Gradient Fill Effects
    In This Topic

    Spread for WinForms allows users to import and export the pattern and gradient fill effects applied to the cells of a worksheet. With extensive support for saving progressive color shades and distinct patterns to an excel file, you can use different fill effects like shadow effect, three-dimensional color effect and reflection effect while working with spreadsheets. 

    A worksheet with pattern fill and gradient fill applied to the cells is shown in the screenshot shared below.

     

    Pattern fill

    While importing an excel file with pattern fill or gradient fill effect, the visual appearance will remain intact even when the user is using old cell types (provided the default style settings are not modified). Also, the pattern fill effects and gradient fill effects can be exported without any changes when the worksheet is set to the new flatten style mode.

    Further, if you are opening or saving an excel file with the color scale conditional fomatting rule and pattern fill applied to the cells of the worksheet, the specified color will blend with the pattern fill of the cell instead of replacing it. In such a scenario, the background color of the pattern fill is replaced by the color of the color scale rule.

    The following limitations should be considered while applying pattern fill and gradient fill effects.

    See Also