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
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
System.Windows.Forms.CreateParams

ScaleChildren

Gets a value that determines the scaling of child controls.

Declaration

protected override bool ScaleChildren { get; }

Property Value

Type
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
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