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:
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.
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.
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.
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.
