RadSpreadsheet
Represents a comprehensive spreadsheet control that provides Excel-like functionality for viewing, editing, and manipulating workbook data with support for multiple worksheets, formulas, formatting, and data operations. This control serves as the main container for spreadsheet functionality and can be seamlessly integrated with a RadSpreadsheetRibbonBar to provide a complete ribbon-based user interface with comprehensive editing commands, formatting options, and spreadsheet operations.
Definition
Namespace:Telerik.WinControls.UI
Assembly:Telerik.WinControls.RadSpreadsheet.dll
Syntax:
[TelerikToolboxCategory("Spreadsheet")]
[Docking(DockingBehavior.Ask)]
public class RadSpreadsheet : RadControl, IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable, INotifyPropertyChanged, ISupportInitializeNotification, ISupportInitialize, IComponentTreeHandler, ILayoutHandler, IAnalyticsProvider, IPrintableInheritance: objectMarshalByRefObjectComponentControlScrollableControlRadControlRadSpreadsheet...
Implements:
Inherited Members
Constructors
public RadSpreadsheet()Fields
public static readonly string DEFAULT_NAMESPACEProperties
Gets or sets the currently active sheet in the spreadsheet workbook.
public Sheet ActiveSheet { get; set; }Gets or sets the currently active worksheet in the spreadsheet, which is the worksheet that is currently displayed and available for editing.
public Worksheet ActiveWorksheet { get; set; }Gets or sets the editor for the currently active worksheet, providing access to editing operations on the worksheet content.
public RadWorksheetEditor ActiveWorksheetEditor { get; set; }Gets the default size of the spreadsheet control.
protected override Size DefaultSize { get; }A Size value representing the default dimensions of the control.
Overrides:
Gets the dispatcher for this spreadsheet control, which allows scheduling of operations that need to be executed on the UI thread.
public Dispatcher Dispatcher { get; }Gets or sets an instance of SpreadsheetInputBehavior that handles all user input including keyboard navigation, selection, and cell editing operations.
[Browsable(false)]
public SpreadsheetInputBehavior InputHandler { get; set; }Gets the RadSpreadsheetElement of this control, which contains the core UI components and functionality of the spreadsheet.
public RadSpreadsheetElement SpreadsheetElement { get; }Methods
Begins an undo group that allows multiple operations to be undone as a single action. Use in conjunction with EndUndoGroup() to group related operations.
public void BeginUndoGroup()Cancels the currently active undo group, discarding all operations that would have been grouped since the last call to BeginUndoGroup().
public void CancelUndoGroup()Creates the input behavior component for the RadSpreadsheet control.
protected override ComponentInputBehavior CreateBehavior()A new instance of RadSpreadsheetComponentInputBehavior configured for this spreadsheet.
Overrides:
protected override void CreateChildItems(RadElement parent)Overrides:
protected virtual RadSpreadsheetElement CreateSpreadsheetElement()Ends the currently active undo group, finalizing the grouping of operations since the last call to BeginUndoGroup().
public void EndUndoGroup()Determines whether the specified key is an input key that the spreadsheet should process, rather than a key that the form should process.
Raises the KeyDown event and processes keyboard input for the spreadsheet control.
protected override void OnKeyDown(KeyEventArgs e)A KeyEventArgs that contains the event data.
Overrides:
Raises the KeyPress event and processes character input for the spreadsheet control.
protected override void OnKeyPress(KeyPressEventArgs e)A KeyPressEventArgs that contains the event data.
Overrides:
Raises the KeyUp event and processes the key release event for the spreadsheet control.
protected override void OnKeyUp(KeyEventArgs e)A KeyEventArgs that contains the event data.
Overrides:
Raises the MouseWheel event and processes mouse wheel scrolling for the spreadsheet control.
protected override void OnMouseWheel(MouseEventArgs e)A MouseEventArgs that contains the event data.
Overrides:
Raises the ThemeChanged event and updates visual elements to reflect the new theme.
protected override void OnThemeChanged()Overrides:
Prints the spreadsheet content using the specified print settings and optional description.
public void Print(PrintWhatSettings printSettings, string printDescription = null, bool showDialog = true)The settings that determine what content should be printed, such as specific worksheets or selection.
printDescriptionstringOptional description text that appears in the print preview and printed output.
showDialogboolWhen true, displays the print dialog before printing; when false, prints directly with current settings.
Shows a print preview dialog that allows the user to view how the spreadsheet will look when printed and make adjustments to print settings before printing.
public void PrintPreview()Processes a dialog character, which is a character that is processed by the active form's dialog box. Overridden to handle character input with modifier keys for the spreadsheet.
Processes a dialog key, which is a key that is processed by the active form's dialog box. Overridden to handle Enter key specially for the spreadsheet.
Processes a mnemonic character, which is a character used to select menu items or controls by keyboard. Overridden to customize mnemonic handling for the spreadsheet.
Redoes the most recently undone operation or group of operations in the spreadsheet.
Events
Occurs before a file is opened, before the open file dialog is shown.
public event EventHandler<OpenFileDialogEventArgs> BeforeOpenFileSubscribe to this event to customize the OpenFileDialog properties (like Filter, InitialDirectory, etc.) before it is displayed to the user. Handlers can also cancel the open file operation by setting the Cancel property of the event arguments to true.
Occurs before the file is saved, before the save file dialog is shown.
public event EventHandler<SaveFileDialogEventArgs> BeforeSaveFileSubscribe to this event to customize the SaveFileDialog properties (like Filter, InitialDirectory, etc.) before it is displayed to the user. Handlers can also cancel the open file operation by setting the Cancel property of the event arguments to true.