Enumeration: UsedRangeType

Spread.Sheets.UsedRangeType

Worksheet used range

Table of contents

Enumeration members

• all
• axis
• chart
• colStyle
• comment
• conditionFormat
• data
• dataRange
• dataValidation
• filter
• formula
• picture
• pivottable
• rowStyle
• shape
• slicer
• span
• sparkLine
• style
• table
• tag
• threadedComment

Enumeration members

all

• all = 4294967295

Sheet all used range type

---

axis

• axis = 1

Sheet header used range

---

chart

• chart = 65536

Sheet chart used range

---

colStyle

• colStyle = 8

Sheet column style used range

---

comment

• comment = 1024

Sheet comment used range

---

conditionFormat

• conditionFormat = 32768

Sheet conditionFormat used range

---

data

• data = 16

Sheet data used range

---

dataRange

• dataRange = 524288

Sheet data range used range

---

dataValidation

• dataValidation = 16384

Sheet dataValidation used range

---

filter

• filter = 8192

Sheet filter used range

---

formula

• formula = 32

Sheet formula used range

---

picture

• picture = 131072

Sheet picture used range

---

pivottable

• pivottable = 4096

Sheet pivot table used range

---

rowStyle

• rowStyle = 4

Sheet row style used range

---

shape

• shape = 128

Sheet shape used range

---

slicer

• slicer = 2048

Sheet slicer used range

---

span

• span = 64

Sheet span used range

---

sparkLine

• sparkLine = 512

Sheet sparkLine used range

---

style

• style = 2

Sheet cell style used range

---

table

• table = 256

Sheet table used range

---

tag

• tag = 262144

Sheet tag used range

---

threadedComment

• threadedComment = 1048576

Sheet threaded comment used range