New to Telerik UI for WPFStart a free 30-day trial

Represents the RadWorksheetEditor.

Definition

Namespace:Telerik.Windows.Controls.Spreadsheet.Worksheets

Assembly:Telerik.Windows.Controls.Spreadsheet.dll

Syntax:

C#
public class RadWorksheetEditor : RadSheetEditorBase<Worksheet>, IRadSheetEditor, ICommandDescriptorsProvider, ISheetEditor, IUILayerOwner, IDisposable, IWeakEventListener

Inheritance: objectControlBaseRadSheetEditorBaseRadSheetEditorBase<Worksheet>RadWorksheetEditor

Implements: ICommandDescriptorsProviderIDisposableIRadSheetEditorISheetEditorIUILayerOwnerIWeakEventListener...

Inherited Members RadSheetEditorBase<Worksheet>.IsSheetValid(Sheet)RadSheetEditorBase<Worksheet>.SheetRadSheetEditorBase.ScaleFactorPropertyRadSheetEditorBase.AllowScalingPropertyRadSheetEditorBase.DoOnSheetChanging()RadSheetEditorBase.DoOnSheetChanged()RadSheetEditorBase.GetSheetValue()RadSheetEditorBase.SetSheetValue(Sheet)RadSheetEditorBase.OnOwnerTemplateApplying()RadSheetEditorBase.OnScrollBarProviderChanging()RadSheetEditorBase.OnKeyDown(KeyEventArgs)RadSheetEditorBase.OnCommandDescriptorsChanged()RadSheetEditorBase.OnPreviewSheetChanging()RadSheetEditorBase.OnPreviewSheetChanged()RadSheetEditorBase.OnUICommandExecuting(UICommandExecutingEventArgs)RadSheetEditorBase.OnUICommandExecuted(UICommandExecutedEventArgs)RadSheetEditorBase.OnUICommandError(UICommandErrorEventArgs)RadSheetEditorBase.OwnerRadSheetEditorBase.ScrollBarsProviderRadSheetEditorBase.KeyBindingsRadSheetEditorBase.CommandDescriptorsRadSheetEditorBase.ScaleFactorRadSheetEditorBase.AllowScalingRadSheetEditorBase.CommandDescriptorsChangedRadSheetEditorBase.PreviewSheetChangingRadSheetEditorBase.SheetChangingRadSheetEditorBase.PreviewSheetChangedRadSheetEditorBase.SheetChangedRadSheetEditorBase.ScaleFactorChangedRadSheetEditorBase.UICommandExecutingRadSheetEditorBase.UICommandExecutedRadSheetEditorBase.UICommandErrorControlBase.GetTemplateChild<T>(string)ControlBase.GetRequiredTemplateChild<T>(string, bool)...

Constructors

Initializes a new instance of the RadWorksheetEditor class.

C#
public RadWorksheetEditor()

Initializes a new instance of the RadWorksheetEditor class.

C#
public RadWorksheetEditor(SizeI visibleSize)
Parameters:visibleSizeSizeI

Size of the visible.

Fields

Left margins panel name.

C#
public static readonly string LeftMarginsPanelName

Top margins panel name.

C#
public static readonly string TopMarginsPanelName

Properties

Gets the active presenter.

C#
public IRadWorksheetEditorPresenter ActivePresenter { get; }
Property Value:

The active presenter.

Gets the commands.

C#
public RadWorksheetEditorCommands Commands { get; }
Property Value:

The commands.

Gets the dialogs.

C#
public WorksheetEditorDialogs Dialogs { get; }
Property Value:

The dialogs.

Gets the index of the cell below the top frozen pane and to the right of the left frozen pane.

C#
public CellIndex FrozenCellIndex { get; }
Property Value:

The index of the frozen cell.

Gets or sets the horizontal scroll mode.

C#
public ScrollMode HorizontalScrollMode { get; set; }
Property Value:

The horizontal scroll mode.

Gets the value indicating if the horizontal viewport update is suspended.

C#
public bool IsHorizontalViewportUpdateSuspended { get; }
Property Value:

The value indicating if the horizontal viewport update is suspended.

Gets the value indicating if the vertical viewport update is suspended.

C#
public bool IsVerticalViewportUpdateSuspended { get; }
Property Value:

The value indicating if the vertical viewport update is suspended.

Allows you to get or set the command descriptors. Used when overriding the default command descriptors with custom ones.

C#
public CommandDescriptors RadWorksheetCommandDescriptors { get; set; }

Gets the selection.

C#
public Selection Selection { get; }
Property Value:

The selection.

SheetViewport

SheetViewport

Gets the sheet viewport.

C#
public override SheetViewport SheetViewport { get; }
Property Value:

The sheet viewport.

Overrides: RadSheetEditorBase.SheetViewport

Gets or sets a value indicating whether to show gridlines.

C#
public bool ShowGridlines { get; set; }
Property Value:

The value indicating whether to show gridlines.

Gets or sets a value indicating whether to show row and column headings.

C#
public bool ShowRowColumnHeadings { get; set; }
Property Value:

The value indicating whether to show row and column headings.

Gets the index of the top left cell.

C#
public CellIndex TopLeftCellIndex { get; }
Property Value:

The index of the top left cell.

Gets or sets the vertical scroll mode.

C#
public ScrollMode VerticalScrollMode { get; set; }
Property Value:

The vertical scroll mode.

Gets the size of the visible.

C#
public SizeI VisibleSize { get; }
Property Value:

The size of the visible.

Worksheet

Worksheet

Gets or sets the worksheet.

C#
public Worksheet Worksheet { get; set; }
Property Value:

The worksheet.

Methods

Brings the into view.

C#
public void BringIntoView(CellIndex cellIndex)
Parameters:cellIndexCellIndex

Index of the cell.

Circles the invalid data.

C#
public void CircleInvalidData()

Clears the selected cells.

C#
public void Clear(ClearType clearType)
Parameters:clearTypeClearType

Type of the clear.

Clears the invalid data circles.

C#
public void ClearInvalidDataCircles()

Copies the selected cell values and formatting.

C#
public bool Copy()
Returns:

bool

True if succeed.

Creates the state of the history.

C#
public RadWorksheetEditorHistoryState CreateHistoryState()
Returns:

RadWorksheetEditorHistoryState

The state of the history.

Cuts the selected cell values and formatting.

C#
public void Cut()

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

C#
public void Dispose()

Implements: IDisposable.Dispose()

Disposes the specified clean up managed resources.

C#
protected virtual void Dispose(bool cleanUpManagedResources)
Parameters:cleanUpManagedResourcesbool

The clean up managed resources.

Freezes the panes.

C#
public void FreezePanes(CellIndex cellIndex)
Parameters:cellIndexCellIndex

Index of the cell.

Gets the cell layout box.

C#
public CellLayoutBox GetCellLayoutBox(CellIndex cellIndex)
Parameters:cellIndexCellIndex

Index of the cell.

Returns:

CellLayoutBox

The cell layout box.

Gets the cell layout box.

C#
public CellLayoutBox GetCellLayoutBox(int rowIndex, int columnIndex)
Parameters:rowIndexint

Index of the row.

columnIndexint

Index of the column.

Returns:

CellLayoutBox

The cell layout box.

Invalidates the presenter layout.

C#
public void InvalidatePresenterLayout()

When overridden in a derived class, measures the size in layout required for child elements and determines a size for the FrameworkElement-derived class.

C#
protected override Size MeasureOverride(Size availableSize)
Parameters:availableSizeSize

The available size that this element can give to child elements. Infinity can be specified as a value to indicate that the element will size to whatever content is available.

Returns:

Size

The size that this element determines it needs during layout, based on its calculations of child element sizes.

Called when the active presenter is changed.

C#
protected virtual void OnActivePresenterChanged()

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

C#
public override void OnApplyTemplate()

Raises the  routed event by using the event data provided.

C#
protected override void OnGotFocus(RoutedEventArgs e)
Parameters:eRoutedEventArgs

A RoutedEventArgs that contains event data. This event data must contain the identifier for the event.

Called when a hyperlink in the document is clicked.

C#
protected virtual void OnHyperlinkClicked(HyperlinkClickedEventArgs args)
Parameters:argsHyperlinkClickedEventArgs

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

C#
protected override void OnInitialized(EventArgs e)
Parameters:eEventArgs

The RoutedEventArgs that contains the event data.

Called when the owner is changed.

C#
protected override void OnOwnerChanged()

Overrides: RadSheetEditorBase.OnOwnerChanged()

Raises the event.

C#
protected override void OnOwnerChanging()

Overrides: RadSheetEditorBase.OnOwnerChanging()

Invoked when an unhandled  attached event reaches an element in its route that is derived from this class. Implement this method to add class handling for this event.

C#
protected override void OnPreviewKeyDown(KeyEventArgs e)
Parameters:eKeyEventArgs

The KeyEventArgs that contains the event data.

Raises the event.

C#
protected override void OnScaleFactorChanged()

Overrides: RadSheetEditorBase.OnScaleFactorChanged()

Called when the scroll bar provider is changed.

C#
protected override void OnScrollBarProviderChanged()

Overrides: RadSheetEditorBase.OnScrollBarProviderChanged()

Called when the scroll mode is changed.

C#
protected virtual void OnScrollModeChanged()

Raises the event.

C#
protected override void OnSheetChanged()

Overrides: RadSheetEditorBase.OnSheetChanged()

Raises the event.

C#
protected override void OnSheetChanging()

Overrides: RadSheetEditorBase.OnSheetChanging()

Opens the hyperlink.

C#
public void OpenHyperlink(HyperlinkInfo hyperlink, CellIndex cellIndex = null)
Parameters:hyperlinkHyperlinkInfo

The hyperlink.

cellIndexCellIndex

Index of the cell.

Pastes in the selected cells the cell values and formatting.

C#
public bool Paste()
Returns:

bool

True if succeed.

Pastes in the selected cells respecting the specified paste options.

C#
public bool Paste(PasteOptions pasteOptions)
Parameters:pasteOptionsPasteOptions

The paste options.

Returns:

bool

True if succeed.

Preserves the view state of the sheet.

C#
protected override void PreserveSheetViewState(ISheetViewState viewState)
Parameters:viewStateISheetViewState

View state of the sheet.

Overrides: RadSheetEditorBase.PreserveSheetViewState(ISheetViewState)

Receives events from the centralized event manager.

C#
public bool ReceiveWeakEvent(Type managerType, object sender, EventArgs e)
Parameters:managerTypeType

The type of the calling this method.

senderobject

Object that originated the event.

eEventArgs

Event data.

Returns:

bool

true if the listener handled the event. It is considered an error by the handling in WPF to register a listener for an event that the listener does not handle. Regardless, the method should return false if it receives an event that it does not recognize or handle.

Restores the state of the history.

C#
public void RestoreHistoryState(RadWorksheetEditorHistoryState historyState)
Parameters:historyStateRadWorksheetEditorHistoryState

State of the history.

Restores the view state of the sheet.

C#
protected override void RestoreSheetViewState(ISheetViewState viewState)
Parameters:viewStateISheetViewState

View state of the sheet.

Overrides: RadSheetEditorBase.RestoreSheetViewState(ISheetViewState)

Resumes the viewport update.

C#
public void ResumeViewportUpdate()

Sets the horizontal offset.

C#
public override void SetHorizontalOffset(double offset)
Parameters:offsetdouble

The offset.

Overrides: RadSheetEditorBase.SetHorizontalOffset(double)

Sets the vertical offset.

C#
public override void SetVerticalOffset(double offset)
Parameters:offsetdouble

The offset.

Overrides: RadSheetEditorBase.SetVerticalOffset(double)

Suspends the viewport update.

C#
public void SuspendViewportUpdate()

Unfreezes the panes.

C#
public void UnfreezePanes()

Updates the view port so the top left cell index is the desired one.

C#
public void UpdateToViewWithTopLeftCellIndex(CellIndex cellIndex)
Parameters:cellIndexCellIndex

The desired index of the top left visible cell.

Events

Occurs when the active presenter is changed.

C#
public event EventHandler ActivePresenterChanged

Occurs when a hyperlink in the document is clicked.

C#
public event EventHandler<HyperlinkClickedEventArgs> HyperlinkClicked

Occurs when the scroll mode is changed.

C#
public event EventHandler ScrollModeChanged