CellRange.HasFormula Property

Determines whether all cells in the range contain a formula.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

bool HasFormula { get; }

VB.NET

ReadOnly Property HasFormula As Boolean

Property Value

Type	Description
Boolean	true, if all cells in the range contain a formula; otherwise, false.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the HasFormula property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/CS/SpreadsheetApp/Form1.cs#L22

{
    foreach (var cell in sheet.GetExistingCells().Where(x => x.HasFormula))
    {

VB.NET

spreadsheet-use-concatenate-function-to-update-long-strings-in-formulas/VB/SpreadsheetApp/Form1.vb#L19

For Each sheet In workbook.Worksheets
    For Each cell In sheet.GetExistingCells().Where(Function(x) x.HasFormula)
        Dim walker = New ReplaceLongStringsWalker(workbook)