Displaying Formula in Cells

Spread for WinForms allows you to display and highlight the formula in a cell instead of its final calculated value. The DisplayFormulas property in the IWorksheetView interface is used to enable or disable the display and highlight of cell formulas. By default, it is set to false. The DisplayFormulas property is set at the worksheet level. Hence, the other worksheets are not impacted by the value of any particular sheet.

When the DisplayFormulas property is set to true, then the cell’s formula is highlighted, and the column widths are also doubled to display the long formulas in cells conveniently. However, when set to false, the column widths are restored to their original width.

!type=note

Note:

• This feature works when LegacyBehaviors.Style is excluded from LegacyBehaviors enum.

• When the DisplayFormulas property is enabled, text overflow and auto merged cells are disabled.

The below image depicts the behavior of the DisplayFormulas property-

The following code is used to display and highlight the formula in the active cell.

IWorksheet sheet = fpSpread1.AsWorkbook().ActiveSheet;
// Displaying formula in cell
sheet.View.DisplayFormulas = true;
sheet.Cells["A1"].Value = 1;
sheet.Cells["B1"].Value = 1;
sheet.Cells["A2"].Formula = "SUM(A1,B1)";
sheet.Cells["A2"].Select();

Dim sheet As IWorksheet = FpSpread1.AsWorkbook().ActiveSheet
' Displaying formula in cell
sheet.View.DisplayFormulas = True
sheet.Cells("A1").Value = 1
sheet.Cells("B1").Value = 1
sheet.Cells("A2").Formula = "SUM(A1,B1)"
sheet.Cells("A2").[Select](gcdocsite__documentlink?toc-item-id=f6c64a40-bdec-4dbf-92b8-b587d79944ba)

Using Spread Designer

To enable the 'Show Formulas' option in Spread Designer, click on the 'Show Formulas' button from the Formulas tab. If the mode is already enabled, this button turns gray.

See Also

Formulas in Cells

Placing a Formula in Cells

Specifying a Cell Reference in a Formula

Specifying a Sheet Reference in a Formula

Specifying an External Reference in a Formula

Using a Circular Reference in a Formula

Using DataTable Formula

Nesting Functions in a Formula

Recalculating and Updating Formulas Automatically

Finding a Value Using GoalSeek

Allowing the User to Enter Formulas

Creating and Using a Custom Name

Creating and Using a Custom Function

Creating and Using External Variable

Using the Array Formula

Working With Dynamic Array Formulas

Working with the Formula Text Box

Setting up the Name Box

Using Language Package

Accessing Data from Header or Footer

Managing External Reference

Auto Format Formulas

Precedents and Dependents