XLSCellAreas5: Class TSolidCellAreas

# Class TSolidCellAreas

Description | Hierarchy | Fields | Methods | Properties

## Unit

XLSCellAreas5

## Declaration

`type TSolidCellAreas = class(TBaseCellAreas)`

## Description

Base class for objects that manipulates cell areas. Solid areas are areas that not can be splitted by delete/insert/move operations, such as merged cells.

## Hierarchy

- TObjectList
- TBaseCellAreas
- TSolidCellAreas

## Overview

### Methods

| `procedure Copy(const Col1,Row1,Col2,Row2: integer; const DeltaCol,DeltaRow: integer); override;`
| `procedure Delete(const Col1,Row1,Col2,Row2: integer); overload; override;`
| `function Include(const Col1,Row1,Col2,Row2: integer): TCellArea; override;`
| `procedure Move(const DeltaCol,DeltaRow: integer); overload; override;`
| `procedure Move(const Col1,Row1,Col2,Row2: integer; const DeltaCol,DeltaRow: integer); overload; override;`

### Properties

| `property CopyFailed: boolean read FCopyFailed;`

## Description

### Methods

| `procedure Copy(const Col1,Row1,Col2,Row2: integer; const DeltaCol,DeltaRow: integer); override;`
Copies cell areas. Copies the cell areas that intersects the area given by Col1,Row1, Col2,Row2. The areas are copied DeltaCol and DeltaRow offset from their current position. DeltaCol and DeltaRow can be negative for copying left/up. ˜param Col1 Left column. ˜param Row1 Top row. ˜param Col2 Right column. ˜param Row2 Bottom row. ˜param DeltaCol How many columns to the right (positive) or left (negative) the areas shall be copied. ˜param DeltaRow How many rows down (positive) or up (negative) the areas shall be copied.

| `procedure Delete(const Col1,Row1,Col2,Row2: integer); overload; override;`
Delete areas. Delete the areas that intersects the area given by Col1,Row1,Col2,Row2. ˜param Col1 Left column. ˜param Row1 Top row. ˜param Col2 Right column. ˜param Row2 Bottom row.

| `function Include(const Col1,Row1,Col2,Row2: integer): TCellArea; override;`
All areas that intersects the area given by Col1,Row1,Col2,Row2 are merged into one single area, where all arwas fits. ˜param Col1 Left column. ˜param Row1 Top row. ˜param Col2 Right column. ˜param Row2 Bottom row.

| `procedure Move(const DeltaCol,DeltaRow: integer); overload; override;`
Moves areas. Move all areas by the offset DeltaCol,DeltaRow. DeltaCol and DeltaRow can be negative for moving left/up. ˜param DeltaCol How many columns to the right (positive) or left (negative) the areas shall be moved. ˜param DeltaRow How many rows down (positive) or up (negative) the areas shall be moved.

| `procedure Move(const Col1,Row1,Col2,Row2: integer; const DeltaCol,DeltaRow: integer); overload; override;`
Moves areas. Move all areas that intersects the area given by Col1,Row1,Col2,Row2, by the offset DeltaCol,DeltaRow. DeltaCol and DeltaRow can be negative for moving left/up. ˜param Col1 Left column. ˜param Row1 Top row. ˜param Col2 Right column. ˜param Row2 Bottom row. ˜param DeltaCol How many columns to the right (positive) or left (negative) the areas shall be moved. ˜param DeltaRow How many rows down (positive) or up (negative) the areas shall be moved.

### Properties

| `property CopyFailed: boolean read FCopyFailed;`
True if a Copy of Move operation failed because one of the areas was to be copied over an existing area. Equivalen to the Excel error message "Can not change part of a merged cell".

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