Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Spread Designer Guide / Spread Designer Editors / Formatter and Editor
In This Topic
    Formatter and Editor
    In This Topic

    The Format Cells dialog of Spread Designer enables you to format the data displayed in a cell. Using the six tabs available in this dialog, users can modify number formatting, alignment, font, border, fill, and protection.

    In order to launch the Format Cells dialog from the Spread Designer, follow these steps:

    1. Select a cell or a cell range in the worksheet that you wish to format or edit.
    2. Right-click on the selected cell or the cell range.
    3. Choose the option Format Cells from the displayed context menu.

      You can also use the keyboard shortcut Ctrl +1 to call the Format Cells dialog.
    4. The Format Cells dialog will appear on the screen.
    Formatter and Editor

    Using the Number tab of Format Cells dialog, you can format the values in cell as fractions, currency, percentages, decimals, scientific data, date, time etc. Selecting the Custom category enables you to create custom code formats based on the available code formats.

    To know more about cell formats in Spread for WinForms, refer to Working with Cell Format Strings.