1*b1cdbd2cSJim Jagielski/************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski#ifndef __ooo_vba_excel_XRange_idl__ 24*b1cdbd2cSJim Jagielski#define __ooo_vba_excel_XRange_idl__ 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_uno_XInterface_idl__ 27*b1cdbd2cSJim Jagielski#include <com/sun/star/uno/XInterface.idl> 28*b1cdbd2cSJim Jagielski#endif 29*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_lang_IllegalArgumentException_idl__ 30*b1cdbd2cSJim Jagielski#include <com/sun/star/lang/IllegalArgumentException.idl> 31*b1cdbd2cSJim Jagielski#endif 32*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_container_XEnumerationAccess_idl__ 33*b1cdbd2cSJim Jagielski#include <com/sun/star/container/XEnumerationAccess.idl> 34*b1cdbd2cSJim Jagielski#endif 35*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_script_XDefaultProperty_idl__ 36*b1cdbd2cSJim Jagielski#include <com/sun/star/script/XDefaultProperty.idl> 37*b1cdbd2cSJim Jagielski#endif 38*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_script_XDefaultMethod_idl__ 39*b1cdbd2cSJim Jagielski#include <com/sun/star/script/XDefaultMethod.idl> 40*b1cdbd2cSJim Jagielski#endif 41*b1cdbd2cSJim Jagielski#ifndef __ooo_vba_XCollection_idl__ 42*b1cdbd2cSJim Jagielski#include <ooo/vba/XCollection.idl> 43*b1cdbd2cSJim Jagielski#endif 44*b1cdbd2cSJim Jagielski#ifndef __ooo_vba_excel_XFormat_idl__ 45*b1cdbd2cSJim Jagielski#include <ooo/vba/excel/XFormat.idl> 46*b1cdbd2cSJim Jagielski#endif 47*b1cdbd2cSJim Jagielski#ifndef __ooo_vba_XHelperInterface_idl__ 48*b1cdbd2cSJim Jagielski#include <ooo/vba/XHelperInterface.idl> 49*b1cdbd2cSJim Jagielski#endif 50*b1cdbd2cSJim Jagielski#ifndef __com_sun_star_helper_script_BasicErrorException_idl__ 51*b1cdbd2cSJim Jagielski#include <com/sun/star/script/BasicErrorException.idl> 52*b1cdbd2cSJim Jagielski#endif 53*b1cdbd2cSJim Jagielski//============================================================================= 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielskimodule ooo { module vba { module excel { 56*b1cdbd2cSJim Jagielski 57*b1cdbd2cSJim Jagielskiinterface XFont; 58*b1cdbd2cSJim Jagielskiinterface XRows; 59*b1cdbd2cSJim Jagielskiinterface XColumns; 60*b1cdbd2cSJim Jagielskiinterface XComment; 61*b1cdbd2cSJim Jagielski 62*b1cdbd2cSJim Jagielskiinterface XInterior; 63*b1cdbd2cSJim Jagielskiinterface XCharacters; 64*b1cdbd2cSJim Jagielskiinterface XBorders; 65*b1cdbd2cSJim Jagielskiinterface XValidation; 66*b1cdbd2cSJim Jagielskiinterface XWorksheet; 67*b1cdbd2cSJim Jagielski 68*b1cdbd2cSJim Jagielskiinterface XRange 69*b1cdbd2cSJim Jagielski{ 70*b1cdbd2cSJim Jagielski interface com::sun::star::container::XEnumerationAccess; 71*b1cdbd2cSJim Jagielski interface com::sun::star::script::XDefaultMethod; 72*b1cdbd2cSJim Jagielski interface com::sun::star::script::XDefaultProperty; 73*b1cdbd2cSJim Jagielski interface ::ooo::vba::excel::XFormat; 74*b1cdbd2cSJim Jagielski //interface ::ooo::vba::XHelperInterface; 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski [attribute] any Value; 77*b1cdbd2cSJim Jagielski [attribute] any Formula; 78*b1cdbd2cSJim Jagielski [attribute] any FormulaArray; 79*b1cdbd2cSJim Jagielski [attribute] any FormulaR1C1; 80*b1cdbd2cSJim Jagielski [attribute, readonly] long Count; 81*b1cdbd2cSJim Jagielski [attribute, readonly] long Row; 82*b1cdbd2cSJim Jagielski [attribute, readonly] long Column; 83*b1cdbd2cSJim Jagielski [attribute, readonly] string Text; 84*b1cdbd2cSJim Jagielski [attribute, readonly] XRange EntireRow; 85*b1cdbd2cSJim Jagielski [attribute, readonly] XRange EntireColumn; 86*b1cdbd2cSJim Jagielski [attribute, readonly] XComment Comment; 87*b1cdbd2cSJim Jagielski [attribute] any Hidden; 88*b1cdbd2cSJim Jagielski [attribute] any ColumnWidth; 89*b1cdbd2cSJim Jagielski [attribute, readonly ] any Width; 90*b1cdbd2cSJim Jagielski [attribute, readonly] XWorksheet Worksheet; 91*b1cdbd2cSJim Jagielski [attribute] any RowHeight; 92*b1cdbd2cSJim Jagielski [attribute, readonly ] any Height; 93*b1cdbd2cSJim Jagielski [attribute, readonly ] any Top; 94*b1cdbd2cSJim Jagielski [attribute, readonly ] any Left; 95*b1cdbd2cSJim Jagielski [attribute] any PageBreak; 96*b1cdbd2cSJim Jagielski [attribute, readonly] XValidation Validation; 97*b1cdbd2cSJim Jagielski [attribute, readonly] any PrefixCharacter; 98*b1cdbd2cSJim Jagielski [attribute] any Style; 99*b1cdbd2cSJim Jagielski [attribute] any AddIndent; 100*b1cdbd2cSJim Jagielski [attribute] any ShowDetail; 101*b1cdbd2cSJim Jagielski 102*b1cdbd2cSJim Jagielski XComment AddComment( [in] any Text ); 103*b1cdbd2cSJim Jagielski void Clear(); 104*b1cdbd2cSJim Jagielski void ClearComments(); 105*b1cdbd2cSJim Jagielski void ClearContents(); 106*b1cdbd2cSJim Jagielski void ClearFormats(); 107*b1cdbd2cSJim Jagielski any HasFormula(); 108*b1cdbd2cSJim Jagielski void FillLeft(); 109*b1cdbd2cSJim Jagielski void FillRight(); 110*b1cdbd2cSJim Jagielski void FillUp(); 111*b1cdbd2cSJim Jagielski void FillDown(); 112*b1cdbd2cSJim Jagielski XRange Item([in] any RowIndex, [in] any ColumnIndex) raises(com::sun::star::script::BasicErrorException); 113*b1cdbd2cSJim Jagielski XRange Offset([in] any RowOffset, [in] any ColumnOffset); 114*b1cdbd2cSJim Jagielski XRange CurrentRegion(); 115*b1cdbd2cSJim Jagielski XRange CurrentArray(); 116*b1cdbd2cSJim Jagielski string Characters([in] any Start, [in] any Length); 117*b1cdbd2cSJim Jagielski string Address( [in] any RowAbsolute, [in] any ColumnAbsolute, [in] any ReferenceStyle, [in] any External, [in] any RelativeTo ); 118*b1cdbd2cSJim Jagielski XRange Cells([in] any RowIndex, [in] any ColumnIndex); 119*b1cdbd2cSJim Jagielski void Select(); 120*b1cdbd2cSJim Jagielski void AutoOutline() raises(com::sun::star::script::BasicErrorException); 121*b1cdbd2cSJim Jagielski void Activate(); 122*b1cdbd2cSJim Jagielski XRange Rows( [in] any RowIndex ); 123*b1cdbd2cSJim Jagielski void Calculate() raises(com::sun::star::script::BasicErrorException); 124*b1cdbd2cSJim Jagielski XRange Columns( [in] any ColumnIndex ); 125*b1cdbd2cSJim Jagielski void Copy([in] any Destination); 126*b1cdbd2cSJim Jagielski void Cut([in] any Destination); 127*b1cdbd2cSJim Jagielski XRange Resize( [in] any RowSize, [in] any ColumnSize ); 128*b1cdbd2cSJim Jagielski XRange Range( [in] any Cell1, [in] any Cell2 ); 129*b1cdbd2cSJim Jagielski any getCellRange(); 130*b1cdbd2cSJim Jagielski void PasteSpecial([in] any Paste, [in] any Operation,[in] any SkipBlanks, [in] any Transpose); 131*b1cdbd2cSJim Jagielski 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 ); 132*b1cdbd2cSJim Jagielski 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 ); 133*b1cdbd2cSJim Jagielski 134*b1cdbd2cSJim Jagielski void Sort( [in] any Key1, [in] any Order1, [in] any Key2, [in] any Type, 135*b1cdbd2cSJim Jagielski [in] any Order2, [in] any Key3, [in] any Order3, 136*b1cdbd2cSJim Jagielski [in] any Header, [in] any OrderCustom, [in] any MatchCase, 137*b1cdbd2cSJim Jagielski [in] any Orientation, [in] any SortMethod, [in] any DataOption1, 138*b1cdbd2cSJim Jagielski [in] any DataOption2, [in] any DataOption3 ); 139*b1cdbd2cSJim Jagielski XRange End( [in] long Direction ); 140*b1cdbd2cSJim Jagielski // bizarely I have to define Character method as character otherwise 141*b1cdbd2cSJim Jagielski // idl complains 142*b1cdbd2cSJim Jagielski XCharacters characters([in] any Start, [in] any Length); 143*b1cdbd2cSJim Jagielski void Delete( [in] any Shift ); 144*b1cdbd2cSJim Jagielski 145*b1cdbd2cSJim Jagielski any Areas( [in] any Item ); 146*b1cdbd2cSJim Jagielski any BorderAround( [in] any LineStyle, [in] any Weight, [in] any ColorIndex, [in] any Color ); 147*b1cdbd2cSJim Jagielski void AutoFilter([in ] any Field, [in] any Criteria1, [in] any Operator, [in] any Criteria2, [in] any VisibleDropDown); 148*b1cdbd2cSJim Jagielski void Insert([in] any Shift, [in] any CopyOrigin); 149*b1cdbd2cSJim Jagielski void Autofit(); 150*b1cdbd2cSJim Jagielski 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); 151*b1cdbd2cSJim Jagielski void AutoFill( [in] XRange Destination, [in] any Type ); 152*b1cdbd2cSJim Jagielski boolean GoalSeek( [in] any Goal, [in] XRange ChangingCell ); 153*b1cdbd2cSJim Jagielski void ClearOutline() raises(com::sun::star::script::BasicErrorException); 154*b1cdbd2cSJim Jagielski void Ungroup() raises(com::sun::star::script::BasicErrorException); 155*b1cdbd2cSJim Jagielski void Group() raises(com::sun::star::script::BasicErrorException); 156*b1cdbd2cSJim Jagielski void Merge([in] any Across) raises(com::sun::star::script::BasicErrorException); 157*b1cdbd2cSJim Jagielski void UnMerge() raises(com::sun::star::script::BasicErrorException); 158*b1cdbd2cSJim Jagielski XRange Next( ) raises ( com::sun::star::script::BasicErrorException ); 159*b1cdbd2cSJim Jagielski XRange Previous( ) raises ( com::sun::star::script::BasicErrorException ); 160*b1cdbd2cSJim Jagielski XRange SpecialCells( [in] any Type, [in] /*Optional*/ any Value ) raises ( com::sun::star::script::BasicErrorException ); 161*b1cdbd2cSJim Jagielski void RemoveSubtotal() raises ( com::sun::star::script::BasicErrorException ); 162*b1cdbd2cSJim Jagielski 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 ); 163*b1cdbd2cSJim Jagielski XRange MergeArea( ) raises ( com::sun::star::script::BasicErrorException ); 164*b1cdbd2cSJim Jagielski any Hyperlinks( [in] any Index ); 165*b1cdbd2cSJim Jagielski}; 166*b1cdbd2cSJim Jagielski 167*b1cdbd2cSJim Jagielski//============================================================================= 168*b1cdbd2cSJim Jagielski 169*b1cdbd2cSJim Jagielski}; }; }; 170*b1cdbd2cSJim Jagielski 171*b1cdbd2cSJim Jagielski#endif 172*b1cdbd2cSJim Jagielski 173*b1cdbd2cSJim Jagielski 174