Settings of worksheet can be changed by invoke SetSettings, EnableSettings, DisableSettings method of worksheet instance:
var worksheet = reoGridControl.CurrentWorksheet;
// Set settings
worksheet.SetSettings(WorkbookSettings settings, bool enabled);
worksheet.EnableSettings(WorkbookSettings settings);
worksheet.DisableSetting(WorkbookSettings settings);
// Get settings
bool value = reoGridControl.HasSetting(WorkbookSettings settings);
Settings of worksheet have the following items:
Behavior
| Setting | Desc |
|---|---|
| Behavior_DoubleClickToFitRowHeight | Allow double click to fit row height |
| Behavior_DoubleClickToFitColumnWidth | Allow double click to fit column width |
| Behavior_MouseWheelToScroll | Allow scroll worksheet by wheeling mouse |
| Behavior_MouseWheelToZoom | Allow zoom worksheet by wheeling mouse |
| Behavior_ShortcutKeyToZoom | Allow zoom worksheet by shortcut-keys (Ctrl + plus/minus) |
| Behavior_DragToMoveCells | Allow move or copy selected range by dragging mouse |
| Behavior_DragToMoveColumnHeader | Allow user to move entire column by dragging mouse (Reserved) |
| Behavior_ScrollToFocusCell | Allow always by scrolling worksheet to keep focused cell visibile |
| Behavior_AllowUserChangingPageBreaks | Allow user to insert, remove or adjust the page-breaks by mouse |
Editing
| Setting | Desc |
|---|---|
| Edit_Readonly | Indicates that worksheet works in read-only mode. Any changes will not be allowed |
| Edit_AutoFormatCell | Allow format data after text edited or inputed by end-user |
| Edit_FriendlyPercentInput | Allow to display a percent symbol when user inputting data inside percent-format cell |
| Edit_AutoAdjustRowHeight | Allow adjusting the height of row when user enlarges font of cell |
| Edit_AllowAdjustRowHeight | Allows user to adjust height of row by dragging mouse |
| Edit_AllowAdjustColumnWidth | Allows user to adjust the width of column by dragging mouse |
| Edit_DragSelectionToMoveCells | Allows user drags and drops the selection to move cell content |
| Edit_DragSelectionToFillSerial | Allows user to fill ranges by dragging mouse |
Appearance
| Setting | Desc |
|---|---|
| View_ShowColumnHeader | Show column headers |
| View_ShowRowHeader | Show row headers |
| View_ShowHorizontalRuler | Show ruler in horizontal direction (Reserved) |
| View_ShowVerticalRuler | Show ruler in vertical direction (Reserved) |
| View_ShowGuideLine | Show guide lines |
| View_ShowHiddenCellLine | Allow to show a single line on hidden rows header |
| View_AllowShowRowOutlines | Allow to show row outlines if outlines exiting |
| View_AllowShowColumnOutlines | Allow to show column outlines if outlines exiting |
| View_ShowPageBreaks | Allow to show page-break lines |
| View_AllowCellTextOverflow | Make cell's text only displayed inside cell, don't overlay over neighbor cells |
| View_ShowPrintAreasEnable | Showing boundary of printing areas |
Formula Calculation
| Setting | Desc |
|---|---|
| Formula_AutoUpdateReferenceCell | Allow to update formula reference cells automatically |
| Formula_AutoPickingAddress | Allow to select and pick an address from worksheet during formula edit |
| Formula_AutoFormat | Allow to correct, format and rebuild formula automatically |