oovbaapi/ooo/vba/excel/XRange.idl

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