Class

RadSpreadsheet

Initializes a new instance of the RadSpreadsheet class.

Declaration

public RadSpreadsheet()

Active sheet editor dependency property.

Declaration

public static readonly DependencyProperty ActiveSheetEditorProperty

Field Value

Color palette dependency property.

Declaration

public static readonly DependencyProperty ColorPaletteProperty

Field Value

Command descriptors dependency property.

Declaration

public static readonly DependencyProperty CommandDescriptorsProperty

Field Value

Fill handle selection stroke dependency property.

Declaration

public static readonly DependencyProperty FillHandleSelectionStrokeProperty

Field Value

Selection fill dependency property.

Declaration

public static readonly DependencyProperty SelectionFillProperty

Field Value

Selection stroke dependency property.

Declaration

public static readonly DependencyProperty SelectionStrokeProperty

Field Value

Selection stroke thickness dependency property.

Declaration

public static readonly DependencyProperty SelectionStrokeThicknessProperty

Field Value

Workbook dependency property.

Declaration

public static readonly DependencyProperty WorkbookProperty

Field Value

Worksheet editor context menu dependency property.

Declaration

public static readonly DependencyProperty WorksheetEditorContextMenuProperty

Field Value

Gets or sets the active sheet.

Declaration

public Sheet ActiveSheet { get; set; }

Property Value

Gets the active sheet editor.

Declaration

public IRadSheetEditor ActiveSheetEditor { get; }

Property Value

Gets or sets the active worksheet.

Declaration

public Worksheet ActiveWorksheet { get; set; }

Property Value

Gets or sets the active worksheet editor.

Declaration

public RadWorksheetEditor ActiveWorksheetEditor { get; set; }

Property Value

Gets or sets the color palette.

Declaration

public SpreadsheetColorPalette ColorPalette { get; set; }

Property Value

Gets the command descriptors.

Declaration

public CommandDescriptors CommandDescriptors { get; }

Property Value

Implements ICommandDescriptorsProvider.CommandDescriptors

Gets or sets a value indicating whether automation peers for the visible cells should be created by the owned RadSpreadsheetAutomationPeer.

Declaration

[Browsable(false)]
public bool CreateVisualCellsAutomationPeers { get; set; }

Property Value

Remarks

Gets or sets the fill handle selection stroke.

Declaration

public Brush FillHandleSelectionStroke { get; set; }

Property Value

Gets the fonts provider.

Declaration

public FontsProvider FontsProvider { get; }

Property Value

Gets a collection of the available format providers.

Declaration

public WorkbookFormatProvidersCollection FormatProviders { get; }

Property Value

Gets the horizontal scroll bar.

Declaration

public ScrollBar HorizontalScrollBar { get; }

Property Value

Implements IScrollBarsProvider.HorizontalScrollBar

Gets or sets the selection fill.

Declaration

public Brush SelectionFill { get; set; }

Property Value

Gets or sets the selection stroke.

Declaration

public Brush SelectionStroke { get; set; }

Property Value

Gets or sets the selection stroke thickness.

Declaration

public double SelectionStrokeThickness { get; set; }

Property Value

Gets or sets the RadSpreadsheetSheetSelector context menu.

Declaration

public RadContextMenu SheetSelectorContextMenu { get; set; }

Property Value

Gets or sets the theme.

Declaration

public DocumentTheme Theme { get; set; }

Property Value

Gets the themes manager.

Declaration

public RadSpreadsheetThemesManager ThemesManager { get; }

Property Value

Gets the vertical scroll bar.

Declaration

public ScrollBar VerticalScrollBar { get; }

Property Value

Implements IScrollBarsProvider.VerticalScrollBar

Gets or sets the visible size.

Declaration

public SizeI VisibleSize { get; set; }

Property Value

Gets or sets the workbook.

Declaration

public Workbook Workbook { get; set; }

Property Value

Gets or sets the worksheet editor context menu.

Declaration

public RadContextMenu WorksheetEditorContextMenu { get; set; }

Property Value

Gets or sets the worksheet UI layers builder.

Declaration

public WorksheetUILayersBuilder WorksheetUILayersBuilder { get; set; }

Property Value

Begins the undo group.

Declaration

public void BeginUndoGroup()

Cancels the undo group.

Declaration

public void CancelUndoGroup()

Ends the undo group.

Declaration

public void EndUndoGroup()

Invalidates the layout.

Declaration

public void InvalidateLayout()

Called when the active sheet is changed.

Declaration

protected virtual void OnActiveSheetChanged()

Called when the active sheet editor is changed.

Declaration

protected virtual void OnActiveSheetEditorChanged()

When overridden in a derived class, is invoked whenever application code or internal processes call .

Declaration

public override void OnApplyTemplate()

Returns class-specific AutomationPeer implementations for the Windows Presentation Foundation (WPF) infrastructure.

Declaration

protected override AutomationPeer OnCreateAutomationPeer()

Returns

Raises the  routed event by using the event data provided.

Declaration

protected override void OnGotFocus(RoutedEventArgs e)

Parameters

Raises the event. This method is invoked whenever is set to true internally.

Declaration

protected override void OnInitialized(EventArgs e)

Parameters

Raises the event.

Declaration

protected virtual void OnMessageShowing(MessageShowingEventArgs args)

Parameters

Called when the template is applying.

Declaration

protected virtual void OnTemplateApplying()

Called when the workbook is changed.

Declaration

protected virtual void OnWorkbookChanged()

Called when the workbook is changing.

Declaration

protected virtual void OnWorkbookChanging()

Raises the event.

Declaration

protected virtual void OnWorkbookCommandError(CommandErrorEventArgs args)

Parameters

Raises the event.

Declaration

protected virtual void OnWorkbookCommandExecuted(CommandExecutedEventArgs args)

Parameters

Raises the event.

Declaration

protected virtual void OnWorkbookCommandExecuting(CommandExecutingEventArgs args)

Parameters

Prints using the specified print what settings.

Declaration

public void Print(PrintWhatSettings printWhatSettings, PrintDialog printDialog, string printDescription = null)

Parameters

Prints using the specified print what settings.

Declaration

public void Print(PrintWhatSettings printWhatSettings, string printDescription = null)

Parameters

Receives events from the centralized event manager.

Declaration

public bool ReceiveWeakEvent(Type managerType, object sender, EventArgs e)

Parameters

Returns

Redoes this instance.

Declaration

public bool Redo()

Returns

Sets the horizontal offset.

Declaration

public void SetHorizontalOffset(double offset)

Parameters

Sets the vertical offset.

Declaration

public void SetVerticalOffset(double offset)

Parameters

Undoes this instance.

Declaration

public bool Undo()

Returns

Occurs when the active sheet is changed.

Declaration

public event EventHandler ActiveSheetChanged

Event Value

Occurs when the active sheet editor is changed.

Declaration

public event EventHandler ActiveSheetEditorChanged

Event Value

Occurs when the user is presented with a warning message.

Declaration

public event EventHandler<MessageShowingEventArgs> MessageShowing

Event Value

Occurs when the workbook is changed.

Declaration

public event EventHandler WorkbookChanged

Event Value

Occurs when the workbook is changing.

Declaration

public event EventHandler WorkbookChanging

Event Value

Occurs when workbook command error occurs.

Declaration

public event EventHandler<CommandErrorEventArgs> WorkbookCommandError

Event Value

Occurs when workbook command is executed.

Declaration

public event EventHandler<CommandExecutedEventArgs> WorkbookCommandExecuted

Event Value

Occurs when workbook command is executing.

Declaration

public event EventHandler<CommandExecutingEventArgs> WorkbookCommandExecuting

Event Value

Occurs when the workbook content is changed.

Declaration

public event EventHandler WorkbookContentChanged

Event Value