:: org :: openoffice :: vba ::

interface XRange

Methods' Summary
AddComment  
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  
BorderAround  
AutoFilter  
Insert  
Autofit  
PrintOut  
AutoFill  
Methods' Details
AddComment
XComment
AddComment( [in] any  Text );

Clear
void
Clear();

ClearComments
void
ClearComments();

ClearContents
void
ClearContents();

ClearFormats
void
ClearFormats();

HasFormula
any
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 );

BorderAround
any
BorderAround( [in] any  LineStyle,
[in] any  Weight,
[in] any  ColorIndex,
[in] any  Color );

AutoFilter
void
AutoFilter( [in] any  Field,
[in] any  Criteria1,
[in] any  Operator,
[in] any  Criteria2,
[in] any  VisibleDropDown );

Insert
void
Insert( [in] any  Shift,
[in] any  CopyOrigin );

Autofit
void
Autofit();

PrintOut
void
PrintOut( [in] any  From,
[in] any  To,
[in] any  Copies,
[in] any  Preview,
[in] any  ActivePrinter,
[in] any  PrintToFile,
[in] any  Collate,
[in] any  PrToFileName );

AutoFill
void
AutoFill( [in] XRange  Destination,
[in] any  Type );

Attributes' Summary
Value  
Formula  
FormulaArray  
FormulaR1C1  
Count  
Row  
Column  
Text  
EntireRow  
EntireColumn  
Comment  
MergeCells  
NumberFormat  
WrapText  
Hidden  
ColumnWidth  
Width  
Worksheet  
RowHeight  
Height  
PageBreak  
Validation  
Attributes' Details
Value
any Value;
Formula
any Formula;
FormulaArray
any FormulaArray;
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;
MergeCells
boolean MergeCells;
NumberFormat
any NumberFormat;
WrapText
any WrapText;
Hidden
any Hidden;
ColumnWidth
any ColumnWidth;
Width
[ readonly ] any Width;
Worksheet
[ readonly ] XWorksheet Worksheet;
RowHeight
any RowHeight;
Height
[ readonly ] any Height;
PageBreak
any PageBreak;
Validation
[ readonly ] XValidation Validation;
Top of Page