Calc .NET Class Library
Show/Hide TOC

# DatabaseRange Class

Represents a database range, a named rectangular cell range that can be sorted, filtered or refreshed from a data source. Formulas may refer to a database range by its name.

## Definition

Namespace: Independentsoft.Office.Odf
Assembly: Independentsoft.Calc (in Independentsoft.Calc.dll) Version: 3.0.520.1+c6c593d5629a051e0af021b238c5d69d764f9686
C#

    public class DatabaseRange

VB

    Public Class DatabaseRange

Inheritance
  Object DatabaseRange

## Constructors

DatabaseRange | Initializes a new instance of the DatabaseRange class.

## Properties

ContainsHeader | Specifies whether the first row of the range contains column labels.
DisplayFilterButtons | Specifies whether filter buttons are displayed.
HasPersistentData | Specifies whether data is copied into the document or read on demand.
IsSelection | Specifies whether the database range is a selection.
Name | The name of the database range.
OnUpdateKeepSize | Specifies whether the size of the range is kept when the range is updated.
OnUpdateKeepStyles | Specifies whether cell styles are kept when the range is updated.
Orientation | The orientation of the database range, "column" or "row".
RefreshDelay | The refresh delay as ISO 8601 duration.
TargetRangeAddress | The cell range address of the database range, for example "Sheet1.A1:Sheet1.B10".

## Methods

Clone | Creates a new object that is a deep copy of the current instance.
Equals | (Inherited from Object)
Finalize | (Inherited from Object)
GetHashCode | (Inherited from Object)
GetType | (Inherited from Object)
MemberwiseClone | (Inherited from Object)
ToString | Converts the value of the current DatabaseRange object to its equivalent string representation. (Overrides ObjectToString)

## See Also

#### Reference

Independentsoft.Office.Odf Namespace