Class FormulaBar

Class which holds the properties and operations related with controls such as NameBox, FormulaTextBox, EndEdit button and CancelEdit button in Spreadsheet.

Inheritance
System.Object
FormulaBar
Namespace: Syncfusion.Windows.Forms.Spreadsheet
Assembly: Syncfusion.Spreadsheet.Windows.dll
Syntax
public class FormulaBar : Panel
Remarks

The Formula Bar is located above the worksheet area of the spreadsheet. The formula bar displays the data or formula stored in the active cell.

The Name Box is located next to the formula bar above the worksheet area. The Name Box normally displays the cell reference of the active cell.

The EndEdit Button is used to save the entered the data and end edit the cell.

The CancelEdit Button is used to revert the newly entered data and end edit the cell.

Constructors

FormulaBar(Spreadsheet)

Initializes a new instance of the FormulaBar class.

Declaration
public FormulaBar(Spreadsheet Spreadsheet)
Parameters
Type Name Description
Spreadsheet Spreadsheet

Fields

EndEditButton

Declaration
public PictureBox EndEditButton
Field Value
Type Description
System.Windows.Forms.PictureBox

Properties

CreateParams

Used this to avoid the flickering in formula bar when open and close the backstage.

Declaration
protected override CreateParams CreateParams { get; }
Property Value
Type Description
System.Windows.Forms.CreateParams

ScaleChildren

Gets a value that determines the scaling of child controls.

Declaration
protected override bool ScaleChildren { get; }
Property Value
Type Description
System.Boolean
Remarks

If it's true, then the Scale method will recursively call the ScaleControl method of each of its child controls. The default return value is trueDerived classes can override ScaleChildren to return false to indicate that scaling should not be performed on their children.

Methods

Dispose()

Dispose the live instances

Declaration
public void Dispose()

Dispose(Boolean)

Clean up any resources being used.

Declaration
protected override void Dispose(bool disposing)
Parameters
Type Name Description
System.Boolean disposing

true if managed resources should be disposed; otherwise, false.

OnMouseMove(MouseEventArgs)

Resizing the formulabar.

Declaration
protected override void OnMouseMove(MouseEventArgs e)
Parameters
Type Name Description
System.Windows.Forms.MouseEventArgs e

ProcessCmdKey(ref Message, Keys)

Declaration
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
Parameters
Type Name Description
System.Windows.Forms.Message msg
System.Windows.Forms.Keys keyData
Returns
Type Description
System.Boolean

ScaleControl(SizeF, BoundsSpecified)

Scales the location, size, padding, and margin of a control.

Declaration
protected override void ScaleControl(SizeF factor, BoundsSpecified specified)
Parameters
Type Name Description
System.Drawing.SizeF factor

Factor by which the height and width of the control are scaled.
System.Windows.Forms.BoundsSpecified specified

Bound of the controlto use when defining its size and position
Remarks

Returns if the factor is != (1,1) which is a default scaling factor

WndProc(ref Message)

Declaration
protected override void WndProc(ref Message m)
Parameters
Type Name Description
System.Windows.Forms.Message m