Spread Windows Forms 16
Spread Windows Forms 16.0 Product Documentation / Spread Designer Guide / Designing in the Data Area / Rich Text Editing
In This Topic
    Rich Text Editing
    In This Topic

    Spread for WinForms supports rich text editing that lets users input RichText directly in the worksheet. To implement the feature, Spread uses the built-in RichTextBox of WinForms as the cell editor.

    To enable Rich Text Editing in the designer, you have to use flat style mode (exclude LegacyBehaviors.Style from LegacyBehaviors property) and set the RichTextEdit property to On in the Properties Window. Also, to enable the keyboard shortcuts, you can set the ExcelCompatibleKeyboardShortcuts property to true.

    Spread supports the following rich text editing features:

    Format Styles

    You can format just a part of the text during cell editing using the Format Cells option from the built-in context menu.

    For example, you can change the font color of the letter 'm' as shown below.

    Pick from the drop-down list

    You can enter the data exactly as it appears in cells above or below to avoid any typos using the Pick From Drop-down List option of the built-in context menu. The keyboard shortcut for Pick From Drop-down List is Alt + Down.

    Cell Formula Editing

    Spread supports the following Cell Formula editing features:

    The following image depicts auto-complete formula and IntelliSense features in Spread UI.


    Spread allows you to validate the data for dropdown lists with the AutoComplete feature. This lets you automatically compare the text typed in a cell to all items in the dropdown list and display just the items that match. This can save the time spent on scrolling through lists, validating data errors, or writing complex code to handle that task. The keyboard shortcut for this feature is Alt + Up.

    Insert Function Dialog

    You can insert a function or edit the function's argument using the keyboard shortcut Shift + F3. Likewise, you can also insert a defined name using the function key F3. To learn more about the dialog, see Insert Function Dialog topic.