Create custom cell renderers and editors to display progress bars, star ratings, and other visual elements in spreadsheet cells.
Aptos Narrow
Arial
Aptos Narrow
Calibri
Cambria
Courier New
Georgia
Segoe UI
Tahoma
Times New Roman
Trebuchet MS
Verdana
11
8
9
10
11
12
14
16
18
20
22
24
28
36
48
72
title
Hex
R
G
B
A
opacity
Hex
R
G
B
A
All Borders
Outside Borders
Top Border
Bottom Border
Left Border
Right Border
No Border
Merge && Center
Merge Cells
Unmerge Cells
Greater Than...
Less Than...
Between...
Equal To...
Text Contains...
Arrow keys move between cells. Tab moves to the next cell. F6 moves to the toolbar and out. F2 or type to edit. Press Alt+Slash for all keyboard shortcuts.
A custom editor receives a SpreadsheetCellEditContext parameter named Context. Text editors such as the Status editor
focus their input when they open, start from Context.Value and update it as the user types, so the text is committed when the user
moves to another cell. Characters typed to start editing are passed on to the input. Call Context.CommitAsync to commit, for example
on Enter, as the Status editor does, or when a value is picked, as the Rating editor does. Escape cancels the edit, and other keys, as well as copy
and paste, stay inside the editor.