Class
RadSpreadsheetEditor

Definition

Namespace:Telerik.WebAii.Controls.Xaml.Wpf

Assembly:Telerik.WebAii.Controls.Xaml.Wpf.dll

Syntax:

cs-api-definition
public class RadSpreadsheetEditor : Control, IAutomationPeer, IPeerConverter, IRadSpreadsheetEditor, IControl, IFrameworkElement, ITargetElement

Inheritance: objectAutomationObject<FrameworkElement>FrameworkElementWpfTestElementControlRadSpreadsheetEditor

Implements: IAutomationPeerIControlIFrameworkElementIPeerConverterIRadSpreadsheetEditorITargetElement

Inherited Members Control.BorderBrushPropertyControl.BorderThicknessPropertyControl.BackgroundPropertyControl.ForegroundPropertyControl.FontSizePropertyControl.HorizontalContentAlignmentPropertyControl.VerticalContentAlignmentPropertyControl.TabIndexPropertyControl.IsTabStopPropertyControl.PaddingPropertyControl.FontFamilyPropertyControl.FontStretchPropertyControl.FontStylePropertyControl.FontWeightPropertyControl.GetRealType()Control.BorderBrushControl.BorderThicknessControl.BackgroundControl.ForegroundControl.FontSizeControl.HorizontalContentAlignmentControl.VerticalContentAlignmentControl.TabIndexControl.IsTabStopControl.PaddingControl.FontFamilyControl.FontStretchControl.FontStyleControl.FontWeightWpfTestElement.OverridesDefaultStylePropertyWpfTestElement.BindingGroupPropertyWpfTestElement.InputScopePropertyWpfTestElement.LayoutTransformPropertyWpfTestElement.FlowDirectionPropertyWpfTestElement.ForceCursorPropertyWpfTestElement.ContextMenuPropertyWpfTestElement.IsMouseDirectlyOverPropertyWpfTestElement.IsMouseOverPropertyWpfTestElement.IsStylusOverPropertyWpfTestElement.IsKeyboardFocusWithinPropertyWpfTestElement.IsMouseCapturedPropertyWpfTestElement.IsMouseCaptureWithinPropertyWpfTestElement.IsStylusDirectlyOverPropertyWpfTestElement.IsStylusCapturedPropertyWpfTestElement.IsStylusCaptureWithinPropertyWpfTestElement.IsKeyboardFocusedPropertyWpfTestElement.AllowDropPropertyWpfTestElement.ClipToBoundsPropertyWpfTestElement.SnapsToDevicePixelsPropertyWpfTestElement.IsFocusedPropertyWpfTestElement.IsEnabledPropertyWpfTestElement.IsVisiblePropertyWpfTestElement.FocusablePropertyWpfTestElement.OverridesDefaultStyleWpfTestElement.BindingGroupWpfTestElement.InputScopeWpfTestElement.FlowDirectionWpfTestElement.ForceCursorWpfTestElement.ContextMenuWpfTestElement.IsMouseDirectlyOverWpfTestElement.IsMouseOverWpfTestElement.IsStylusOverWpfTestElement.IsKeyboardFocusWithinWpfTestElement.IsMouseCapturedWpfTestElement.IsMouseCaptureWithinWpfTestElement.IsStylusDirectlyOverWpfTestElement.IsStylusCapturedWpfTestElement.IsStylusCaptureWithinWpfTestElement.IsKeyboardFocusedWpfTestElement.AllowDropWpfTestElement.ClipToBoundsWpfTestElement.SnapsToDevicePixelsWpfTestElement.IsFocusedWpfTestElement.IsEnabledWpfTestElement.IsVisibleWpfTestElement.FocusableWpfTestElement.ComputedVisibilityFrameworkElement.ActualWidthPropertyFrameworkElement.ActualHeightPropertyFrameworkElement.WidthPropertyFrameworkElement.HeightPropertyFrameworkElement.MinWidthPropertyFrameworkElement.MaxWidthPropertyFrameworkElement.MinHeightPropertyFrameworkElement.MaxHeightPropertyFrameworkElement.HorizontalAlignmentPropertyFrameworkElement.VerticalAlignmentPropertyFrameworkElement.MarginPropertyFrameworkElement.DesiredSizePropertyFrameworkElement.RenderSizePropertyFrameworkElement.NamePropertyFrameworkElement.TagPropertyFrameworkElement.DataContextPropertyFrameworkElement.OpacityPropertyFrameworkElement.ClipPropertyFrameworkElement.RenderTransformPropertyFrameworkElement.OpacityMaskPropertyFrameworkElement.RenderTransformOriginPropertyFrameworkElement.IsHitTestVisiblePropertyFrameworkElement.VisibilityPropertyFrameworkElement.GetIdentifier(out string, out string)FrameworkElement.IsChild(FrameworkElement)FrameworkElement.GetChildTagIndex(FrameworkElement)FrameworkElement.InitializeMappings(MappingsCollection)FrameworkElement.As<T>()FrameworkElement.CastAs<T>()FrameworkElement.SetProxy(bool)FrameworkElement.SetUid(string)FrameworkElement.SetFindInfo(VisualFindInfo)FrameworkElement.SetXamlTag(string)FrameworkElement.AssignReference(AutomationReference)FrameworkElement.KeyPress(Keys, int, int, int)FrameworkElement.GetRectangle()FrameworkElement.GetRectangle(FrameworkElement)FrameworkElement.GetIntRectangle()FrameworkElement.IsHitTest()FrameworkElement.IsHitTest(bool)FrameworkElement.IsHitTest(FrameworkElement, bool)FrameworkElement.Highlight()FrameworkElement.Highlight(bool)FrameworkElement.Parent()FrameworkElement.Parent<T>()FrameworkElement.Parent(string)FrameworkElement.Parent(string, bool)FrameworkElement.GetNextSibling()FrameworkElement.GetPrevSibling()FrameworkElement.NextSibling(string)FrameworkElement.NextSibling<T>()FrameworkElement.PreviousSibling(string)FrameworkElement.PreviousSibling<T>()FrameworkElement.AnySibling<T>()FrameworkElement.AnySibling(string)FrameworkElement.GetScreenRectangle()FrameworkElement.ScrollToVisible()FrameworkElement.ScrollToVisible(ScrollToVisibleType)FrameworkElement.EnsureClickable()FrameworkElement.ToXml()FrameworkElement.Refresh()FrameworkElement.Equals(object)FrameworkElement.GetHashCode()FrameworkElement.GetProperties()FrameworkElement.GetAttachedProperty<T>(string, string)FrameworkElement.SetAttachedProperty<T>(string, string, T)FrameworkElement.SetFocus()FrameworkElement.ValidateMouseLocationIfNeeded(Point)FrameworkElement.GetStringPresentation()FrameworkElement.ToRealObject()FrameworkElement.FromRealObject(object)FrameworkElement.ValidateType(Type, string)FrameworkElement.GetKnownControlTypes(TechnologyType)FrameworkElement.RegisterElement(Type, string)FrameworkElement.InitKnownWpfControlTypes()FrameworkElement.InitKnownSilverlightControlTypes()FrameworkElement.InitKnownXamlControlTypes(Type)FrameworkElement.GetControlTypeFromInterface(Type)FrameworkElement.Match(IFindExpression)FrameworkElement.SetDepth(int)FrameworkElement.AddChildNode(ITargetElement)FrameworkElement.SetClosingTag(ITargetElement)FrameworkElement.GetChildren()FrameworkElement.GetParent()FrameworkElement.GetHostParent()FrameworkElement.SetParent(ITargetElement)FrameworkElement.GetUniqueHashCode()FrameworkElement.ToString()FrameworkElement.Capture()FrameworkElement.CaptureImage()FrameworkElement.GetProperty<T>(string)FrameworkElement.GetPropertyTypeSafe(string)FrameworkElement.GetAutomationProperty(string)FrameworkElement.SetProperty(string, object)FrameworkElement.ActualWidthFrameworkElement.ActualHeightFrameworkElement.WidthFrameworkElement.HeightFrameworkElement.MinWidthFrameworkElement.MaxWidthFrameworkElement.MinHeightFrameworkElement.MaxHeightFrameworkElement.HorizontalAlignmentFrameworkElement.VerticalAlignmentFrameworkElement.MarginFrameworkElement.DesiredSizeFrameworkElement.RenderSizeFrameworkElement.NameFrameworkElement.OpacityFrameworkElement.ClipFrameworkElement.RenderTransformFrameworkElement.OpacityMaskFrameworkElement.RenderTransformOriginFrameworkElement.IsHitTestVisibleFrameworkElement.VisibilityFrameworkElement.UidFrameworkElement.MappingsFrameworkElement.AutomationIdFrameworkElement.XamlTagBaseFrameworkElement.TextFrameworkElement.TextBlockContentFrameworkElement.TextLiteralContentFrameworkElement.UserFrameworkElement.XamlTagFrameworkElement.WaitFrameworkElement.FindFrameworkElement.ApplicationFrameworkElement.AbsoluteTagIndexFrameworkElement.TagNameIndexFrameworkElement.AbsoluteSiblingTagIndexFrameworkElement.EnableValidateMouseLocationFrameworkElement.ToolTipTextFrameworkElement.ChildrenFrameworkElement.TechnologyTypeFrameworkElement.DepthFrameworkElement.IsTestRegionFrameworkElement.ParsedElementFrameworkElement.HostAutomationObject<FrameworkElement>.GetProperty(AutomationProperty)AutomationObject<FrameworkElement>.GetProperty(AutomationProperty, object)AutomationObject<FrameworkElement>.SetProperty(AutomationProperty, object)AutomationObject<FrameworkElement>.InvokeMethod(AutomationMethod, params object[])AutomationObject<FrameworkElement>.InvokeMethod(string, params object[])AutomationObject<FrameworkElement>.Serialize()AutomationObject<FrameworkElement>.Deserialize(string)AutomationObject<FrameworkElement>.ReferenceAutomationObject<FrameworkElement>.PropertyBag

Constructors

RadSpreadsheetEditor()

Declaration

cs-api-definition
public RadSpreadsheetEditor()

Properties

CellBordersLayer

Declaration

cs-api-definition
public FrameworkElement CellBordersLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.CellBordersLayer

CellEditor

Declaration

cs-api-definition
public ITextBox CellEditor { get; }

Property Value

ITextBox

Implements IRadSpreadsheetEditor.CellEditor

CellFillLayer

Declaration

cs-api-definition
public FrameworkElement CellFillLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.CellFillLayer

CellInputLayer

Declaration

cs-api-definition
public FrameworkElement CellInputLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.CellInputLayer

CellValuesLayer

Declaration

cs-api-definition
public FrameworkElement CellValuesLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.CellValuesLayer

ColumnHeadingMarginLayer

Declaration

cs-api-definition
public FrameworkElement ColumnHeadingMarginLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.ColumnHeadingMarginLayer

GridLinesLayer

Declaration

cs-api-definition
public FrameworkElement GridLinesLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.GridLinesLayer

LeftMarginsPanel

Declaration

cs-api-definition
public FrameworkElement LeftMarginsPanel { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.LeftMarginsPanel

NormalWorksheetEditorPresenter

Declaration

cs-api-definition
public FrameworkElement NormalWorksheetEditorPresenter { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.NormalWorksheetEditorPresenter

ResizeDecorationLayer

Declaration

cs-api-definition
public FrameworkElement ResizeDecorationLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.ResizeDecorationLayer

RowHeadingMarginLayer

Declaration

cs-api-definition
public FrameworkElement RowHeadingMarginLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.RowHeadingMarginLayer

SelectionLayer

Declaration

cs-api-definition
public FrameworkElement SelectionLayer { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.SelectionLayer

SpreadsheetCanvas

Declaration

cs-api-definition
public FrameworkElement SpreadsheetCanvas { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.SpreadsheetCanvas

TopMarginsPanel

Declaration

cs-api-definition
public FrameworkElement TopMarginsPanel { get; }

Property Value

FrameworkElement

Implements IRadSpreadsheetEditor.TopMarginsPanel

Methods

AddCellToSelection(int, int)

  1. KeyDown Shift
  2. Click the center of the visual cell
  3. KeyUp Shift

Declaration

cs-api-definition
public bool AddCellToSelection(int row, int column)

Parameters

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.AddCellToSelection(int, int)

AddRegionToSelection(int, int, int, int)

  1. KeyDown Shift
  2. Drag from the center of the top-left visual cell to the center fo the bottom-right visual cell
  3. KeyUp Shift

Declaration

cs-api-definition
public bool AddRegionToSelection(int fromCellRow, int fromCellColumn, int toCellRow, int toCellColumn)

Parameters

fromCellRow

int

fromCellColumn

int

toCellRow

int

toCellColumn

int

Returns

bool

Implements IRadSpreadsheetEditor.AddRegionToSelection(int, int, int, int)

ClearValueInCell(int, int)

  1. Click the center of the visual cell
  2. Press Delete Key

Declaration

cs-api-definition
public bool ClearValueInCell(int row, int column)

Parameters

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.ClearValueInCell(int, int)

Copy()

  1. Press Control | C

Declaration

cs-api-definition
public void Copy()

Implements IRadSpreadsheetEditor.Copy()

Cut()

  1. Press Control | X

Declaration

cs-api-definition
public void Cut()

Implements IRadSpreadsheetEditor.Cut()

EnterValueInCell(string, int, int)

  1. Click the center of the visual cell
  2. Press F2 to enter edit mode
  3. TypeText in the opened CellEditor
  4. Press Enter

Declaration

cs-api-definition
public bool EnterValueInCell(string text, int row, int column)

Parameters

text

string

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.EnterValueInCell(string, int, int)

GetVisualCell(int, int)

Declaration

cs-api-definition
public IVisualCell GetVisualCell(int row, int column)

Parameters

row

int

column

int

Returns

IVisualCell

Implements IRadSpreadsheetEditor.GetVisualCell(int, int)

Paste()

  1. Press Control | V

Declaration

cs-api-definition
public void Paste()

Implements IRadSpreadsheetEditor.Paste()

PressEnter()

  1. Press Return

Declaration

cs-api-definition
public void PressEnter()

Implements IRadSpreadsheetEditor.PressEnter()

PressShiftAndEnter()

  1. Press Return

Declaration

cs-api-definition
public void PressShiftAndEnter()

Implements IRadSpreadsheetEditor.PressShiftAndEnter()

PressShiftAndTab()

  1. Press Shift | Tab

Declaration

cs-api-definition
public void PressShiftAndTab()

Implements IRadSpreadsheetEditor.PressShiftAndTab()

PressTab()

  1. Press Tab

Declaration

cs-api-definition
public void PressTab()

Implements IRadSpreadsheetEditor.PressTab()

PutCellInEditMode(int, int)

  1. Click the center of the visual cell
  2. Press F2 to enter edit mode

Declaration

cs-api-definition
public bool PutCellInEditMode(int row, int column)

Parameters

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.PutCellInEditMode(int, int)

SelectCell(int, int)

  1. Click the center of the visual cell

Declaration

cs-api-definition
public bool SelectCell(int row, int column)

Parameters

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.SelectCell(int, int)

SelectRegion(int, int, int, int)

  1. Drag from the center of the top-left visual cell to the center fo the bottom-right visual cell

Declaration

cs-api-definition
public bool SelectRegion(int fromCellRow, int fromCellColumn, int toCellRow, int toCellColumn)

Parameters

fromCellRow

int

fromCellColumn

int

toCellRow

int

toCellColumn

int

Returns

bool

Implements IRadSpreadsheetEditor.SelectRegion(int, int, int, int)

TypeValueInCell(string, int, int)

  1. Click the center of the visual cell
  2. Press F2 to enter edit mode
  3. TypeText in the opened CellEditor

Declaration

cs-api-definition
public bool TypeValueInCell(string text, int row, int column)

Parameters

text

string

row

int

column

int

Returns

bool

Implements IRadSpreadsheetEditor.TypeValueInCell(string, int, int)