:: ooo :: vba :: excel ::

interface XRange
Base Interfaces
XRange
┣ ::com::sun::star::container::XEnumerationAccess
┃ ┗ ::com::sun::star::container::XElementAccess
┣ ::com::sun::star::script::XDefaultMethod
┣ ::com::sun::star::script::XDefaultPropertyXFormat
   ┗ ::ooo::vba::XHelperInterface
      ┗ ::com::sun::star::lang::XServiceInfo

::com::sun::star::container::XEnumerationAccess
(referenced interface's summary:)
used to enumerate objects in a container which contains objects.
::com::sun::star::script::XDefaultMethod
(referenced interface's summary:)
An object supporting this interface indicates to interested parties or clients the name of the default method for this object.
::com::sun::star::script::XDefaultProperty
(referenced interface's summary:)
An object supporting this interface indicates to interested parties or clients the name of the default propery for this object.
XFormat

Methods' Summary
AddComment  
Clear  
ClearComments  
ClearContents  
ClearFormats  
HasFormula  
FillLeft  
FillRight  
FillUp  
FillDown  
Item  
Offset  
CurrentRegion  
CurrentArray  
Characters  
Address  
Cells  
Select  
AutoOutline  
Activate  
Rows  
Calculate  
Columns  
Copy  
Cut  
Resize  
Range  
getCellRange  
PasteSpecial  
Replace  
Find  
Sort  
End  
characters  
Delete  
Areas  
BorderAround  
AutoFilter  
Insert  
Autofit  
PrintOut  
AutoFill  
GoalSeek  
ClearOutline  
Ungroup  
Group  
Merge  
UnMerge  
Next  
Previous  
SpecialCells  
RemoveSubtotal  
Subtotal  
MergeArea  
Hyperlinks  
Attributes' Summary
Value  
Formula  
FormulaArray  
FormulaR1C1  
Count  
Row  
Column  
Text  
EntireRow  
EntireColumn  
Comment  
Hidden  
ColumnWidth  
Width  
Worksheet  
RowHeight  
Height  
Top  
Left  
PageBreak  
Validation  
PrefixCharacter  
Style  
AddIndent  
ShowDetail  
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();

Item
XRange
Item( [in] any  row,
[in] any  column )
raises( ::com::sun::star::script::BasicErrorException );

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();

AutoOutline
void
AutoOutline()
raises( ::com::sun::star::script::BasicErrorException );

Activate
void
Activate();

Rows
XRange
Rows( [in] any  RowIndex );

Calculate
void
Calculate()
raises( ::com::sun::star::script::BasicErrorException );

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

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

Find
XRange
Find( [in] any  What,
[in] any  After,
[in] any  LookIn,
[in] any  LookAt,
[in] any  SearchOrder,
[in] any  SearchDirection,
[in] any  MatchCase,
[in] any  MatchByte,
[in] any  SearchFormat );

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

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

GoalSeek
boolean
GoalSeek( [in] any  Goal,
[in] XRange  ChangingCell );

ClearOutline
void
ClearOutline()
raises( ::com::sun::star::script::BasicErrorException );

Ungroup
void
Ungroup()
raises( ::com::sun::star::script::BasicErrorException );

Group
void
Group()
raises( ::com::sun::star::script::BasicErrorException );

Merge
void
Merge( [in] any  Across )
raises( ::com::sun::star::script::BasicErrorException );

UnMerge
void
UnMerge()
raises( ::com::sun::star::script::BasicErrorException );

Next
XRange
Next()
raises( ::com::sun::star::script::BasicErrorException );

Previous
XRange
Previous()
raises( ::com::sun::star::script::BasicErrorException );

SpecialCells
XRange
SpecialCells( [in] any  Type,
[in] any  Value )
raises( ::com::sun::star::script::BasicErrorException );

RemoveSubtotal
void
RemoveSubtotal()
raises( ::com::sun::star::script::BasicErrorException );

Subtotal
void
Subtotal( [in] long  GroupBy,
[in] long  Function,
[in] sequence< long >  TotalList,
[in] any  Replace,
[in] any  PageBreaks,
[in] any  SummaryBelowData )
raises( ::com::sun::star::script::BasicErrorException );

MergeArea
XRange
MergeArea()
raises( ::com::sun::star::script::BasicErrorException );

Hyperlinks
any
Hyperlinks( [in] any  aIndex );

Attributes' Details
Value
any Value;
Formula
any Formula;
FormulaArray
any FormulaArray;
FormulaR1C1
any FormulaR1C1;
Count
[ readonly ] long 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;
Hidden
any Hidden;
ColumnWidth
any ColumnWidth;
Width
[ readonly ] any Width;
Worksheet
[ readonly ] XWorksheet Worksheet;
RowHeight
any RowHeight;
Height
[ readonly ] any Height;
Top
[ readonly ] any Top;
Left
[ readonly ] any Left;
PageBreak
any PageBreak;
Validation
[ readonly ] XValidation Validation;
PrefixCharacter
[ readonly ] any PrefixCharacter;
Style
any Style;
AddIndent
any AddIndent;
ShowDetail
any ShowDetail;
Top of Page