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