# GC.Spread.Sheets.Fill.AutoFillType

## Content

# Enumeration: AutoFillType

[Sheets](../modules/GC.Spread.Sheets).[Fill](../modules/GC.Spread.Sheets.Fill).AutoFillType

Represents the type of drag fill.

**`example`**
```javascript
//This example uses the AutoFillType enumeration.
console.log(spread.options.defaultDragFillType); // equals to GC.Spread.Sheets.Fill.AutoFillType.auto
spread.options.defaultDragFillType = GC.Spread.Sheets.Fill.AutoFillType.copyCells;
```

## Table of contents

### Enumeration members

- [auto](GC.Spread.Sheets.Fill.AutoFillType#auto)
- [clearValues](GC.Spread.Sheets.Fill.AutoFillType#clearvalues)
- [copyCells](GC.Spread.Sheets.Fill.AutoFillType#copycells)
- [fillFormattingOnly](GC.Spread.Sheets.Fill.AutoFillType#fillformattingonly)
- [fillSeries](GC.Spread.Sheets.Fill.AutoFillType#fillseries)
- [fillWithoutFormatting](GC.Spread.Sheets.Fill.AutoFillType#fillwithoutformatting)

## Enumeration members

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

• **auto** = `5`

 Automatically fills cells.

___

### <a id="clearvalues" name="clearvalues"></a> clearValues

• **clearValues** = `4`

 Clears cell values.

___

### <a id="copycells" name="copycells"></a> copyCells

• **copyCells** = `0`

 Fills cells with all data objects, including values, formatting, and formulas.

___

### <a id="fillformattingonly" name="fillformattingonly"></a> fillFormattingOnly

• **fillFormattingOnly** = `2`

  Fills cells only with formatting.

___

### <a id="fillseries" name="fillseries"></a> fillSeries

• **fillSeries** = `1`

  Fills cells with series.

___

### <a id="fillwithoutformatting" name="fillwithoutformatting"></a> fillWithoutFormatting

• **fillWithoutFormatting** = `3`

  Fills cells with values and not formatting.