How to use FormulaBar with Aspose.Cells.GridDesktop

Using FormulaBar with Aspose.Cells.GridDesktop

Step 1: Creating a New Project

1. Open Visual Studio 2019.
2. From the File menu, select New, then Project.
   The Create a New Project dialog is opened.
3. Select Windows Forms App (.NET Framework) from Visual Studio installed project templates and click Next.

4. Specify the location and the name of the project, and click Create.

Step 2: Add controls to the toolbox

1. Click on the Toolbox.
2. Choose Common Controls, right‑click, and select Choose Items… from the context menu.
3. In the .NET Framework Components tab of the Choose Toolbox Items window, scroll and select GridDesktop and FormulaBar components.

Step 3: Add controls to the form

1. Drag GridDesktop and FormulaBar controls to the form. This should add the reference to the Aspose.Cells.GridDesktop.dll in the project references. If the reference is not added, you can manually add it by right‑clicking the References node and selecting Add Reference…. Browse to the location of Aspose.Cells.GridDesktop.dll and add it.

2. Once the controls are added, set the Name of the GridDesktop control in the Properties tab. (This is required for linking the FormulaBar to the GridDesktop.)

3. Link the FormulaBar to the GridDesktop control as shown in the following picture.

Step 4: Test the controls

Run the application and test the controls. It will generate output similar to the image shown below. You can see that the FormulaBar and the GridDesktop are linked.