FormulaTextBox Class

[ToolboxBitmap(typeof(FpSpread), "FormulaTextBoxV7.png")]
public class FormulaTextBox : RichTextBoxEx, IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable

<ToolboxBitmap(GetType(FpSpread), "FormulaTextBoxV7.png")>
Public Class FormulaTextBox
    Inherits RichTextBoxEx
    Implements IDropTarget, ISynchronizeInvoke, IWin32Window, IBindableComponent, IComponent, IDisposable

Constructors

Name	Description
FormulaTextBox()	Creates a new floating formula editor bar.

Properties

Name	Description
AllowUndo	Gets allow undo.
AutoComplete	Gets or sets whether to allow the automatic completion of text in the formula text box.
AutoIndent	Gets or sets whether the formula is automatically formatted by wrapping to multiple lines with indentation.
FormatWidthLimit	Gets or sets the maximum width limit for formatting.
IndentSize	Gets or sets the size of Indent.
ShouldResetFormat	Gets should reset format.
Text	Gets or sets the current text in the formula text box.

Methods

Name	Description
Attach(FpSpread)	Attaches the specified Spread component to the formula text box.
Detach()	Detaches the Spread component from the formula text box.
Dispose(bool)	Releases the unmanaged resources used by the TextBox and optionally releases the managed resources.
GetVerticalScrollMaximum(RichTextBox)
GetVerticalScrollMinimum(RichTextBox)
IsInputKey(Keys)	Determines whether the specified key is an input key or a special key that requires preprocessing.
IsVerticalScrollBarVisible(RichTextBox)	Checks if the vertical scrollbar is currently visible in the RichTextBox.
OnEnter(EventArgs)	Raises the Enter event.
OnGotFocus(EventArgs)	Raises the GotFocus event.
OnKeyDown(KeyEventArgs)	Raises the KeyDown event.
OnKeyPress(KeyPressEventArgs)	Raises the KeyPress event.
OnLayout(LayoutEventArgs)	Raises the Layout event.
OnLostFocus(EventArgs)	Raises the LostFocus event.
OnMouseDown(MouseEventArgs)	Raises the MouseDown event.
OnMouseUp(MouseEventArgs)	Raises the OnMouseUp event.
OnParentChanged(EventArgs)	Raises the System.Windows.Forms.Control.ParentChanged event.
OnSelectionChanged(EventArgs)	Raises the SelectionChanged event.
OnSizeChanged(EventArgs)	Raises the System.Windows.Forms.Control.SizeChanged event.
OnTextChanged(EventArgs)	Raises the TextChanged event.
ProcessDialogKey(Keys)	Processes a dialog key.
ScaleControl(SizeF, BoundsSpecified)	Scales the location, size, padding, and margin of a control.
WndProc(ref Message)	Handles windows messages.

Events

Name	Description
FormulaChanged	Raised when the formula is changed. This is different from TextChanged since if the text is changed manually, the FormulaChanged event is not raised.