ColumnInputCell Property

Gets or sets the cell used as the column-input cell in the data table.

Syntax

C#

public WorksheetCell ColumnInputCell {get; set;}

Property Value

The cell used as the column-input cell in the data table.

Exceptions

Exception	Description
System.ArgumentException	The assigned value does not belong to the same worksheet as the data table.
System.InvalidOperationException	The value is assigned after the data table has been removed from the worksheet.
System.InvalidOperationException	The value assigned is within the CellsInTable region.
System.InvalidOperationException	The assigned value is null and RowInputCell is null. At least one input cell must be non-null.
System.InvalidOperationException	The assigned value is the same as RowInputCell. The input cells cannot be the same cell.

Remarks

This represents the cell reference in all formulas of the data table to replace with row header values. If this and the RowInputCell are non-null, the data table is a two-variable data table. Otherwise, if only one is non-null, this is a one-variable data table.

Note: The RowInputCell and ColumnInputCell cannot be within the CellsInTable region.

Requirements

Target Platforms: Android 4.4+, iOS 8+

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