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