ApplyTo(WorksheetRegion) Method

Applies the formula to the specified region of cells.

Syntax

C#

public void ApplyTo( 
   WorksheetRegion region
)

Parameters

region

The region of cells to apply the formula to.

Exceptions

Exception	Description
System.ArgumentNullException	region is null.
System.InvalidOperationException	region contains an array formula or data table which extends outside the region.

Remarks

This method, or one of the other ApplyTo overrides must be used to set the value of a cell to a formula.

After this method returns, the WorksheetCell.Formula of all cells in the specified region will return the formula.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+