Overview

Module

Use

Devguide

Index

Methods' Summary

Methods' Details

Attributes' Summary

Attributes' Details

---

:: 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

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

Attributes' Summary
Value
Formula
FormulaArray
FormulaR1C1
Count
Row
Column
Text
EntireRow
EntireColumn
Comment
MergeCells
NumberFormat
WrapText
Hidden
ColumnWidth
Width
Worksheet
RowHeight
Height

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;

Top of Page

---

Copyright © 2003 Sun Microsystems, Inc.