:: org :: openoffice :: vba ::

interface XRange

Methods' Summary
Clear  
ClearComments  
ClearContents  
ClearFormats  
HasFormula  
FillLeft  
FillRight  
FillUp  
FillDown  
Offset  
CurrentRegion  
CurrentArray  
Characters  
Address  
Cells  
Select  
Activate  
Rows  
Columns  
Copy  
Cut  
Resize  
Font  
Interior  
Range  
getCellRange  
PasteSpecial  
Replace  
Sort  
End  
characters  
Delete  
Areas  
Borders  
Methods' Details
Clear
void
Clear();

ClearComments
void
ClearComments();

ClearContents
void
ClearContents();

ClearFormats
void
ClearFormats();

HasFormula
boolean
HasFormula();

FillLeft
void
FillLeft();

FillRight
void
FillRight();

FillUp
void
FillUp();

FillDown
void
FillDown();

Offset
XRange
Offset( [in] any  RowOffset,
[in] any  ColumnOffset );

CurrentRegion
XRange
CurrentRegion();

CurrentArray
XRange
CurrentArray();

Characters
string
Characters( [in] any  Start,
[in] any  Length );

Address
string
Address( [in] any  RowAbsolute,
[in] any  ColumnAbsolute,
[in] any  ReferenceStyle,
[in] any  External,
[in] any  RelativeTo );

Cells
XRange
Cells( [in] any  RowIndex,
[in] any  ColumnIndex );

Select
void
Select();

Activate
void
Activate();

Rows
XRange
Rows( [in] any  RowIndex );

Columns
XRange
Columns( [in] any  ColumnIndex );

Copy
void
Copy( [in] any  Destination );

Cut
void
Cut( [in] any  Destination );

Resize
XRange
Resize( [in] any  RowSize,
[in] any  ColumnSize );

Font
XFont
Font();

Interior
XInterior
Interior();

Range
XRange
Range( [in] any  Cell1,
[in] any  Cell2 );

getCellRange
any
getCellRange();

PasteSpecial
void
PasteSpecial( [in] any  Paste,
[in] any  Operation,
[in] any  SkipBlanks,
[in] any  Transpose );

Replace
boolean
Replace( [in] string  What,
[in] string  Replacement,
[in] any  LookAt,
[in] any  SearchOrder,
[in] any  MatchCase,
[in] any  MatchByte,
[in] any  SearchFormat,
[in] any  ReplaceFormat );

Sort
void
Sort( [in] any  Key1,
[in] any  Order1,
[in] any  Key2,
[in] any  Type,
[in] any  Order2,
[in] any  Key3,
[in] any  Order3,
[in] any  Header,
[in] any  OrderCustom,
[in] any  MatchCase,
[in] any  Orientation,
[in] any  SortMethod,
[in] any  DataOption1,
[in] any  DataOption2,
[in] any  DataOption3 );

End
XRange
End( [in] long  Direction );

characters
XCharacters
characters( [in] any  Start,
[in] any  Length );

Delete
void
Delete( [in] any  Shift );

Areas
any
Areas( [in] any  item );

Borders
any
Borders( [in] any  item );

Attributes' Summary
Value  
Formula  
FormulaR1C1  
Count  
Row  
Column  
Text  
EntireRow  
EntireColumn  
Comment  
FormulaArray  
MergeCells  
NumberFormat  
WrapText  
Hidden  
ColumnWidth  
Width  
RowHeight  
Height  
Attributes' Details
Value
any Value;
Formula
any Formula;
FormulaR1C1
any FormulaR1C1;
Count
[ readonly ] double Count;
Row
[ readonly ] long Row;
Column
[ readonly ] long Column;
Text
[ readonly ] string Text;
EntireRow
[ readonly ] XRange EntireRow;
EntireColumn
[ readonly ] XRange EntireColumn;
Comment
[ readonly ] XComment Comment;
FormulaArray
string FormulaArray;
MergeCells
boolean MergeCells;
NumberFormat
string NumberFormat;
WrapText
boolean WrapText;
Hidden
any Hidden;
ColumnWidth
any ColumnWidth;
Width
[ readonly ] any Width;
RowHeight
any RowHeight;
Height
[ readonly ] any Height;
Top of Page