1/*************************************************************************
2 *
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * Copyright 2000, 2010 Oracle and/or its affiliates.
6 *
7 * OpenOffice.org - a multi-platform office productivity suite
8 *
9 * This file is part of OpenOffice.org.
10 *
11 * OpenOffice.org is free software: you can redistribute it and/or modify
12 * it under the terms of the GNU Lesser General Public License version 3
13 * only, as published by the Free Software Foundation.
14 *
15 * OpenOffice.org is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18 * GNU Lesser General Public License version 3 for more details
19 * (a copy is included in the LICENSE file that accompanied this code).
20 *
21 * You should have received a copy of the GNU Lesser General Public License
22 * version 3 along with OpenOffice.org.  If not, see
23 * <http://www.openoffice.org/license.html>
24 * for a copy of the LGPLv3 License.
25 *
26 ************************************************************************/
27#ifndef __ooo_vba_excel_XWorksheet_idl__
28#define __ooo_vba_excel_XWorksheet_idl__
29
30#ifndef __com_sun_star_uno_XInterface_idl__
31#include <com/sun/star/uno/XInterface.idl>
32#endif
33
34#ifndef __ooo_vba_XHelperInterface_idl__
35#include <ooo/vba/XHelperInterface.idl>
36#endif
37
38#ifndef __com_sun_star_script_XInvocation_idl__
39#include <com/sun/star/script/XInvocation.idl>
40#endif
41
42#ifndef __com_sun_star_container_XNamed_idl__
43#include <com/sun/star/container/XNamed.idl>
44#endif
45//=============================================================================
46
47module ooo {  module vba {  module excel {
48
49//=============================================================================
50
51interface XComments;
52interface XRange;
53interface XOutline;
54interface XPageSetup;
55interface XHPageBreaks;
56interface XVPageBreaks;
57interface XWorksheet
58{
59	interface ::ooo::vba::XHelperInterface;
60	interface ::com::sun::star::script::XInvocation;
61	interface ::com::sun::star::container::XNamed;
62
63	[attribute] long Visible;
64	[attribute, readonly] long StandardHeight;
65	[attribute, readonly] long StandardWidth;
66	[attribute, readonly] boolean ProtectionMode;
67	[attribute, readonly] boolean ProtectContents;
68	[attribute, readonly] boolean ProtectDrawingObjects;
69	[attribute, readonly] boolean ProtectScenarios;
70	[attribute, readonly] XRange UsedRange;
71	[attribute, readonly] XWorksheet Next;
72	[attribute, readonly] XWorksheet Previous;
73	[attribute, readonly] string CodeName;
74 	[attribute, readonly] short Index;
75 	[attribute] long EnableSelection;
76	[attribute] boolean AutoFilterMode;
77
78	void Activate();
79	void Calculate( );
80	void Select();
81	void Move([in] any Before,[in] any After );
82	void Copy([in] any Before,[in] any After );
83	void Paste([in] any Destination,[in] any Link);
84	void Delete( );
85	void Protect([in] any Password,[in] any DrawingObjects ,[in] any Contents,[in] any Scenarios,[in] any UserInterfaceOnly);
86	void Unprotect([in] any Password );
87	void CheckSpelling([in] any CustomDictionary,[in] any IgnoreUppercase, [in] any AlwaysSuggest,[in] any SpellingLang );
88	void ShowDataForm();
89
90	XRange Range([in] any Cell1, [in] any Cell2 );
91	any ChartObjects([in] any Index);
92	any PivotTables([in] any Index);
93	any Comments([in] any Index);
94	XOutline Outline();
95	XPageSetup PageSetup();
96	any HPageBreaks([in] any Index);
97	any VPageBreaks([in] any Index);
98	any OLEObjects([in] any Index);
99	any Shapes([in] any Index);
100
101    /*  The following form control related symbols do not refer to ActiveX form
102        controls embedded in the sheet, but to the old-style drawing controls
103        of Excel. This is an Excel-only feature. */
104    any Buttons( [in] any Index );
105    any CheckBoxes( [in] any Index );
106    any DropDowns( [in] any Index );
107    any GroupBoxes( [in] any Index );
108    any Labels( [in] any Index );
109    any ListBoxes( [in] any Index );
110    any OptionButtons( [in] any Index );
111    any ScrollBars( [in] any Index );
112    any Spinners( [in] any Index );
113
114// FIXME: should prolly inherit from Range somehow...
115	XRange Cells( [in] any RowIndex, [in] any ColumnIndex );
116	XRange Rows( [in] any Index );
117	XRange Columns( [in] any Index );
118    any Hyperlinks( [in] any Index );
119	any Names( [in] any Index );
120
121	any Evaluate( [in] string Name );
122
123	void setEnableCalculation( [in] boolean EnableCalculation ) raises(com::sun::star::script::BasicErrorException);
124	boolean getEnableCalculation() raises(com::sun::star::script::BasicErrorException);
125	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 );
126};
127
128//=============================================================================
129
130}; }; };
131
132#endif
133