| 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 |
interface XFont; |
| 25 |
interface XRows; |
| 26 |
interface XColumns; |
| 27 |
interface XComment; |
| 28 |
|
| 29 |
interface XInterior; |
| 30 |
interface XCharacters; |
| 31 |
interface XBorders; |
| 32 |
interface XValidation; |
| 33 |
interface XWorksheet; |
| 34 |
interface XName; |
| 35 |
|
| 36 |
interface XRange |
| 37 |
{ |
| 38 |
interface com::sun::star::container::XEnumerationAccess; |
| 39 |
interface com::sun::star::script::XDefaultMethod; |
| 40 |
interface com::sun::star::script::XDefaultProperty; |
| 41 |
interface com::sun::star::script::XErrorQuery; |
| 42 |
interface ::ooo::vba::excel::XFormat; |
| 43 |
//interface ::ooo::vba::XHelperInterface; |
| 44 |
|
| 45 |
[attribute] any Value; |
| 46 |
[attribute] any Value2; |
| 47 |
[attribute] any Formula; |
| 48 |
[attribute] any FormulaArray; |
| 49 |
[attribute] any FormulaR1C1; |
| 50 |
[attribute] any FormulaLocal; |
| 51 |
[attribute] any FormulaR1C1Local; |
| 52 |
[attribute, readonly] long Count; |
| 53 |
[attribute, readonly] long Row; |
| 54 |
[attribute, readonly] long Column; |
| 55 |
[attribute, readonly] string Text; |
| 56 |
[attribute, readonly] XRange EntireRow; |
| 57 |
[attribute, readonly] XRange EntireColumn; |
| 58 |
[attribute, readonly] XComment Comment; |
| 59 |
[attribute] any Hidden; |
| 60 |
[attribute] any ColumnWidth; |
| 61 |
[attribute, readonly ] any Width; |
| 62 |
[attribute, readonly] XWorksheet Worksheet; |
| 63 |
[attribute, readonly] XName Name; |
| 64 |
[attribute] any RowHeight; |
| 65 |
[attribute, readonly ] any Height; |
| 66 |
[attribute, readonly ] any Top; |
| 67 |
[attribute, readonly ] any Left; |
| 68 |
[attribute] any PageBreak; |
| 69 |
[attribute, readonly] XValidation Validation; |
| 70 |
[attribute, readonly] any PrefixCharacter; |
| 71 |
[attribute] any Style |
| 72 |
{ |
| 73 |
get raises ( com::sun::star::script::BasicErrorException ); |
| 74 |
}; |
| 75 |
[attribute] any AddIndent; |
| 76 |
[attribute] any ShowDetail; |
| 77 |
|
| 78 |
XComment AddComment( [in] any Text ); |
| 79 |
void Clear(); |
| 80 |
void ClearComments(); |
| 81 |
void ClearContents(); |
| 82 |
void ClearFormats(); |
| 83 |
any HasFormula(); |
| 84 |
void FillLeft(); |
| 85 |
void FillRight(); |
| 86 |
void FillUp(); |
| 87 |
void FillDown(); |
| 88 |
XRange Item([in] any RowIndex, [in] any ColumnIndex) raises(com::sun::star::script::BasicErrorException); |
| 89 |
XRange Offset([in] any RowOffset, [in] any ColumnOffset); |
| 90 |
XRange CurrentRegion(); |
| 91 |
XRange CurrentArray(); |
| 92 |
string Characters([in] any Start, [in] any Length); |
| 93 |
string Address( [in] any RowAbsolute, [in] any ColumnAbsolute, [in] any ReferenceStyle, [in] any External, [in] any RelativeTo ); |
| 94 |
XRange Cells([in] any RowIndex, [in] any ColumnIndex); |
| 95 |
void Select(); |
| 96 |
void AutoOutline() raises(com::sun::star::script::BasicErrorException); |
| 97 |
void Activate(); |
| 98 |
XRange Rows( [in] any RowIndex ); |
| 99 |
void Calculate() raises(com::sun::star::script::BasicErrorException); |
| 100 |
XRange Columns( [in] any ColumnIndex ); |
| 101 |
void Copy([in] any Destination); |
| 102 |
void Cut([in] any Destination); |
| 103 |
XRange Resize( [in] any RowSize, [in] any ColumnSize ); |
| 104 |
XRange Range( [in] any Cell1, [in] any Cell2 ); |
| 105 |
any getCellRange(); |
| 106 |
void PasteSpecial([in] any Paste, [in] any Operation,[in] any SkipBlanks, [in] any Transpose); |
| 107 |
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 ); |
| 108 |
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 ); |
| 109 |
|
| 110 |
void Sort( [in] any Key1, [in] any Order1, [in] any Key2, [in] any Type, |
| 111 |
[in] any Order2, [in] any Key3, [in] any Order3, |
| 112 |
[in] any Header, [in] any OrderCustom, [in] any MatchCase, |
| 113 |
[in] any Orientation, [in] any SortMethod, [in] any DataOption1, |
| 114 |
[in] any DataOption2, [in] any DataOption3 ); |
| 115 |
XRange End( [in] long Direction ); |
| 116 |
// bizarrely I have to define Character method as character otherwise |
| 117 |
// idl complains |
| 118 |
XCharacters characters([in] any Start, [in] any Length); |
| 119 |
void Delete( [in] any Shift ); |
| 120 |
|
| 121 |
any Areas( [in] any Item ); |
| 122 |
any BorderAround( [in] any LineStyle, [in] any Weight, [in] any ColorIndex, [in] any Color ); |
| 123 |
void AutoFilter([in ] any Field, [in] any Criteria1, [in] any Operator, [in] any Criteria2, [in] any VisibleDropDown); |
| 124 |
void Insert([in] any Shift, [in] any CopyOrigin); |
| 125 |
void Autofit() raises(com::sun::star::script::BasicErrorException); |
| 126 |
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); |
| 127 |
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); |
| 128 |
void AutoFill( [in] XRange Destination, [in] any Type ); |
| 129 |
boolean GoalSeek( [in] any Goal, [in] XRange ChangingCell ); |
| 130 |
void ClearOutline() raises(com::sun::star::script::BasicErrorException); |
| 131 |
void Ungroup() raises(com::sun::star::script::BasicErrorException); |
| 132 |
void Group() raises(com::sun::star::script::BasicErrorException); |
| 133 |
void Merge([in] any Across) raises(com::sun::star::script::BasicErrorException); |
| 134 |
void UnMerge() raises(com::sun::star::script::BasicErrorException); |
| 135 |
XRange Next( ) raises ( com::sun::star::script::BasicErrorException ); |
| 136 |
XRange Previous( ) raises ( com::sun::star::script::BasicErrorException ); |
| 137 |
XRange SpecialCells( [in] any Type, [in] /*Optional*/ any Value ) raises ( com::sun::star::script::BasicErrorException ); |
| 138 |
void RemoveSubtotal() raises ( com::sun::star::script::BasicErrorException ); |
| 139 |
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 ); |
| 140 |
XRange MergeArea( ) raises ( com::sun::star::script::BasicErrorException ); |
| 141 |
any Hyperlinks( [in] any Index ); |
| 142 |
}; |
| 143 |
|
| 144 |
|
| 145 |
|
| 146 |
}; }; }; |
| 147 |
|
| 148 |
|
| 149 |
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |