XLSSheetData5: Class TXLSWorksheet

# Class TXLSWorksheet

Description | Hierarchy | Fields | Methods | Properties

## Unit

XLSSheetData5

## Declaration

`type TXLSWorksheet = class(TIndexObject)`

## Description

no description available, TIndexObject description follows

## Hierarchy

- TObject
- TIndexObject
- TXLSWorksheet

## Overview

### Methods

| `constructor Create(AClassFactory: TXLSClassFactory; AOwner: TXLSWorkbook; AManager: TXc12Manager; AXc12Sheet: TXc12DataWorksheet);`
| `destructor Destroy; override;`
| `function RequestObject(AClass: TClass): TObject; override;`
| `function MakeFormattedText(const ACell: TXLSCellItem): TXLSFormattedText; overload;`
| `function MakeFormattedText(const ACol,ARow: integer; var AFormattedText: TXLSFormattedText): boolean; overload;`
| `procedure Assign(Source: TXLSWorksheet);`
| `function MMUCells: TXLSCellMMU;`
| `procedure Clear;`
| `procedure ClearData;`
| `procedure ClearWorksheet;`
| `procedure FillRandom(const AArea: AxUCString;const AValue: integer);`
| `function AutoWidthCol(const ACol: integer): integer;`
| `procedure AutoWidthCols(const Col1,Col2: integer);`
| `function AutoHeightRow(const ARow: integer): boolean;`
| `function AutoHeightRows(const Row1,Row2: integer): boolean;`
| `procedure AutoSizeCell(const ACol,ARow: integer; const ASizeCol,ASizeRow: boolean);`
| `procedure UnfreezePanes;`
| `procedure FreezePanes(const AColumns,ARows: integer);`
| `procedure UnsplitPanes;`
| `procedure SplitPanes(const APointsWidth,APointsHeight: integer);`
| `procedure CalcDimensions;`
| `procedure CalcDimensionsEx;`
| `function Calculate(const ACol, ARow: integer): Variant;`
| `function CalculateEx(Col, Row: integer; CalculateOptions: boolean): Variant;`
| `function CalculateAsString(const ACol, ARow: integer): AxUCString;`
| `procedure CalculateSheet;`
| `procedure Calculated(const IsCalculated: boolean);`
| `procedure CopyCell(const ACol, ARow, ADestCol, ADestRow: integer);`
| `procedure CopyCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);`
| `procedure DeleteCell(const ACol, ARow: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);`
| `procedure DeleteCells(const ACol1, ARow1, ACol2, ARow2: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);`
| `procedure ClearCell(const ACol, ARow: integer);`
| `procedure CelarCells(const ACol1, ARow1, ACol2, ARow2: integer);`
| `procedure MoveCell(const ACol, ARow, ADestCol, ADestRow: integer);`
| `procedure MoveCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);`
| `function MergeCells(Col1, Row1, Col2, Row2: integer): boolean;`
| `procedure DeleteRows(const ARow1,ARow2: integer);`
| `procedure ClearRows(const ARow1,ARow2: integer);`
| `procedure InsertRows(const ARow,ARowCount: integer);`
| `procedure CopyRows(const ARow1,ARow2,ADestRow: integer);`
| `procedure MoveRows(const ARow1,ARow2,ADestRow: integer);`
| `procedure DeleteColumns(const ACol1,ACol2: integer);`
| `procedure ClearColumns(const ACol1,ACol2: integer);`
| `procedure InsertColumns(const ACol,AColCount: integer);`
| `procedure CopyColumns(const ACol1,ACol2,ADestCol: integer);`
| `procedure MoveColumns(const ACol1,ACol2,ADestCol: integer);`
| `function IsEmpty: boolean;`
| `procedure Sort(const AAscending,ACaseSencitive: boolean); overload;`
| `procedure Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean); overload;`
| `procedure GroupRows(const ARow1,ARow2: integer; ACollapsed: boolean = False);`
| `procedure GroupColumns(const ACol1, ACol2: integer; ACollapsed: boolean = False);`
| `procedure RichTextLoadFromFile(const ACol, ARow: integer; const Filename: AxUCString; const AllText: boolean = True);`
| `procedure RichTextLoadFromStream(const ACol, ARow: integer; Stream: TStream; const AllText: boolean = True);`
| `procedure RichTextSaveToFile(const ACol, ARow: integer; const Filename: AxUCString);`
| `procedure RichTextSaveToStream(const ACol, ARow: integer; Stream: TStream);`
| `procedure CopyToRichEdit(const ACol,ARow: integer; var ARichEdit: TRichEdit);`
| `function FindCell(const ACol,ARow: integer): boolean;`
| `procedure BeginFindText;`
| `function FindText(const AText: AxUCString; CaseInsensitive: boolean = True): boolean;`
| `procedure GetFindData(var ACol,ARow,ATextPos: integer; var AText: AxUCString);`
| `function GetFormatString(ACell: TXLSCellItem; AColor: PLongword): AxUCString;`
| `procedure InsertFloatRowValues(const ACol,ARow: integer; const AValues: array of double); overload;`
| `procedure InsertStringRowValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;`
| `procedure InsertRowValues(const ACol,ARow: integer; const AValues: array of Variant); overload;`
| `procedure InsertFloatColValues(const ACol,ARow: integer; const AValues: array of double); overload;`
| `procedure InsertStringColValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;`
| `procedure InsertColValues(const ACol,ARow: integer; const AValues: array of Variant); overload;`
| `procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText: AxUCString); overload;`
| `procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText,ATooltip: AxUCString); overload;`
| `procedure GetShapePixelSize(AShape: TXLSDrwTwoPosShape; out AWidth,AHeight: integer);`
| `procedure BeginIterate;`
| `function IterateNext: boolean;`
| `procedure IteratePos(out ACol,ARow: integer);`
| `function FirstCol: integer;`
| `function LastCol: integer;`
| `function FirstRow: integer;`
| `function LastRow: integer;`

### Properties

| `property LeftCol: integer read GetLeftCol write SetLeftCol;`
| `property TopRow: integer read GetTopRow write SetTopRow;`
| `property DefaultColWidth: integer read GetDefaultColWidth write SetDefaultColWidth;`
| `property DefaultRowHeight: integer read GetDefaultRowHeight write SetDefaultRowHeight;`
| `property AsBlank[Col,Row:integer]: boolean read GetAsBlank write SetAsBlank;`
| `property AsInteger[Col,Row:integer]: integer read GetAsInteger write SetAsInteger;`
| `property AsFloat[Col,Row:integer]: double read GetAsFloat write SetAsFloat;`
| `property AsDateTime[Col,Row:integer]: TDateTime read GetAsDateTime write SetAsDateTime;`
| `property AsString[Col,Row:integer]: AxUCString read GetAsString write SetAsString;`
| `property AsRichText[Col,Row:integer]: AxUCString read GetAsRichText write SetAsRichText;`
| `property AsSimpleTags[ACol,ARow:integer]: AxUCString read GetAsSimpleTags write SetAsSimpleTags;`
| `property AsFmtString[Col,Row:integer]: AxUCString read GetAsFmtString;`
| `property AsHyperlink[Col,Row:integer]: AxUCString read GetAsHyperlink write SetAsHyperlink;`
| `property AsHTML[Col,Row:integer]: AxUCString read GetAsHTML;`
| `property AsBoolean[Col,Row:integer]: boolean read GetAsBoolean write SetAsBoolean;`
| `property AsError[Col,Row:integer]: TXc12CellError read GetAsError write SetAsError;`
| `property AsVariant[Col,Row:integer]: Variant read GetAsVariant write SetAsVariant;`
| `property AsFormula[Col,Row:integer]: AxUCString read GetAsFormula write SetAsFormula;`
| `property AsNumFormulaValue[Col,Row:integer]: double read GetAsNumFormulaValue write SetAsNumFormulaValue;`
| `property AsStrFormulaValue[Col,Row:integer]: AxUCString read GetAsStrFormulaValue write SetAsStrFormulaValue;`
| `property AsBoolFormulaValue[Col,Row:integer]: boolean read GetAsBoolFormulaValue write SetAsBoolFormulaValue;`
| `property IsDateTime[Col,Row:integer]: boolean read GetIsDateTime;`
| `property AsBlankRef[constARef:AxUCString]: boolean read GetAsBlankRef write SetAsBlankRef;`
| `property AsIntegerRef[constARef:AxUCString]: integer read GetAsIntegerRef write SetAsIntegerRef;`
| `property AsFloatRef[constARef:AxUCString]: double read GetAsFloatRef write SetAsFloatRef;`
| `property AsDateTimeRef[constARef:AxUCString]: TDateTime read GetAsDateTimeRef write SetAsDateTimeRef;`
| `property AsStringRef[constARef:AxUCString]: AxUCString read GetAsStringRef write SetAsStringRef;`
| `property AsRichTextRef[constARef:AxUCString]: AxUCString read GetAsRichTextRef write SetAsRichTextRef;`
| `property AsSimpleTagsRef[constARef:AxUCString]: AxUCString read GetAsSimpleTagsRef write SetAsSimpleTagsRef;`
| `property AsFmtStringRef[constARef:AxUCString]: AxUCString read GetAsFmtStringRef;`
| `property AsHTMLRef[constARef:AxUCString]: AxUCString read GetAsHTMLRef;`
| `property AsBooleanRef[constARef:AxUCString]: boolean read GetAsBooleanRef write SetAsBooleanRef;`
| `property AsErrorRef[constARef:AxUCString]: TXc12CellError read GetAsErrorRef write SetAsErrorRef;`
| `property AsFormulaRef[constARef:AxUCString]: AxUCString read GetAsFormulaRef write SetAsFormulaRef;`
| `property AsNumFormulaValueRef[constARef:AxUCString]: double read GetAsNumFormulaValueRef write SetAsNumFormulaValueRef;`
| `property AsStrFormulaValueRef[constARef:AxUCString]: AxUCString read GetAsStrFormulaValueRef write SetAsStrFormulaValueRef;`
| `property AsBoolFormulaValueRef[constARef:AxUCString]: boolean read GetAsBoolFormulaValueRef write SetAsBoolFormulaValueRef;`
| `property AsVariantRef[constARef:AxUCString]: Variant read GetAsVariantRef write SetAsVariantRef;`
| `property Cell[Col,Row:integer]: TXLSCell read GetCell;`
| `property CellType[Col,Row:integer]: TXLSCellType read GetCellType;`
| `property FormulaType[Col,Row:integer]: TXLSCellFormulaType read GetFormulaType;`
| `property Rows: TXLSRows read GetRows;`
| `property Columns: TXLSColumns read GetColumns;`
| `property Autofilter: TXLSAutofilter read GetAutofilter;`
| `property Hyperlinks: TXLSHyperlinks read GetHyperlinks;`
| `property MergedCells: TXLSMergedCells read GetMergedCells;`
| `property ConditionalFormats: TXLSConditionalFormats read GetConditionalFormats;`
| `property Validations: TXLSDataValidations read GetValidations;`
| `property Comments: TXLSComments read FComments;`
| `property PrintSettings: TXLSPrintSettings read GetPrintSettings;`
| `property SelectedAreas: TXLSSelectedAreas read GetSelectedAreas;`
| `property VisibleAreas: TCellAreas read GetVisibleAreas;`
| `property Drawing: TXLSDrawing read GetDrawing;`
| `property Range: TXLSRange read FRange;`
| `property Pane: TXLSPane read GetPane;`
| `property Protection: TXLSSheetProtection read FProtection;`
| `property Name: AxUCString read GetName write SetName;`
| `property TabColor: longword read GetTabColor write SetTabColor;`
| `property Options: TXLSSheetOptions read GetOptions write SetOptions;`
| `property WorkspaceOptions: TWorkspaceOptions read GetWorkspaceOptions write SetWorkspaceOptions;`
| `property Zoom: integer read GetZoom write SetZoom;`
| `property ZoomPreview: integer read GetZoomPreview write SetZoomPreview;`
| `property RecalcFormulas: boolean read GetRecalcFormulas write SetRecalcFormulas;`
| `property Xc12Sheet: TXc12DataWorksheet read FXc12Sheet;`
| `property XSSCellInvalidateEvent: TXc12RefEvent read FXSSCellInvalidateEvent write FXSSCellInvalidateEvent;`

## Description

### Methods

| `constructor Create(AClassFactory: TXLSClassFactory; AOwner: TXLSWorkbook; AManager: TXc12Manager; AXc12Sheet: TXc12DataWorksheet);`

| `destructor Destroy; override;`

| `function RequestObject(AClass: TClass): TObject; override;`

| `function MakeFormattedText(const ACell: TXLSCellItem): TXLSFormattedText; overload;`

| `function MakeFormattedText(const ACol,ARow: integer; var AFormattedText: TXLSFormattedText): boolean; overload;`

| `procedure Assign(Source: TXLSWorksheet);`

| `function MMUCells: TXLSCellMMU;`

| `procedure Clear;`

| `procedure ClearData;`

| `procedure ClearWorksheet;`

| `procedure FillRandom(const AArea: AxUCString;const AValue: integer);`
Fills an area with random numbers, from 0 to Value - 1. Usefull for test purpose. ˜param Ref The cell area as a string, like: A1:D9 ˜param Value Max random value - 1.

| `function AutoWidthCol(const ACol: integer): integer;`

| `procedure AutoWidthCols(const Col1,Col2: integer);`

| `function AutoHeightRow(const ARow: integer): boolean;`

| `function AutoHeightRows(const Row1,Row2: integer): boolean;`

| `procedure AutoSizeCell(const ACol,ARow: integer; const ASizeCol,ASizeRow: boolean);`

| `procedure UnfreezePanes;`
Removes frozen panes created with FreezePanes.

| `procedure FreezePanes(const AColumns,ARows: integer);`
Create frozen panes, that is, top rows and/or Left columns are locked. AColumns is the number of locked columns. Set to zero fo no locked columns. ARows is the number of locked rows. Set to zero fo no locked rows. Remove frozen panes with @linkt(UnfreezePanes).

| `procedure UnsplitPanes;`
Removes splitted panes created with SplitPanes.

| `procedure SplitPanes(const APointsWidth,APointsHeight: integer);`
Creates splitted panes. The width and height is in character points. Remove splitted panes with @linkt(UnsplitPanes).

| `procedure CalcDimensions;`
Calculate the dimensions of the worksheet. CalcDimensions will calculate the first and last, first and last column.

| `procedure CalcDimensionsEx;`
Calculate the dimensions of the worksheet. CalcDimensions will calculate the first and last, first and last column. Only cells with values are included. Cells with only formatting (blank) are excluded. Consider using CalcDimensions instead as CalcDimensionsEx id *MUCH* slower.

| `function Calculate(const ACol, ARow: integer): Variant;`

| `function CalculateEx(Col, Row: integer; CalculateOptions: boolean): Variant;`

| `function CalculateAsString(const ACol, ARow: integer): AxUCString;`

| `procedure CalculateSheet;`

| `procedure Calculated(const IsCalculated: boolean);`

| `procedure CopyCell(const ACol, ARow, ADestCol, ADestRow: integer);`

| `procedure CopyCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);`

| `procedure DeleteCell(const ACol, ARow: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);`

| `procedure DeleteCells(const ACol1, ARow1, ACol2, ARow2: integer; const AOptions: TXLSDeleteOptions = DefaultDeleteOptions);`

| `procedure ClearCell(const ACol, ARow: integer);`
Deletes just the cell values

| `procedure CelarCells(const ACol1, ARow1, ACol2, ARow2: integer);`

| `procedure MoveCell(const ACol, ARow, ADestCol, ADestRow: integer);`

| `procedure MoveCells(const ACol1, ARow1, ACol2, ARow2, ADestCol, ADestRow: integer; const ACopyOptions: TCopyCellsOptions = CopyAllCells);`

| `function MergeCells(Col1, Row1, Col2, Row2: integer): boolean;`

| `procedure DeleteRows(const ARow1,ARow2: integer);`
Deletes the rows between ARow1 and ARow2 and shiftes the rows below up. See also ClearRows.

| `procedure ClearRows(const ARow1,ARow2: integer);`
Deletes the rows between ARow1 and ARow2. See also DeleteRows.

| `procedure InsertRows(const ARow,ARowCount: integer);`

| `procedure CopyRows(const ARow1,ARow2,ADestRow: integer);`

| `procedure MoveRows(const ARow1,ARow2,ADestRow: integer);`

| `procedure DeleteColumns(const ACol1,ACol2: integer);`
Deletes the columns between ACol1 and ACol2 and shiftes the columns to the right left. See also ClearColumns.

| `procedure ClearColumns(const ACol1,ACol2: integer);`
Deletes the columns between ACol1 and ACol2. See also ClearColumns.

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

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

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

| `function IsEmpty: boolean;`

| `procedure Sort(const AAscending,ACaseSencitive: boolean); overload;`

| `procedure Sort(ACol1, ARow1, ACol2, ARow2: integer; const AAscending,ACaseSencitive: boolean); overload;`

| `procedure GroupRows(const ARow1,ARow2: integer; ACollapsed: boolean = False);`

| `procedure GroupColumns(const ACol1, ACol2: integer; ACollapsed: boolean = False);`

| `procedure RichTextLoadFromFile(const ACol, ARow: integer; const Filename: AxUCString; const AllText: boolean = True);`

| `procedure RichTextLoadFromStream(const ACol, ARow: integer; Stream: TStream; const AllText: boolean = True);`

| `procedure RichTextSaveToFile(const ACol, ARow: integer; const Filename: AxUCString);`

| `procedure RichTextSaveToStream(const ACol, ARow: integer; Stream: TStream);`

| `procedure CopyToRichEdit(const ACol,ARow: integer; var ARichEdit: TRichEdit);`

| `function FindCell(const ACol,ARow: integer): boolean;`

| `procedure BeginFindText;`

| `function FindText(const AText: AxUCString; CaseInsensitive: boolean = True): boolean;`

| `procedure GetFindData(var ACol,ARow,ATextPos: integer; var AText: AxUCString);`

| `function GetFormatString(ACell: TXLSCellItem; AColor: PLongword): AxUCString;`

| `procedure InsertFloatRowValues(const ACol,ARow: integer; const AValues: array of double); overload;`

| `procedure InsertStringRowValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;`

| `procedure InsertRowValues(const ACol,ARow: integer; const AValues: array of Variant); overload;`

| `procedure InsertFloatColValues(const ACol,ARow: integer; const AValues: array of double); overload;`

| `procedure InsertStringColValues(const ACol,ARow: integer; const AValues: array of AxUCString); overload;`

| `procedure InsertColValues(const ACol,ARow: integer; const AValues: array of Variant); overload;`

| `procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText: AxUCString); overload;`

| `procedure MakeHyperlink(const ACol,ARow: integer; const AAddress, AText,ATooltip: AxUCString); overload;`

| `procedure GetShapePixelSize(AShape: TXLSDrwTwoPosShape; out AWidth,AHeight: integer);`

| `procedure BeginIterate;`

| `function IterateNext: boolean;`

| `procedure IteratePos(out ACol,ARow: integer);`

| `function FirstCol: integer;`

| `function LastCol: integer;`

| `function FirstRow: integer;`

| `function LastRow: integer;`

### Properties

| `property LeftCol: integer read GetLeftCol write SetLeftCol;`

| `property TopRow: integer read GetTopRow write SetTopRow;`

| `property DefaultColWidth: integer read GetDefaultColWidth write SetDefaultColWidth;`

| `property DefaultRowHeight: integer read GetDefaultRowHeight write SetDefaultRowHeight;`

| `property AsBlank[Col,Row:integer]: boolean read GetAsBlank write SetAsBlank;`

| `property AsInteger[Col,Row:integer]: integer read GetAsInteger write SetAsInteger;`

| `property AsFloat[Col,Row:integer]: double read GetAsFloat write SetAsFloat;`

| `property AsDateTime[Col,Row:integer]: TDateTime read GetAsDateTime write SetAsDateTime;`

| `property AsString[Col,Row:integer]: AxUCString read GetAsString write SetAsString;`

| `property AsRichText[Col,Row:integer]: AxUCString read GetAsRichText write SetAsRichText;`

| `property AsSimpleTags[ACol,ARow:integer]: AxUCString read GetAsSimpleTags write SetAsSimpleTags;`
AsSimpleTags let you easily create formatted text with html-like tags. There are no end tags. A tag sets an option, and that option is used until a new tags replaces it. In order to write the "<", character, write an empty tag "<>" in the text. Example: 'Two <> one' The following tags can be uses: <b> Turn bold on. </b> Turn bold off. <i> Turn italic on. </i> Turn italic off. <u> Turn underline on. </u> Turn underline off. <f:Font name> Changes the font name. <s:nn> Changes the font size. Setting the size to zero sets the font size to the default size. <c:xxxxxx> Changes the font color. The value xxxxxx is the hexadecimal RGB color value. If xxxxxx is set to 'Auto', the default color will be used.

| `property AsFmtString[Col,Row:integer]: AxUCString read GetAsFmtString;`

| `property AsHyperlink[Col,Row:integer]: AxUCString read GetAsHyperlink write SetAsHyperlink;`

| `property AsHTML[Col,Row:integer]: AxUCString read GetAsHTML;`

| `property AsBoolean[Col,Row:integer]: boolean read GetAsBoolean write SetAsBoolean;`

| `property AsError[Col,Row:integer]: TXc12CellError read GetAsError write SetAsError;`

| `property AsVariant[Col,Row:integer]: Variant read GetAsVariant write SetAsVariant;`

| `property AsFormula[Col,Row:integer]: AxUCString read GetAsFormula write SetAsFormula;`

| `property AsNumFormulaValue[Col,Row:integer]: double read GetAsNumFormulaValue write SetAsNumFormulaValue;`

| `property AsStrFormulaValue[Col,Row:integer]: AxUCString read GetAsStrFormulaValue write SetAsStrFormulaValue;`

| `property AsBoolFormulaValue[Col,Row:integer]: boolean read GetAsBoolFormulaValue write SetAsBoolFormulaValue;`

| `property IsDateTime[Col,Row:integer]: boolean read GetIsDateTime;`

| `property AsBlankRef[constARef:AxUCString]: boolean read GetAsBlankRef write SetAsBlankRef;`

| `property AsIntegerRef[constARef:AxUCString]: integer read GetAsIntegerRef write SetAsIntegerRef;`

| `property AsFloatRef[constARef:AxUCString]: double read GetAsFloatRef write SetAsFloatRef;`

| `property AsDateTimeRef[constARef:AxUCString]: TDateTime read GetAsDateTimeRef write SetAsDateTimeRef;`

| `property AsStringRef[constARef:AxUCString]: AxUCString read GetAsStringRef write SetAsStringRef;`

| `property AsRichTextRef[constARef:AxUCString]: AxUCString read GetAsRichTextRef write SetAsRichTextRef;`

| `property AsSimpleTagsRef[constARef:AxUCString]: AxUCString read GetAsSimpleTagsRef write SetAsSimpleTagsRef;`

| `property AsFmtStringRef[constARef:AxUCString]: AxUCString read GetAsFmtStringRef;`

| `property AsHTMLRef[constARef:AxUCString]: AxUCString read GetAsHTMLRef;`

| `property AsBooleanRef[constARef:AxUCString]: boolean read GetAsBooleanRef write SetAsBooleanRef;`

| `property AsErrorRef[constARef:AxUCString]: TXc12CellError read GetAsErrorRef write SetAsErrorRef;`

| `property AsFormulaRef[constARef:AxUCString]: AxUCString read GetAsFormulaRef write SetAsFormulaRef;`

| `property AsNumFormulaValueRef[constARef:AxUCString]: double read GetAsNumFormulaValueRef write SetAsNumFormulaValueRef;`

| `property AsStrFormulaValueRef[constARef:AxUCString]: AxUCString read GetAsStrFormulaValueRef write SetAsStrFormulaValueRef;`

| `property AsBoolFormulaValueRef[constARef:AxUCString]: boolean read GetAsBoolFormulaValueRef write SetAsBoolFormulaValueRef;`

| `property AsVariantRef[constARef:AxUCString]: Variant read GetAsVariantRef write SetAsVariantRef;`

| `property Cell[Col,Row:integer]: TXLSCell read GetCell;`

| `property CellType[Col,Row:integer]: TXLSCellType read GetCellType;`

| `property FormulaType[Col,Row:integer]: TXLSCellFormulaType read GetFormulaType;`

| `property Rows: TXLSRows read GetRows;`

| `property Columns: TXLSColumns read GetColumns;`

| `property Autofilter: TXLSAutofilter read GetAutofilter;`

| `property Hyperlinks: TXLSHyperlinks read GetHyperlinks;`

| `property MergedCells: TXLSMergedCells read GetMergedCells;`

| `property ConditionalFormats: TXLSConditionalFormats read GetConditionalFormats;`

| `property Validations: TXLSDataValidations read GetValidations;`

| `property Comments: TXLSComments read FComments;`

| `property PrintSettings: TXLSPrintSettings read GetPrintSettings;`

| `property SelectedAreas: TXLSSelectedAreas read GetSelectedAreas;`

| `property VisibleAreas: TCellAreas read GetVisibleAreas;`

| `property Drawing: TXLSDrawing read GetDrawing;`

| `property Range: TXLSRange read FRange;`

| `property Pane: TXLSPane read GetPane;`

| `property Protection: TXLSSheetProtection read FProtection;`

| `property Name: AxUCString read GetName write SetName;`

| `property TabColor: longword read GetTabColor write SetTabColor;`

| `property Options: TXLSSheetOptions read GetOptions write SetOptions;`

| `property WorkspaceOptions: TWorkspaceOptions read GetWorkspaceOptions write SetWorkspaceOptions;`

| `property Zoom: integer read GetZoom write SetZoom;`

| `property ZoomPreview: integer read GetZoomPreview write SetZoomPreview;`

| `property RecalcFormulas: boolean read GetRecalcFormulas write SetRecalcFormulas;`

| `property Xc12Sheet: TXc12DataWorksheet read FXc12Sheet;`

| `property XSSCellInvalidateEvent: TXc12RefEvent read FXSSCellInvalidateEvent write FXSSCellInvalidateEvent;`

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