Overview

Module

Use

Devguide

Index

Methods' Summary

Methods' Details

Attributes' Summary

Attributes' Details

---

:: org :: openoffice :: vba ::

interface XWorksheet

---

Methods' Summary
Activate
Calculate
Select
Move
Copy
Paste
Delete
Protect
Unprotect
CheckSpelling
Range
ChartObjects
PivotTables
Comments
Outline
Cells
Rows
Columns
Evaluate

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

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

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

Rows XRange Rows( [in] any  aIndex );

Columns XRange Columns( [in] any  aIndex );

Evaluate any Evaluate( [in] string  Name );

Attributes' Summary
Name
Visible
StandardHeight
StandardWidth
ProtectionMode
ProtectContents
ProtectDrawingObjects
UsedRange
Next
Previous

Attributes' Details

Name string Name;

Visible boolean Visible;

StandardHeight [ readonly ] long StandardHeight;

StandardWidth [ readonly ] long StandardWidth;

ProtectionMode [ readonly ] boolean ProtectionMode;

ProtectContents [ readonly ] boolean ProtectContents;

ProtectDrawingObjects [ readonly ] boolean ProtectDrawingObjects;

UsedRange [ readonly ] XRange UsedRange;

Next [ readonly ] XWorksheet Next;

Previous [ readonly ] XWorksheet Previous;

Top of Page

---

Copyright © 2003 Sun Microsystems, Inc.