oovbaapi/ooo/vba/excel/XWorksheet.idl

   1 /*
   2  * This file is part of the LibreOffice project.
   3  *
   4  * This Source Code Form is subject to the terms of the Mozilla Public
   5  * License, v. 2.0. If a copy of the MPL was not distributed with this
   6  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7  *
   8  * This file incorporates work covered by the following license notice:
   9  *
  10  *   Licensed to the Apache Software Foundation (ASF) under one or more
  11  *   contributor license agreements. See the NOTICE file distributed
  12  *   with this work for additional information regarding copyright
  13  *   ownership. The ASF licenses this file to you under the Apache
  14  *   License, Version 2.0 (the "License"); you may not use this file
  15  *   except in compliance with the License. You may obtain a copy of
  16  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  17  */
  18 #ifndef __ooo_vba_excel_XWorksheet_idl__
  19 #define __ooo_vba_excel_XWorksheet_idl__
  20
  21 #include <com/sun/star/lang/XUnoTunnel.idl>
  22 #include <ooo/vba/XHelperInterface.idl>
  23 #include <com/sun/star/script/XInvocation.idl>
  24 #include <com/sun/star/container/XNamed.idl>
  25
  26 //=============================================================================
  27
  28 module ooo {  module vba {  module excel {
  29
  30 //=============================================================================
  31
  32 interface XComments;
  33 interface XRange;
  34 interface XOutline;
  35 interface XPageSetup;
  36 interface XHPageBreaks;
  37 interface XVPageBreaks;
  38 interface XWorksheet
  39 {
  40     interface ::ooo::vba::XHelperInterface;
  41     interface ::com::sun::star::script::XInvocation;
  42     interface ::com::sun::star::container::XNamed;
  43     interface ::com::sun::star::lang::XUnoTunnel;
  44
  45     [attribute] long Visible;
  46     [attribute, readonly] long StandardHeight;
  47     [attribute, readonly] long StandardWidth;
  48     [attribute, readonly] boolean ProtectionMode;
  49     [attribute, readonly] boolean ProtectContents;
  50     [attribute, readonly] boolean ProtectDrawingObjects;
  51     [attribute, readonly] boolean ProtectScenarios;
  52     [attribute, readonly] XRange UsedRange;
  53     [attribute, readonly] XWorksheet Next;
  54     [attribute, readonly] XWorksheet Previous;
  55     [attribute, readonly] string CodeName;
  56     [attribute, readonly] short Index;
  57     [attribute] long EnableSelection;
  58     [attribute] boolean AutoFilterMode;
  59
  60     void Activate();
  61     void Calculate();
  62     void Select();
  63     void Move([in] any Before,[in] any After );
  64     void Copy([in] any Before,[in] any After );
  65     void Paste([in] any Destination,[in] any Link);
  66     void Delete();
  67     void Protect([in] any Password,[in] any DrawingObjects ,[in] any Contents,[in] any Scenarios,[in] any UserInterfaceOnly);
  68     void Unprotect([in] any Password );
  69     void CheckSpelling([in] any CustomDictionary,[in] any IgnoreUppercase, [in] any AlwaysSuggest,[in] any SpellingLang );
  70     void ShowDataForm();
  71
  72     XRange Range([in] any Cell1, [in] any Cell2 );
  73     any ChartObjects([in] any Index);
  74     any PivotTables([in] any Index);
  75     any Comments([in] any Index);
  76     XOutline Outline();
  77     XPageSetup PageSetup();
  78     any HPageBreaks([in] any Index);
  79     any VPageBreaks([in] any Index);
  80     any OLEObjects([in] any Index);
  81     any Shapes([in] any Index);
  82
  83     /*  The following form control related symbols do not refer to ActiveX form
  84         controls embedded in the sheet, but to the old-style drawing controls
  85         of Excel. This is an Excel-only feature. */
  86     any Buttons( [in] any Index );
  87     any CheckBoxes( [in] any Index );
  88     any DropDowns( [in] any Index );
  89     any GroupBoxes( [in] any Index );
  90     any Labels( [in] any Index );
  91     any ListBoxes( [in] any Index );
  92     any OptionButtons( [in] any Index );
  93     any ScrollBars( [in] any Index );
  94     any Spinners( [in] any Index );
  95
  96 // FIXME: should prolly inherit from Range somehow...
  97     XRange Cells( [in] any RowIndex, [in] any ColumnIndex );
  98     XRange Rows( [in] any Index );
  99     XRange Columns( [in] any Index );
 100     any Hyperlinks( [in] any Index );
 101     any Names( [in] any Index );
 102
 103     any Evaluate( [in] string Name );
 104
 105     void setEnableCalculation( [in] boolean EnableCalculation ) raises(com::sun::star::script::BasicErrorException);
 106     boolean getEnableCalculation() raises(com::sun::star::script::BasicErrorException);
 107     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 );
 108 };
 109
 110 //=============================================================================
 111
 112 }; }; };
 113
 114 #endif