Spread ASP.NET 16
Spread for ASP.NET 16 Product Documentation / Developer's Guide / Working with the Spread Designer / Using the Spread Designer / Customizing Cells in Spread Designer
In This Topic
    Customizing Cells in Spread Designer
    In This Topic

    Using the Spread Designer, you can set the cell types of cells in the data area of the spreadsheet.

    Select the cells in the window of the Designer for which you want to set the cell type.

    Spread Designer Property Grid with Cell Type Properties

    If you are setting cell types for a given cell or range of cells, use the cell types right-click menu to quickly apply the cell type. After making one or more settings, click Apply to apply the changes to Spread.

    Several editable celltypes have a Format tab that can be used to set the NumberFormat property. The NumberFormat property uses the NumberFormatInfo class. The NumberFormatInfo class may have properties that the cell type does not support. Unsupported properties are ignored.

    Format Tab for Number Type Cells

    Select the culture type and then set any of the number format properties.

    Number Format Properties

    You can enter a formula into a cell or range of cells using the Formula property from the Formula tab of the Cell page in the Spread Designer. For more information, refer to Adding Formulas to Cells. For more information on formulas and functions, refer to the Formula Reference.

    For more information on setting other properties for a cell or range of cells, refer to Customizing Sheets, Rows, and Columns in Spread Designer.

    For more tasks within Spread Designer, return to Using the Spread Designer.