| Methods' Details |
| AddComment
|
| Clear
|
| ClearComments
|
| ClearContents
|
| ClearFormats
|
| HasFormula
|
| FillLeft
|
| FillRight
|
| FillUp
|
| FillDown
|
| Item
|
Offset
| XRange |
| Offset( |
[in] any |
RowOffset, |
| [in] any |
ColumnOffset ); |
|
|
| CurrentRegion
|
| 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
|
| AutoOutline
|
| Activate
|
Rows
| XRange |
| Rows( |
[in] any |
RowIndex ); |
|
|
| Calculate
|
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
|
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
|
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
|
| Ungroup
|
| Group
|
| Merge
|
| UnMerge
|
| Next
|
| Previous
|
| SpecialCells
|
| RemoveSubtotal
|
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
|
Hyperlinks
| any |
| Hyperlinks( |
[in] any |
aIndex ); |
|
|
Copyright © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.