:: ooo :: vba :: excel ::

interface XWorksheet
Base Interfaces
XWorksheet
┣ ::ooo::vba::XHelperInterface
┃ ┗ ::com::sun::star::lang::XServiceInfo
┣ ::com::sun::star::script::XInvocation
┗ ::com::sun::star::container::XNamed

::ooo::vba::XHelperInterface
::com::sun::star::script::XInvocation
(referenced interface's summary:)
gives access to an object's methods and properties. Container access is available through ::com::sun::star::container::XIndexContainer, ::com::sun::star::container::XNameContainer and ::com::sun::star::container::XEnumerationAccess.

::com::sun::star::container::XNamed
(referenced interface's summary:)
specifies the name of the object.

Methods' Summary
Activate  
Calculate  
Select  
Move  
Copy  
Paste  
Delete  
Protect  
Unprotect  
CheckSpelling  
ShowDataForm  
Range  
ChartObjects  
PivotTables  
Comments  
Outline  
PageSetup  
HPageBreaks  
VPageBreaks  
OLEObjects  
Shapes  
Buttons  
CheckBoxes  
DropDowns  
GroupBoxes  
Labels  
ListBoxes  
OptionButtons  
ScrollBars  
Spinners  
Cells  
Rows  
Columns  
Hyperlinks  
Names  
Evaluate  
setEnableCalculation  
getEnableCalculation  
PrintOut  
Attributes' Summary
Visible  
StandardHeight  
StandardWidth  
ProtectionMode  
ProtectContents  
ProtectDrawingObjects  
ProtectScenarios  
UsedRange  
Next  
Previous  
CodeName  
Index  
EnableSelection  
AutoFilterMode  
Methods' Details
Activate
void
Activate();

Calculate
void
Calculate();

Select
void
Select();

Move
void
Move( [in] any  Before,
[in] any  After );

Copy
void
Copy( [in] any  Before,
[in] any  After );

Paste
void
Paste( [in] any  Destination,
[in] any  Link );

Delete
void
Delete();

Protect
void
Protect( [in] any  Password,
[in] any  DrawingObjects,
[in] any  Contents,
[in] any  Scenarios,
[in] any  UserInterfaceOnly );

Unprotect
void
Unprotect( [in] any  Password );

CheckSpelling
void
CheckSpelling( [in] any  CustomDictionary,
[in] any  IgnoreUppercase,
[in] any  AlwaysSuggest,
[in] any  SpellingLang );

ShowDataForm
void
ShowDataForm();

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

ChartObjects
any
ChartObjects( [in] any  Index );

PivotTables
any
PivotTables( [in] any  Index );

Comments
any
Comments( [in] any  Index );

Outline
XOutline
Outline();

PageSetup
XPageSetup
PageSetup();

HPageBreaks
any
HPageBreaks( [in] any  Index );

VPageBreaks
any
VPageBreaks( [in] any  Index );

OLEObjects
any
OLEObjects( [in] any  Index );

Shapes
any
Shapes( [in] any  Index );

Buttons
any
Buttons( [in] any  aIndex );

CheckBoxes
any
CheckBoxes( [in] any  aIndex );

DropDowns
any
DropDowns( [in] any  aIndex );

GroupBoxes
any
GroupBoxes( [in] any  aIndex );

Labels
any
Labels( [in] any  aIndex );

ListBoxes
any
ListBoxes( [in] any  aIndex );

OptionButtons
any
OptionButtons( [in] any  aIndex );

ScrollBars
any
ScrollBars( [in] any  aIndex );

Spinners
any
Spinners( [in] any  aIndex );

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

Rows
XRange
Rows( [in] any  aIndex );

Columns
XRange
Columns( [in] any  aIndex );

Hyperlinks
any
Hyperlinks( [in] any  aIndex );

Names
any
Names( [in] any  Index );

Evaluate
any
Evaluate( [in] string  Name );

setEnableCalculation
void
setEnableCalculation( [in] boolean  EnableCalculation )
raises( ::com::sun::star::script::BasicErrorException );

getEnableCalculation
boolean
getEnableCalculation()
raises( ::com::sun::star::script::BasicErrorException );

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,
[in] any  IgnorePrintAreas );

Attributes' Details
Visible
boolean Visible;
StandardHeight
[ readonly ] long StandardHeight;
StandardWidth
[ readonly ] long StandardWidth;
ProtectionMode
[ readonly ] boolean ProtectionMode;
ProtectContents
[ readonly ] boolean ProtectContents;
ProtectDrawingObjects
[ readonly ] boolean ProtectDrawingObjects;
ProtectScenarios
[ readonly ] boolean ProtectScenarios;
UsedRange
[ readonly ] XRange UsedRange;
Next
[ readonly ] XWorksheet Next;
Previous
[ readonly ] XWorksheet Previous;
CodeName
[ readonly ] string CodeName;
Index
[ readonly ] short Index;
EnableSelection
long EnableSelection;
AutoFilterMode
boolean AutoFilterMode;
Top of Page