XLSColumn5: Class TXLSColumns

# Class TXLSColumns

Description | Hierarchy | Fields | Methods | Properties

## Unit

XLSColumn5

## Declaration

`type TXLSColumns = class(TObject)`

## Description

Methods for manipulating columns. Please note that these methods has no affect on the cell values. They operate only on the columns heading.

## Hierarchy

- TObject
- TXLSColumns

## Overview

### Methods

| `constructor Create(AColumns : TXc12Columns; AStyles: TXc12DataStyleSheet);`
| `destructor Destroy; override;`
| `procedure Clear;`
| `function CutHitList(ACol1,ACol2: integer): TXc12Columns;`
| `function CopyHitList(ACol1,ACol2: integer): TXc12Columns;`
| `procedure OffsetList(AList: TXc12Columns; const AOffset: integer);`
| `procedure InsertList(AList: TXc12Columns);`
| `function GetColWidth(ACol: integer): integer;`
| `function GetColWidthPixels(ACol: integer): integer;`
| `procedure SetColWidth(ACol1,ACol2: integer; AValue: integer);`
| `procedure DeleteColumns(ACol1,ACol2: integer);`
| `procedure ClearColumns(ACol1,ACol2: integer);`
| `procedure CopyColumns(ACol1,ACol2,ADestCol: integer);`
| `procedure MoveColumns(ACol1,ACol2,ADestCol: integer);`
| `procedure InsertColumns(ACol,AColCount: integer);`
| `procedure Group(ACol: integer);`
| `procedure GroupAll(ALevel: integer);`
| `procedure AddIfNone(ACol,ACount: integer);`

### Properties

| `property OnColWidthChange: TTwoIntegerEvent read FChangeEvent write FChangeEvent;`
| `property Items[Index:integer]: TXLSColumn read GetItems;`

## Description

### Methods

| `constructor Create(AColumns : TXc12Columns; AStyles: TXc12DataStyleSheet);`

| `destructor Destroy; override;`

| `procedure Clear;`

| `function CutHitList(ACol1,ACol2: integer): TXc12Columns;`
The method creates a TXc12Columns list and copies the the columns between ACol1,ACol2 to the list. The columns between ACol1,ACol2 is then deleted. The object must be destroyed by the caller. This method is mainly for internal use.

| `function CopyHitList(ACol1,ACol2: integer): TXc12Columns;`
The method creates a TXc12Columns list and copies the the columns between ACol1,ACol2 to the list. The object must be destroyed by the caller. This methid is mainly for internal use.

| `procedure OffsetList(AList: TXc12Columns; const AOffset: integer);`
Offset the columns in AList. For use with lists created with CutHitList or CopyHitList.

| `procedure InsertList(AList: TXc12Columns);`
Inserts a column list. For use with lists created with CutHitList or CopyHitList.

| `function GetColWidth(ACol: integer): integer;`

| `function GetColWidthPixels(ACol: integer): integer;`

| `procedure SetColWidth(ACol1,ACol2: integer; AValue: integer);`

| `procedure DeleteColumns(ACol1,ACol2: integer);`
Delets all columns between Col1 and Col2. Columns to the right of Col2 will be shifted left.

| `procedure ClearColumns(ACol1,ACol2: integer);`
Delets all columns between Col1 and Col2.

| `procedure CopyColumns(ACol1,ACol2,ADestCol: integer);`

| `procedure MoveColumns(ACol1,ACol2,ADestCol: integer);`

| `procedure InsertColumns(ACol,AColCount: integer);`

| `procedure Group(ACol: integer);`

| `procedure GroupAll(ALevel: integer);`

| `procedure AddIfNone(ACol,ACount: integer);`

### Properties

| `property OnColWidthChange: TTwoIntegerEvent read FChangeEvent write FChangeEvent;`

| `property Items[Index:integer]: TXLSColumn read GetItems;`

Generated by PasDoc 0.12.1 on 2013-03-18 12:36:47