# GC.Spread.Sheets.UsedRangeType

## Content

# Enumeration: UsedRangeType

[Spread](../modules/GC.Spread).[Sheets](../modules/GC.Spread.Sheets).UsedRangeType

Worksheet used range

## Table of contents

### Enumeration members

- [all](GC.Spread.Sheets.UsedRangeType#all)
- [axis](GC.Spread.Sheets.UsedRangeType#axis)
- [chart](GC.Spread.Sheets.UsedRangeType#chart)
- [colStyle](GC.Spread.Sheets.UsedRangeType#colstyle)
- [comment](GC.Spread.Sheets.UsedRangeType#comment)
- [conditionFormat](GC.Spread.Sheets.UsedRangeType#conditionformat)
- [data](GC.Spread.Sheets.UsedRangeType#data)
- [dataRange](GC.Spread.Sheets.UsedRangeType#datarange)
- [dataValidation](GC.Spread.Sheets.UsedRangeType#datavalidation)
- [filter](GC.Spread.Sheets.UsedRangeType#filter)
- [formula](GC.Spread.Sheets.UsedRangeType#formula)
- [picture](GC.Spread.Sheets.UsedRangeType#picture)
- [pivottable](GC.Spread.Sheets.UsedRangeType#pivottable)
- [rowStyle](GC.Spread.Sheets.UsedRangeType#rowstyle)
- [shape](GC.Spread.Sheets.UsedRangeType#shape)
- [slicer](GC.Spread.Sheets.UsedRangeType#slicer)
- [span](GC.Spread.Sheets.UsedRangeType#span)
- [sparkLine](GC.Spread.Sheets.UsedRangeType#sparkline)
- [style](GC.Spread.Sheets.UsedRangeType#style)
- [table](GC.Spread.Sheets.UsedRangeType#table)
- [tag](GC.Spread.Sheets.UsedRangeType#tag)

## Enumeration members

### <a id="all" name="all"></a> all

• **all** = `4294967295`

Sheet all used range type

___

### <a id="axis" name="axis"></a> axis

• **axis** = `1`

Sheet header used range

___

### <a id="chart" name="chart"></a> chart

• **chart** = `65536`

Sheet chart used range

___

### <a id="colstyle" name="colstyle"></a> colStyle

• **colStyle** = `8`

Sheet column style used range

___

### <a id="comment" name="comment"></a> comment

• **comment** = `1024`

Sheet comment used range

___

### <a id="conditionformat" name="conditionformat"></a> conditionFormat

• **conditionFormat** = `32768`

Sheet conditionFormat used range

___

### <a id="data" name="data"></a> data

• **data** = `16`

Sheet data used range

___

### <a id="datarange" name="datarange"></a> dataRange

• **dataRange** = `524288`

Sheet data range used range

___

### <a id="datavalidation" name="datavalidation"></a> dataValidation

• **dataValidation** = `16384`

Sheet dataValidation used range

___

### <a id="filter" name="filter"></a> filter

• **filter** = `8192`

Sheet filter used range

___

### <a id="formula" name="formula"></a> formula

• **formula** = `32`

Sheet formula used range

___

### <a id="picture" name="picture"></a> picture

• **picture** = `131072`

Sheet picture used range

___

### <a id="pivottable" name="pivottable"></a> pivottable

• **pivottable** = `4096`

Sheet pivot table used range

___

### <a id="rowstyle" name="rowstyle"></a> rowStyle

• **rowStyle** = `4`

Sheet row style used range

___

### <a id="shape" name="shape"></a> shape

• **shape** = `128`

Sheet shape used range

___

### <a id="slicer" name="slicer"></a> slicer

• **slicer** = `2048`

Sheet slicer used range

___

### <a id="span" name="span"></a> span

• **span** = `64`

Sheet span used range

___

### <a id="sparkline" name="sparkline"></a> sparkLine

• **sparkLine** = `512`

Sheet sparkLine used range

___

### <a id="style" name="style"></a> style

• **style** = `2`

Sheet cell style used range

___

### <a id="table" name="table"></a> table

• **table** = `256`

Sheet table used range

___

### <a id="tag" name="tag"></a> tag

• **tag** = `262144`

Sheet tag used range