GetUnboundValue Method (SheetView)

Gets the unbound value for a cell at the specified row and column.

Syntax

Visual Basic
C#

'Declaration
 
Public Function GetUnboundValue( _
   ByVal row As Integer, _
   ByVal column As Integer _
) As Object

'Usage
 
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim value As Object
 
value = instance.GetUnboundValue(row, column)

public object GetUnboundValue( 
   int row,
   int column
)

Parameters

row: Row index
column: Column index

Return Value

Object containing the value in the cell, or null if there is none

Example

This example returns the unbound value for the specified cell.

FarPoint.Web.Spread.SheetView sv;
sv = FpSpread1.ActiveSheetView;
object o;
sv.AddUnboundRows(1, 1);
sv.SetValue(1, 0, 5);
o = sv.GetUnboundValue(1, 0);
Response.Write("The value in the unbound cell is " + o.ToString());

Visual Basic

Dim sv As FarPoint.Web.Spread.SheetView
sv = FpSpread1.ActiveSheetView
Dim o As Object
sv.AddUnboundRows(1, 1)
sv.SetValue(1, 0, 5)
o = sv.GetUnboundValue(1, 0)
Response.Write("The value in the unbound cell is " & o.ToString())

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

SheetView Class
SheetView Members
GetValue Method
GetText Method

User-Task Documentation

Handling Data Using Cell Properties