AllowGetAllHiddenValue Property

Gets or Sets whether Spread should support get/set value from any hidden cell in whole sheet or not.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AllowGetAllHiddenValue As Boolean

'Usage
 
Dim instance As FpSpread
Dim value As Boolean
 
instance.AllowGetAllHiddenValue = value
 
value = instance.AllowGetAllHiddenValue

public bool AllowGetAllHiddenValue {get; set;}

Remarks

Set this property to True to allow getting or setting values in hidden cells in the entire sheet. Set this property to False to get or set values in hidden cells in the current page only. This property applies to the GetHiddenCellValue and SetHiddenCellValue methods.

Example

fpSpread1.AllowGetAllHiddenValue = true;

Visual Basic

FpSpread1.AllowGetAllHiddenValue = True

Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

FpSpread Class
FpSpread Members
GetHiddenCellValue
SetHiddenCellValue
SetHiddenValue
GetHiddenValue