IsAnyColumnViewIndexSet Method

Determines whether any columns have been mapped to different column indexes in the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Function IsAnyColumnViewIndexSet() As Boolean

'Usage
 
Dim instance As SheetView.DocumentModels
Dim value As Boolean
 
value = instance.IsAnyColumnViewIndexSet()

public bool IsAnyColumnViewIndexSet()

Return Value

True if there is a mapping; otherwise, false

Remarks

The row and column indexes in the SheetView are the same as the ones in the models until a mapping is created.

Example

This example returns if any mappings are set.

fpSpread1.ActiveSheet.Models.SetViewColumnIndex(2,0);
fpSpread1.ActiveSheet.Models.SetViewRowIndex(1,0);
bool b = fpSpread1.ActiveSheet.Models.IsAnyColumnViewIndexSet();
MessageBox.Show("Mappings set for columns is " + b.ToString());
b = fpSpread1.ActiveSheet.Models.IsAnyRowViewIndexSet();
MessageBox.Show("Mappings set for rows is " + b.ToString());

Visual Basic

FpSpread1.ActiveSheet.Models.SetViewColumnIndex(2,0)
FpSpread1.ActiveSheet.Models.SetViewRowIndex(1,0)
dim b As Boolean = FpSpread1.ActiveSheet.Models.IsAnyColumnViewIndexSet()
MessageBox.Show("Mappings set for columns is " + b.ToString())
b = FpSpread1.ActiveSheet.Models.IsAnyRowViewIndexSet()
MessageBox.Show("Mappings set for rows is " & b.ToString())

Reference

SheetView.DocumentModels Class
SheetView.DocumentModels Members