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