menu

WinForms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class FormulaBar - WindowsForms API Reference | Syncfusion

    Show / Hide Table of Contents

    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
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved