oovbaapi/ooo/vba/excel/XWorksheet.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_XWorksheet_idl__
  20 #define __ooo_vba_excel_XWorksheet_idl__
  21
  22 #include <com/sun/star/lang/XUnoTunnel.idl>
  23 #include <ooo/vba/XHelperInterface.idl>
  24 #include <com/sun/star/script/XInvocation.idl>
  25 #include <com/sun/star/container/XNamed.idl>
  26
  27
  28
  29 module ooo {  module vba {  module excel {
  30
  31
  32
  33 interface XComments;
  34 interface XRange;
  35 interface XOutline;
  36 interface XPageSetup;
  37 interface XHPageBreaks;
  38 interface XVPageBreaks;
  39 interface XWorksheet
  40 {
  41     interface ::ooo::vba::XHelperInterface;
  42     interface ::com::sun::star::script::XInvocation;
  43     interface ::com::sun::star::container::XNamed;
  44     interface ::com::sun::star::lang::XUnoTunnel;
  45
  46     [attribute] long Visible;
  47     [attribute, readonly] long StandardHeight;
  48     [attribute, readonly] long StandardWidth;
  49     [attribute, readonly] boolean ProtectionMode;
  50     [attribute, readonly] boolean ProtectContents;
  51     [attribute, readonly] boolean ProtectDrawingObjects;
  52     [attribute, readonly] boolean ProtectScenarios;
  53     [attribute, readonly] XRange UsedRange;
  54     [attribute, readonly] XWorksheet Next;
  55     [attribute, readonly] XWorksheet Previous;
  56     [attribute, readonly] string CodeName;
  57     [attribute, readonly] short Index;
  58     [attribute] long EnableSelection;
  59     [attribute] boolean AutoFilterMode;
  60
  61     void Activate();
  62     void Calculate();
  63     void Select();
  64     void Move([in] any Before,[in] any After );
  65     void Copy([in] any Before,[in] any After );
  66     void Paste([in] any Destination,[in] any Link);
  67     void Delete();
  68     void Protect([in] any Password,[in] any DrawingObjects ,[in] any Contents,[in] any Scenarios,[in] any UserInterfaceOnly);
  69     void Unprotect([in] any Password );
  70     void CheckSpelling([in] any CustomDictionary,[in] any IgnoreUppercase, [in] any AlwaysSuggest,[in] any SpellingLang );
  71     void ShowDataForm();
  72
  73     XRange Range([in] any Cell1, [in] any Cell2 );
  74     any ChartObjects([in] any Index);
  75     any PivotTables([in] any Index);
  76     any Comments([in] any Index);
  77     XOutline Outline();
  78     XPageSetup PageSetup();
  79     any HPageBreaks([in] any Index);
  80     any VPageBreaks([in] any Index);
  81     any OLEObjects([in] any Index);
  82     any Shapes([in] any Index);
  83
  84     /*  The following form control related symbols do not refer to ActiveX form
  85         controls embedded in the sheet, but to the old-style drawing controls
  86         of Excel. This is an Excel-only feature. */
  87     any Buttons( [in] any Index );
  88     any CheckBoxes( [in] any Index );
  89     any DropDowns( [in] any Index );
  90     any GroupBoxes( [in] any Index );
  91     any Labels( [in] any Index );
  92     any ListBoxes( [in] any Index );
  93     any OptionButtons( [in] any Index );
  94     any ScrollBars( [in] any Index );
  95     any Spinners( [in] any Index );
  96
  97 // FIXME: should prolly inherit from Range somehow...
  98     XRange Cells( [in] any RowIndex, [in] any ColumnIndex );
  99     XRange Rows( [in] any Index );
 100     XRange Columns( [in] any Index );
 101     any Hyperlinks( [in] any Index );
 102     any Names( [in] any Index );
 103
 104     any Evaluate( [in] string Name );
 105
 106     void setEnableCalculation( [in] boolean EnableCalculation ) raises(com::sun::star::script::BasicErrorException);
 107     boolean getEnableCalculation() raises(com::sun::star::script::BasicErrorException);
 108     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 );
 109 };
 110
 111
 112
 113 }; }; };
 114
 115 #endif
 116
 117 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */