XLSSheetData5

# Unit XLSSheetData5

Description | Uses | Classes, Interfaces, Objects and Records | Functions and Procedures | Types | Constants | Variables

## Description

## Uses

- Classes
- SysUtils
- Windows
- Contnrs
- Types
- ComCtrls
- Graphics
- Variants
- Math
- BIFF5
- BIFF_EncodeFormulaII5
- BIFF_VBA5
- xpgParseDrawing
- Xc12Utils5
- Xc12Common5
- Xc12DataSST5
- Xc12DataWorkbook5
- Xc12DataWorksheet5
- Xc12Manager5
- XLSUtils5
- XLSMMU5
- XLSCellMMU5
- XLSRow5
- XLSColumn5
- XLSCellAreas5
- Xc12DataStyleSheet5
- XLSValidate5
- XLSMergedCells5
- XLSHyperlinks5
- XLSCondFormat5
- XLSAutofilter5
- XLSDrawing5
- XLSDecodeFmla5
- XLSTextUtils5
- XLSRTFReadWrite5
- XLSFormula5
- XLSMask5
- XLSFormulaTypes5
- XLSNames5
- XLSClassFactory5
- XLSComment5
- XLSFormattedObj5
- XLSRange5
- XLSCmdFormat5
- XLSTools5
- XLSClipboard5

## Overview

### Classes, Interfaces, Objects and Records

Name | Description
--- | ---
record `TXLSCellSortItem` |
Class `TXLSSelectedArea` |
Class `TXLSSelectedAreas` |
Class `TXLSVertPagebreak` |
Class `TXLSVertPagebreaks` |
Class `TXLSHorizPagebreak` |
Class `TXLSHorizPagebreaks` |
Class `TXLSPageBreaks` |
Class `TXLSHeaderFooter` |
Class `TXLSPrintSettings` |
Class `TXLSPane` |
Class `TXLSSheetProtection` |
Class `TXLSWorksheet` |
Class `TXLSWorkbookData` |
Class `TXLSOptionsDialog` |
Class `TXLSWorkbook` |

### Types

`TXLSDeleteOption = (...);`
`TXLSDeleteOptions = set of TXLSDeleteOption;`
`TPaneType = (...);`
`TActivePane = (...);`
`TWorkspaceOption = (...);`
`TWorkspaceOptions = set of TWorkspaceOption;`
`TWorkbookOption = (...);`
`TWorkbookOptions = set of TWorkbookOption;`
`TCopyCellsOption = (...);`
`TCopyCellsOptions = set of TCopyCellsOption;`
`TPrintSetupOption = (...);`
`TPrintSetupOptions = set of TPrintSetupOption;`
`TXLSSheetOption = (...);`
`TXLSSheetOptions = set of TXLSSheetOption;`
`TSelectedAreaHit = (...);`
`TSelectedEdgeHit = (...);`
`TSelectedEdgeHits = set of TSelectedEdgeHit;`

### Constants

`DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing];`
`CopyAllCells = [ccoCopyValues, ccoCopyShapes, ccoCopyNotes, ccoCopyCondFmt, ccoCopyValidations, ccoCopyMerged ];`

## Description

### Types

`TXLSDeleteOption = (...);`

###### Values

- xdoCellValues:
- xdoFormats:
- xdoComments:
- xdoDataValidations:
- xdoConditionalFormats:
- xdoAutofilters:
- xdoDrawing:

`TXLSDeleteOptions = set of TXLSDeleteOption;`

`TPaneType = (...);`

Pane type when a worksheet has splitted panes.

###### Values

- ptNone:
- ptFrozen: No panes.
- ptSplit: Frozen panes,
- ptFrozenSplit: Splitted panes.

`TActivePane = (...);`

###### Values

- apBottomRight:
- apTopRight:
- apBottomLeft:
- apTopLeft:

`TWorkspaceOption = (...);`

###### Values

- woShowAutoBreaks:
- woApplyStyles: Automatic page breaks are visible.
- woRowSumsBelow: Automatic styles are applied to an outline
- woColSumsRight: Summary rows appear below detail in an outline
- woFitToPage: Summary columns appear to the right of detail in an outline
- woOutlineSymbols: Page fit option is on.

`TWorkspaceOptions = set of TWorkspaceOption;`
Outline symbols are displayed.

`TWorkbookOption = (...);`

###### Values

- woHidden:
- woIconized: The window is hidden.
- woHScroll: The window is displayed as an icon.
- woVScroll: The horizontal scroll bar is displayed.
- woTabs: The vertical scroll bar is displayed.

`TWorkbookOptions = set of TWorkbookOption;`
The workbook tabs are displayed.

`TCopyCellsOption = (...);`

Options when copying and moving cells.

###### Values

- ccoAdjustCells:
- ccoLockStartRow: Adjust relative cells according to the new location.
- ccoForceAdjust: Don't adjust the first row.
- ccoCopyValues: Adjust absolute cell references as well.
- ccoCopyShapes: Copy cell values.
- ccoCopyNotes: Copy shape objects.
- ccoCopyCondFmt: Copy cell notes.
- ccoCopyValidations: Copy conditional formats.
- ccoCopyMerged: Copy cell validations.

`TCopyCellsOptions = set of TCopyCellsOption;`
Copy merged cells.

`TPrintSetupOption = (...);`

Cell values Drawing shapes. Cell notes. Conditional formats. Cell validations. Merged cells.

###### Values

- psoLeftToRight:
- psoPortrait:
- psoNoColor:
- psoDraftQuality:
- psoNotes:
- psoRowColHeading:
- psoGridlines:
- psoHorizCenter:
- psoVertCenter:

`TPrintSetupOptions = set of TPrintSetupOption;`

`TXLSSheetOption = (...);`

###### Values

- soGridlines:
- soRowColHeadings: Show gridlines.
- soShowFormulas: Show row and column headings.
- soShowZeros: Show formulas instead of formula result.

`TXLSSheetOptions = set of TXLSSheetOption;`
Show zero values.

`TSelectedAreaHit = (...);`

###### Values

- sahNo:
- sahInside:
- sahEdge:
- sahActiveCell:

`TSelectedEdgeHit = (...);`

###### Values

- sehLeft:
- sehTop:
- sehRight:
- sehBottom:

`TSelectedEdgeHits = set of TSelectedEdgeHit;`

### Constants

`DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing];`

`CopyAllCells = [ccoCopyValues, ccoCopyShapes, ccoCopyNotes, ccoCopyCondFmt, ccoCopyValidations, ccoCopyMerged ];`
What parts of the data on a worksheet that shall be copied/moved.

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