1*cdf0e10cSrcweir/************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir#ifndef __ooo_vba_excel_XRange_idl__ 28*cdf0e10cSrcweir#define __ooo_vba_excel_XRange_idl__ 29*cdf0e10cSrcweir 30*cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 31*cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 32*cdf0e10cSrcweir#endif 33*cdf0e10cSrcweir#ifndef __com_sun_star_lang_IllegalArgumentException_idl__ 34*cdf0e10cSrcweir#include <com/sun/star/lang/IllegalArgumentException.idl> 35*cdf0e10cSrcweir#endif 36*cdf0e10cSrcweir#ifndef __com_sun_star_container_XEnumerationAccess_idl__ 37*cdf0e10cSrcweir#include <com/sun/star/container/XEnumerationAccess.idl> 38*cdf0e10cSrcweir#endif 39*cdf0e10cSrcweir#ifndef __com_sun_star_script_XDefaultProperty_idl__ 40*cdf0e10cSrcweir#include <com/sun/star/script/XDefaultProperty.idl> 41*cdf0e10cSrcweir#endif 42*cdf0e10cSrcweir#ifndef __com_sun_star_script_XDefaultMethod_idl__ 43*cdf0e10cSrcweir#include <com/sun/star/script/XDefaultMethod.idl> 44*cdf0e10cSrcweir#endif 45*cdf0e10cSrcweir#ifndef __ooo_vba_XCollection_idl__ 46*cdf0e10cSrcweir#include <ooo/vba/XCollection.idl> 47*cdf0e10cSrcweir#endif 48*cdf0e10cSrcweir#ifndef __ooo_vba_excel_XFormat_idl__ 49*cdf0e10cSrcweir#include <ooo/vba/excel/XFormat.idl> 50*cdf0e10cSrcweir#endif 51*cdf0e10cSrcweir#ifndef __ooo_vba_XHelperInterface_idl__ 52*cdf0e10cSrcweir#include <ooo/vba/XHelperInterface.idl> 53*cdf0e10cSrcweir#endif 54*cdf0e10cSrcweir#ifndef __com_sun_star_helper_script_BasicErrorException_idl__ 55*cdf0e10cSrcweir#include <com/sun/star/script/BasicErrorException.idl> 56*cdf0e10cSrcweir#endif 57*cdf0e10cSrcweir//============================================================================= 58*cdf0e10cSrcweir 59*cdf0e10cSrcweirmodule ooo { module vba { module excel { 60*cdf0e10cSrcweir 61*cdf0e10cSrcweirinterface XFont; 62*cdf0e10cSrcweirinterface XRows; 63*cdf0e10cSrcweirinterface XColumns; 64*cdf0e10cSrcweirinterface XComment; 65*cdf0e10cSrcweir 66*cdf0e10cSrcweirinterface XInterior; 67*cdf0e10cSrcweirinterface XCharacters; 68*cdf0e10cSrcweirinterface XBorders; 69*cdf0e10cSrcweirinterface XValidation; 70*cdf0e10cSrcweirinterface XWorksheet; 71*cdf0e10cSrcweir 72*cdf0e10cSrcweirinterface XRange 73*cdf0e10cSrcweir{ 74*cdf0e10cSrcweir interface com::sun::star::container::XEnumerationAccess; 75*cdf0e10cSrcweir interface com::sun::star::script::XDefaultMethod; 76*cdf0e10cSrcweir interface com::sun::star::script::XDefaultProperty; 77*cdf0e10cSrcweir interface ::ooo::vba::excel::XFormat; 78*cdf0e10cSrcweir //interface ::ooo::vba::XHelperInterface; 79*cdf0e10cSrcweir 80*cdf0e10cSrcweir [attribute] any Value; 81*cdf0e10cSrcweir [attribute] any Formula; 82*cdf0e10cSrcweir [attribute] any FormulaArray; 83*cdf0e10cSrcweir [attribute] any FormulaR1C1; 84*cdf0e10cSrcweir [attribute, readonly] long Count; 85*cdf0e10cSrcweir [attribute, readonly] long Row; 86*cdf0e10cSrcweir [attribute, readonly] long Column; 87*cdf0e10cSrcweir [attribute, readonly] string Text; 88*cdf0e10cSrcweir [attribute, readonly] XRange EntireRow; 89*cdf0e10cSrcweir [attribute, readonly] XRange EntireColumn; 90*cdf0e10cSrcweir [attribute, readonly] XComment Comment; 91*cdf0e10cSrcweir [attribute] any Hidden; 92*cdf0e10cSrcweir [attribute] any ColumnWidth; 93*cdf0e10cSrcweir [attribute, readonly ] any Width; 94*cdf0e10cSrcweir [attribute, readonly] XWorksheet Worksheet; 95*cdf0e10cSrcweir [attribute] any RowHeight; 96*cdf0e10cSrcweir [attribute, readonly ] any Height; 97*cdf0e10cSrcweir [attribute, readonly ] any Top; 98*cdf0e10cSrcweir [attribute, readonly ] any Left; 99*cdf0e10cSrcweir [attribute] any PageBreak; 100*cdf0e10cSrcweir [attribute, readonly] XValidation Validation; 101*cdf0e10cSrcweir [attribute, readonly] any PrefixCharacter; 102*cdf0e10cSrcweir [attribute] any Style; 103*cdf0e10cSrcweir [attribute] any AddIndent; 104*cdf0e10cSrcweir [attribute] any ShowDetail; 105*cdf0e10cSrcweir 106*cdf0e10cSrcweir XComment AddComment( [in] any Text ); 107*cdf0e10cSrcweir void Clear(); 108*cdf0e10cSrcweir void ClearComments(); 109*cdf0e10cSrcweir void ClearContents(); 110*cdf0e10cSrcweir void ClearFormats(); 111*cdf0e10cSrcweir any HasFormula(); 112*cdf0e10cSrcweir void FillLeft(); 113*cdf0e10cSrcweir void FillRight(); 114*cdf0e10cSrcweir void FillUp(); 115*cdf0e10cSrcweir void FillDown(); 116*cdf0e10cSrcweir XRange Item([in] any RowIndex, [in] any ColumnIndex) raises(com::sun::star::script::BasicErrorException); 117*cdf0e10cSrcweir XRange Offset([in] any RowOffset, [in] any ColumnOffset); 118*cdf0e10cSrcweir XRange CurrentRegion(); 119*cdf0e10cSrcweir XRange CurrentArray(); 120*cdf0e10cSrcweir string Characters([in] any Start, [in] any Length); 121*cdf0e10cSrcweir string Address( [in] any RowAbsolute, [in] any ColumnAbsolute, [in] any ReferenceStyle, [in] any External, [in] any RelativeTo ); 122*cdf0e10cSrcweir XRange Cells([in] any RowIndex, [in] any ColumnIndex); 123*cdf0e10cSrcweir void Select(); 124*cdf0e10cSrcweir void AutoOutline() raises(com::sun::star::script::BasicErrorException); 125*cdf0e10cSrcweir void Activate(); 126*cdf0e10cSrcweir XRange Rows( [in] any RowIndex ); 127*cdf0e10cSrcweir void Calculate() raises(com::sun::star::script::BasicErrorException); 128*cdf0e10cSrcweir XRange Columns( [in] any ColumnIndex ); 129*cdf0e10cSrcweir void Copy([in] any Destination); 130*cdf0e10cSrcweir void Cut([in] any Destination); 131*cdf0e10cSrcweir XRange Resize( [in] any RowSize, [in] any ColumnSize ); 132*cdf0e10cSrcweir XRange Range( [in] any Cell1, [in] any Cell2 ); 133*cdf0e10cSrcweir any getCellRange(); 134*cdf0e10cSrcweir void PasteSpecial([in] any Paste, [in] any Operation,[in] any SkipBlanks, [in] any Transpose); 135*cdf0e10cSrcweir 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 ); 136*cdf0e10cSrcweir 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 ); 137*cdf0e10cSrcweir 138*cdf0e10cSrcweir void Sort( [in] any Key1, [in] any Order1, [in] any Key2, [in] any Type, 139*cdf0e10cSrcweir [in] any Order2, [in] any Key3, [in] any Order3, 140*cdf0e10cSrcweir [in] any Header, [in] any OrderCustom, [in] any MatchCase, 141*cdf0e10cSrcweir [in] any Orientation, [in] any SortMethod, [in] any DataOption1, 142*cdf0e10cSrcweir [in] any DataOption2, [in] any DataOption3 ); 143*cdf0e10cSrcweir XRange End( [in] long Direction ); 144*cdf0e10cSrcweir // bizarely I have to define Character method as character otherwise 145*cdf0e10cSrcweir // idl complains 146*cdf0e10cSrcweir XCharacters characters([in] any Start, [in] any Length); 147*cdf0e10cSrcweir void Delete( [in] any Shift ); 148*cdf0e10cSrcweir 149*cdf0e10cSrcweir any Areas( [in] any Item ); 150*cdf0e10cSrcweir any BorderAround( [in] any LineStyle, [in] any Weight, [in] any ColorIndex, [in] any Color ); 151*cdf0e10cSrcweir void AutoFilter([in ] any Field, [in] any Criteria1, [in] any Operator, [in] any Criteria2, [in] any VisibleDropDown); 152*cdf0e10cSrcweir void Insert([in] any Shift, [in] any CopyOrigin); 153*cdf0e10cSrcweir void Autofit(); 154*cdf0e10cSrcweir 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); 155*cdf0e10cSrcweir void AutoFill( [in] XRange Destination, [in] any Type ); 156*cdf0e10cSrcweir boolean GoalSeek( [in] any Goal, [in] XRange ChangingCell ); 157*cdf0e10cSrcweir void ClearOutline() raises(com::sun::star::script::BasicErrorException); 158*cdf0e10cSrcweir void Ungroup() raises(com::sun::star::script::BasicErrorException); 159*cdf0e10cSrcweir void Group() raises(com::sun::star::script::BasicErrorException); 160*cdf0e10cSrcweir void Merge([in] any Across) raises(com::sun::star::script::BasicErrorException); 161*cdf0e10cSrcweir void UnMerge() raises(com::sun::star::script::BasicErrorException); 162*cdf0e10cSrcweir XRange Next( ) raises ( com::sun::star::script::BasicErrorException ); 163*cdf0e10cSrcweir XRange Previous( ) raises ( com::sun::star::script::BasicErrorException ); 164*cdf0e10cSrcweir XRange SpecialCells( [in] any Type, [in] /*Optional*/ any Value ) raises ( com::sun::star::script::BasicErrorException ); 165*cdf0e10cSrcweir void RemoveSubtotal() raises ( com::sun::star::script::BasicErrorException ); 166*cdf0e10cSrcweir void Subtotal( [in] long GroupBy, [in] long Function, [in] /*Optional*/ sequence<long> TotalList, [in] /*Optional*/ any Replace, [in] /*Optional*/ any PageBreaks, [in] any SummaryBelowData ) raises ( com::sun::star::script::BasicErrorException ); 167*cdf0e10cSrcweir XRange MergeArea( ) raises ( com::sun::star::script::BasicErrorException ); 168*cdf0e10cSrcweir any Hyperlinks( [in] any Index ); 169*cdf0e10cSrcweir}; 170*cdf0e10cSrcweir 171*cdf0e10cSrcweir//============================================================================= 172*cdf0e10cSrcweir 173*cdf0e10cSrcweir}; }; }; 174*cdf0e10cSrcweir 175*cdf0e10cSrcweir#endif 176*cdf0e10cSrcweir 177*cdf0e10cSrcweir 178