V4 V5

ReoGrid provides settings for the workbook (WorkbookSettings) and for each individual worksheet (WorksheetSettings). Using these settings, you can change many default behaviors for the workbook and worksheets.

Workbook Settings

Workbook settings can be changed by calling the SetSettings, EnableSettings, or DisableSettings methods on the workbook instance:

// Set settings
reoGridControl.SetSettings(WorkbookSettings settings, bool enabled);
reoGridControl.EnableSettings(WorkbookSettings settings);
reoGridControl.DisableSettings(WorkbookSettings settings);

// Get settings
bool value = reoGridControl.HasSettings(WorkbookSettings settings);

Appearance

SettingDescription
View_ShowSheetTabControlAllow showing the sheet tab control
View_ShowScrollsAllow showing all scroll bars
View_ShowHorScrollAllow showing the horizontal scroll bar
View_ShowVerScrollAllow showing the vertical scroll bar

Worksheet Settings

Worksheet settings can be changed by calling the SetSettings, EnableSettings, or DisableSettings methods on the worksheet instance:

var worksheet = reoGridControl.CurrentWorksheet;

// Set settings
worksheet.SetSettings(WorksheetSettings settings, bool enabled);
worksheet.EnableSettings(WorksheetSettings settings);
worksheet.DisableSettings(WorksheetSettings settings);

// Get settings
bool value = worksheet.HasSettings(WorksheetSettings settings);

Worksheet settings include the following items:

Behavior

SettingDesc
Behavior_DoubleClickToFitRowHeightAllow double-clicking to fit row height
Behavior_DoubleClickToFitColumnWidthAllow double-clicking to fit column width
Behavior_MouseWheelToScrollAllow scrolling the worksheet with the mouse wheel
Behavior_MouseWheelToZoomAllow zooming the worksheet with the mouse wheel
Behavior_ShortcutKeyToZoomAllow zooming the worksheet with shortcut keys (Ctrl + plus/minus)
Behavior_ScrollToFocusCellAlways scroll the worksheet to keep the focused cell visible
Behavior_AllowUserChangingPageBreaksAllow the user to insert, remove, or adjust page breaks with the mouse

Editing

SettingDesc
Edit_ReadonlyIndicates that the worksheet is in read-only mode. No changes will be permitted
Edit_AutoFormatCellAllow formatting data after text is edited or entered by the end-user
Edit_FriendlyPercentInputDisplay a percent symbol when the user enters data in a percent-formatted cell
Edit_AutoExpandRowHeightAllow automatic row height adjustment when the user increases a cell’s font size
Edit_AllowAdjustRowHeightAllow the user to adjust row height by dragging the mouse
Edit_AllowAdjustColumnWidthAllow the user to adjust column width by dragging the mouse
Edit_DragSelectionToMoveCellsAllow the user to drag and drop the selection to move cell content
Edit_DragSelectionToFillSerialAllow the user to fill ranges by dragging the mouse

Appearance

SettingDesc
View_ShowColumnHeaderShow column headers
View_ShowRowHeaderShow row headers
View_ShowHorizontalRulerShow ruler in the horizontal direction (Reserved)
View_ShowVerticalRulerShow ruler in the vertical direction (Reserved)
View_ShowGridLineShow guide lines
View_ShowHiddenCellLineShow a single line on the header of hidden rows
View_AllowShowRowOutlinesShow row outlines if outlines exist
View_AllowShowColumnOutlinesShow column outlines if outlines exist
View_ShowPageBreaksShow page-break lines
View_AllowCellTextOverflowAllow cell text to overflow into neighboring empty cells

Formula Calculation

SettingDesc
Formula_AutoUpdateReferenceCellAllow automatic updating of formula reference cells
Formula_AutoPickingCellAddressReserved
Formula_AutoFormatAllow automatic correction, formatting, and rebuilding of formulas
Was this article helpful?