Branch data Line data Source code
1 : : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 : : /*************************************************************************
3 : : *
4 : : * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 : : *
6 : : * Copyright 2000, 2010 Oracle and/or its affiliates.
7 : : *
8 : : * OpenOffice.org - a multi-platform office productivity suite
9 : : *
10 : : * This file is part of OpenOffice.org.
11 : : *
12 : : * OpenOffice.org is free software: you can redistribute it and/or modify
13 : : * it under the terms of the GNU Lesser General Public License version 3
14 : : * only, as published by the Free Software Foundation.
15 : : *
16 : : * OpenOffice.org is distributed in the hope that it will be useful,
17 : : * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 : : * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 : : * GNU Lesser General Public License version 3 for more details
20 : : * (a copy is included in the LICENSE file that accompanied this code).
21 : : *
22 : : * You should have received a copy of the GNU Lesser General Public License
23 : : * version 3 along with OpenOffice.org. If not, see
24 : : * <http://www.openoffice.org/license.html>
25 : : * for a copy of the LGPLv3 License.
26 : : *
27 : : ************************************************************************/
28 : : #ifndef SC_VBA_RANGE_HXX
29 : : #define SC_VBA_RANGE_HXX
30 : :
31 : : #include <cppuhelper/implbase4.hxx>
32 : : #include <com/sun/star/container/XEnumerationAccess.hpp>
33 : :
34 : : #include <ooo/vba/excel/XRange.hpp>
35 : : #include <com/sun/star/table/XCellRange.hpp>
36 : : #include <ooo/vba/excel/XFont.hpp>
37 : : #include <ooo/vba/excel/XComment.hpp>
38 : : #include <ooo/vba/XCollection.hpp>
39 : : #include <ooo/vba/excel/XPivotTable.hpp>
40 : : #include <ooo/vba/excel/XlPasteType.hpp>
41 : : #include <ooo/vba/excel/XlPasteSpecialOperation.hpp>
42 : :
43 : : #include <comphelper/proparrhlp.hxx>
44 : : #include <comphelper/propertycontainer.hxx>
45 : : #include <com/sun/star/beans/XPropertySet.hpp>
46 : : #include <com/sun/star/beans/PropertyAttribute.hpp>
47 : : #include <com/sun/star/script/XDefaultMethod.hpp>
48 : : #include <com/sun/star/script/XDefaultProperty.hpp>
49 : : #include <com/sun/star/sheet/FillDateMode.hpp>
50 : : #include <com/sun/star/sheet/FillMode.hpp>
51 : : #include <com/sun/star/sheet/FillDirection.hpp>
52 : : #include <com/sun/star/sheet/XSpreadsheet.hpp>
53 : : #include <com/sun/star/sheet/XSheetCellRangeContainer.hpp>
54 : : #include <com/sun/star/table/CellAddress.hpp>
55 : : #include "vbaquerytable.hxx"
56 : :
57 : : #include "vbaformat.hxx"
58 : : #include <formula/grammar.hxx>
59 : :
60 : : class ScCellRangesBase;
61 : : class ScCellRangeObj;
62 : : class ScDocShell;
63 : : class ScDocument;
64 : : class ScRangeList;
65 : :
66 : : typedef ScVbaFormat< ov::excel::XRange > ScVbaRange_BASE;
67 : :
68 : 8 : class ArrayVisitor
69 : : {
70 : : public:
71 : : virtual void visitNode( sal_Int32 x, sal_Int32 y, const css::uno::Reference< css::table::XCell >& xCell ) = 0;
72 [ - + ]: 8 : virtual ~ArrayVisitor(){}
73 : : };
74 : :
75 [ - + ]: 12 : class ValueSetter : public ArrayVisitor
76 : : {
77 : : public:
78 : : virtual bool processValue( const css::uno::Any& aValue, const css::uno::Reference< css::table::XCell >& xCell ) = 0;
79 : :
80 : :
81 : : };
82 : :
83 [ - + ]: 4 : class ValueGetter : public ArrayVisitor
84 : : {
85 : :
86 : : public:
87 : : virtual void processValue( sal_Int32 x, sal_Int32 y, const css::uno::Any& aValue ) = 0;
88 : : virtual const css::uno::Any& getValue() const = 0;
89 : : };
90 : :
91 : :
92 : :
93 : : class ScVbaRange : public ScVbaRange_BASE
94 : : {
95 : : css::uno::Reference< ov::XCollection > m_Areas;
96 : : css::uno::Reference< ov::XCollection > m_Borders;
97 : : css::uno::Reference< css::table::XCellRange > mxRange;
98 : : css::uno::Reference< css::sheet::XSheetCellRangeContainer > mxRanges;
99 : : sal_Bool mbIsRows;
100 : : sal_Bool mbIsColumns;
101 : : css::uno::Reference< ov::excel::XValidation > m_xValidation;
102 : : css::uno::Reference<excel::XQueryTable> m_xQueryTable;
103 : : double getCalcColWidth( const css::table::CellRangeAddress& ) throw (css::uno::RuntimeException);
104 : : double getCalcRowHeight( const css::table::CellRangeAddress& ) throw (css::uno::RuntimeException);
105 : : void visitArray( ArrayVisitor& vistor );
106 : :
107 : : css::uno::Reference< ov::excel::XRange > getEntireColumnOrRow( bool bColumn = true ) throw( css::uno::RuntimeException );
108 : :
109 : : void fillSeries( css::sheet::FillDirection nFillDirection, css::sheet::FillMode nFillMode, css::sheet::FillDateMode nFillDateMode, double fStep, double fEndValue ) throw( css::uno::RuntimeException );
110 : :
111 : : void ClearContents( sal_Int32 nFlags, bool bFireEvent ) throw (css::uno::RuntimeException);
112 : :
113 : : css::uno::Any getValue( ValueGetter& rValueGetter ) throw (css::uno::RuntimeException);
114 : : void setValue( const css::uno::Any& aValue, ValueSetter& setter, bool bFireEvent ) throw ( css::uno::RuntimeException);
115 : :
116 : : css::uno::Any getFormulaValue( formula::FormulaGrammar::Grammar ) throw (css::uno::RuntimeException);
117 : : void setFormulaValue( const css::uno::Any& aValue, formula::FormulaGrammar::Grammar, bool bFireEvent ) throw ( css::uno::RuntimeException);
118 : :
119 : : css::uno::Reference< ov::excel::XRange > getArea( sal_Int32 nIndex ) throw( css::uno::RuntimeException );
120 : : ScCellRangeObj* getCellRangeObj( ) throw ( css::uno::RuntimeException );
121 : : css::uno::Reference< ov::XCollection >& getBorders();
122 : : void groupUnGroup( bool bUnGroup = false ) throw ( css::script::BasicErrorException, css::uno::RuntimeException );
123 : : css::uno::Reference< ov::excel::XRange > PreviousNext( bool bIsPrevious );
124 : : css::uno::Reference< ov::excel::XRange > SpecialCellsImpl( sal_Int32 nType, const css::uno::Any& _oValue) throw ( css::script::BasicErrorException );
125 : : css::awt::Point getPosition() throw ( css::uno::RuntimeException );
126 : :
127 : : /** Fires a Worksheet_Change event for this range or range list. */
128 : : void fireChangeEvent();
129 : :
130 : : protected:
131 : : virtual ScCellRangesBase* getCellRangesBase() throw ( css::uno::RuntimeException );
132 : : virtual SfxItemSet* getCurrentDataSet( ) throw ( css::uno::RuntimeException );
133 : : public:
134 : : ScVbaRange( const css::uno::Reference< ov::XHelperInterface >& xParent, const css::uno::Reference< css::uno::XComponentContext >& xContext, const css::uno::Reference< css::table::XCellRange >& xRange, sal_Bool bIsRows = false, sal_Bool bIsColumns = false ) throw ( css::lang::IllegalArgumentException );
135 : : ScVbaRange( const css::uno::Reference< ov::XHelperInterface >& xParent, const css::uno::Reference< css::uno::XComponentContext >& xContext, const css::uno::Reference< css::sheet::XSheetCellRangeContainer >& xRanges, sal_Bool bIsRows = false, sal_Bool bIsColumns = false ) throw ( css::lang::IllegalArgumentException );
136 : : ScVbaRange( css::uno::Sequence< css::uno::Any > const& aArgs, css::uno::Reference< css::uno::XComponentContext >const& xContext ) throw ( css::lang::IllegalArgumentException );
137 : :
138 : : ScDocument* getScDocument() throw (css::uno::RuntimeException);
139 : : ScDocShell* getScDocShell() throw (css::uno::RuntimeException);
140 : :
141 : : /** Returns the ScVbaRange implementation object for the passed VBA Range object. */
142 : : static ScVbaRange* getImplementation( const css::uno::Reference< ov::excel::XRange >& rxRange );
143 : :
144 : : css::uno::Reference< css::frame::XModel > getUnoModel() throw (css::uno::RuntimeException);
145 : : static css::uno::Reference< css::frame::XModel > getUnoModel( const css::uno::Reference< ov::excel::XRange >& rxRange ) throw (css::uno::RuntimeException);
146 : :
147 : : const ScRangeList& getScRangeList() throw (css::uno::RuntimeException);
148 : : static const ScRangeList& getScRangeList( const css::uno::Reference< ov::excel::XRange >& rxRange ) throw (css::uno::RuntimeException);
149 : :
150 : : virtual ~ScVbaRange();
151 : 0 : virtual css::uno::Reference< ov::XHelperInterface > thisHelperIface() { return this; }
152 : : bool isSingleCellRange();
153 : :
154 : : static css::uno::Reference< ov::excel::XRange > getRangeObjectForName(
155 : : const css::uno::Reference< css::uno::XComponentContext >& xContext,
156 : : const rtl::OUString& sRangeName, ScDocShell* pDocSh,
157 : : formula::FormulaGrammar::AddressConvention eConv = formula::FormulaGrammar::CONV_XL_A1 ) throw ( css::uno::RuntimeException );
158 : : css::table::CellAddress getLeftUpperCellAddress();
159 : :
160 : : static css::uno::Reference< ov::excel::XRange > CellsHelper(
161 : : const css::uno::Reference< ov::XHelperInterface >& xParent,
162 : : const css::uno::Reference< css::uno::XComponentContext >& xContext,
163 : : const css::uno::Reference< css::table::XCellRange >& xRange,
164 : : const css::uno::Any &nRowIndex, const css::uno::Any &nColumnIndex ) throw(css::uno::RuntimeException);
165 : :
166 : : // Attributes
167 : : virtual css::uno::Any SAL_CALL getName() throw (css::uno::RuntimeException);
168 : : virtual void SAL_CALL setName( const css::uno::Any& aName ) throw (css::uno::RuntimeException);
169 : : virtual css::uno::Any SAL_CALL getValue() throw (css::uno::RuntimeException);
170 : : virtual void SAL_CALL setValue( const css::uno::Any& aValue ) throw ( css::uno::RuntimeException);
171 : : virtual css::uno::Any SAL_CALL getFormula() throw (css::uno::RuntimeException);
172 : : virtual void SAL_CALL setFormula( const css::uno::Any& rFormula ) throw (css::uno::RuntimeException);
173 : : virtual css::uno::Any SAL_CALL getFormulaArray() throw (css::uno::RuntimeException);
174 : : virtual void SAL_CALL setFormulaArray(const css::uno::Any& rFormula) throw (css::uno::RuntimeException);
175 : : virtual css::uno::Any SAL_CALL getFormulaR1C1() throw (css::uno::RuntimeException);
176 : : virtual void SAL_CALL setFormulaR1C1( const css::uno::Any &rFormula ) throw (css::uno::RuntimeException);
177 : : virtual ::sal_Int32 SAL_CALL getCount() throw (css::uno::RuntimeException);
178 : : virtual ::sal_Int32 SAL_CALL getRow() throw (css::uno::RuntimeException);
179 : : virtual ::sal_Int32 SAL_CALL getColumn() throw (css::uno::RuntimeException);
180 : : virtual ::rtl::OUString SAL_CALL getText() throw (css::uno::RuntimeException);
181 : : using ScVbaRange_BASE::setNumberFormat;
182 : : virtual void SAL_CALL setNumberFormat( const css::uno::Any& rNumberFormat ) throw ( css::script::BasicErrorException, css::uno::RuntimeException);
183 : : virtual css::uno::Any SAL_CALL getNumberFormat() throw (css::script::BasicErrorException, css::uno::RuntimeException);
184 : : virtual void SAL_CALL setMergeCells( const css::uno::Any& bMerge ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
185 : : virtual css::uno::Any SAL_CALL getMergeCells() throw (css::script::BasicErrorException, css::uno::RuntimeException);
186 : : virtual void SAL_CALL setWrapText( const css::uno::Any& bIsWrapped ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
187 : : virtual css::uno::Any SAL_CALL getWrapText() throw (css::script::BasicErrorException, css::uno::RuntimeException);
188 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL getEntireRow() throw (css::uno::RuntimeException);
189 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL getEntireColumn() throw (css::uno::RuntimeException);
190 : : virtual css::uno::Reference< ov::excel::XComment > SAL_CALL getComment() throw (css::uno::RuntimeException);
191 : : virtual css::uno::Any SAL_CALL getHidden() throw (css::uno::RuntimeException);
192 : : virtual void SAL_CALL setHidden( const css::uno::Any& _hidden ) throw (css::uno::RuntimeException);
193 : : virtual css::uno::Any SAL_CALL getColumnWidth() throw (css::uno::RuntimeException);
194 : : virtual void SAL_CALL setColumnWidth( const css::uno::Any& _columnwidth ) throw (css::uno::RuntimeException);
195 : : virtual css::uno::Any SAL_CALL getRowHeight() throw (css::uno::RuntimeException);
196 : : virtual void SAL_CALL setRowHeight( const css::uno::Any& _rowheight ) throw (css::uno::RuntimeException);
197 : : virtual css::uno::Any SAL_CALL getWidth() throw (css::uno::RuntimeException);
198 : : virtual css::uno::Any SAL_CALL getHeight() throw (css::uno::RuntimeException);
199 : : virtual css::uno::Any SAL_CALL getTop() throw (css::uno::RuntimeException);
200 : : virtual css::uno::Any SAL_CALL getLeft() throw (css::uno::RuntimeException);
201 : :
202 : : virtual css::uno::Reference< ov::excel::XWorksheet > SAL_CALL getWorksheet() throw (css::uno::RuntimeException);
203 : : virtual css::uno::Any SAL_CALL getPageBreak() throw (css::uno::RuntimeException);
204 : : virtual void SAL_CALL setPageBreak( const css::uno::Any& _pagebreak ) throw (css::uno::RuntimeException);
205 : : virtual css::uno::Reference< ov::excel::XValidation > SAL_CALL getValidation() throw (css::uno::RuntimeException);
206 : : virtual css::uno::Any SAL_CALL getPrefixCharacter() throw (css::uno::RuntimeException);
207 : : virtual css::uno::Any SAL_CALL getShowDetail() throw (css::uno::RuntimeException);
208 : : virtual void SAL_CALL setShowDetail(const css::uno::Any& aShowDetail) throw (css::uno::RuntimeException);
209 : : virtual ::com::sun::star::uno::Reference< ::ooo::vba::excel::XQueryTable > SAL_CALL getQueryTable() throw (::com::sun::star::uno::RuntimeException);
210 : : // Methods
211 : 0 : sal_Bool IsRows() const { return mbIsRows; }
212 : 0 : sal_Bool IsColumns() const { return mbIsColumns; }
213 : : virtual css::uno::Reference< ov::excel::XComment > SAL_CALL AddComment( const css::uno::Any& Text ) throw (css::uno::RuntimeException);
214 : : virtual void SAL_CALL Clear() throw (css::uno::RuntimeException);
215 : : virtual void SAL_CALL ClearComments() throw (css::uno::RuntimeException);
216 : : virtual void SAL_CALL ClearContents() throw (css::uno::RuntimeException);
217 : : virtual void SAL_CALL ClearFormats() throw (css::uno::RuntimeException);
218 : : virtual css::uno::Any SAL_CALL HasFormula() throw (css::uno::RuntimeException);
219 : : virtual void SAL_CALL FillLeft() throw (css::uno::RuntimeException);
220 : : virtual void SAL_CALL FillRight() throw (css::uno::RuntimeException);
221 : : virtual void SAL_CALL FillUp() throw (css::uno::RuntimeException);
222 : : virtual void SAL_CALL FillDown() throw (css::uno::RuntimeException);
223 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Offset( const css::uno::Any &nRowOffset, const css::uno::Any &nColOffset )
224 : : throw (css::uno::RuntimeException);
225 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL CurrentRegion() throw (css::uno::RuntimeException);
226 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL CurrentArray() throw (css::uno::RuntimeException);
227 : : virtual ::rtl::OUString SAL_CALL Characters( const css::uno::Any& nIndex, const css::uno::Any& nCount )
228 : : throw (css::uno::RuntimeException);
229 : :
230 : : virtual ::rtl::OUString SAL_CALL Address( const css::uno::Any& RowAbsolute, const css::uno::Any& ColumnAbsolute, const css::uno::Any& ReferenceStyle, const css::uno::Any& External, const css::uno::Any& RelativeTo ) throw (css::uno::RuntimeException);
231 : :
232 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Cells( const css::uno::Any &nRow, const css::uno::Any &nCol )
233 : : throw (css::uno::RuntimeException);
234 : : virtual void SAL_CALL Select() throw (css::uno::RuntimeException);
235 : : virtual void SAL_CALL Activate() throw (css::uno::RuntimeException);
236 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Rows( const css::uno::Any& nIndex ) throw (css::uno::RuntimeException);
237 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Columns( const css::uno::Any &nIndex ) throw (css::uno::RuntimeException);
238 : : virtual void SAL_CALL Copy( const css::uno::Any& Destination ) throw (css::uno::RuntimeException);
239 : : virtual void SAL_CALL Cut( const css::uno::Any& Destination ) throw (css::uno::RuntimeException);
240 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Resize( const css::uno::Any& RowSize, const css::uno::Any& ColumnSize )
241 : : throw (css::uno::RuntimeException);
242 : : virtual css::uno::Reference< ov::excel::XFont > SAL_CALL Font() throw ( css::script::BasicErrorException, css::uno::RuntimeException);
243 : : virtual css::uno::Reference< ov::excel::XInterior > SAL_CALL Interior( ) throw ( css::script::BasicErrorException, css::uno::RuntimeException) ;
244 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Range( const css::uno::Any &Cell1, const css::uno::Any &Cell2 ) throw (css::uno::RuntimeException);
245 : : virtual css::uno::Reference< ov::excel::XRange > Range( const css::uno::Any &Cell1, const css::uno::Any &Cell2, bool bForceUseInpuRangeTab ) throw (css::uno::RuntimeException);
246 : : virtual css::uno::Any SAL_CALL getCellRange( ) throw (css::uno::RuntimeException);
247 : : static css::uno::Any getCellRange( const css::uno::Reference< ov::excel::XRange >& rxRange ) throw (css::uno::RuntimeException);
248 : : virtual void SAL_CALL PasteSpecial( const css::uno::Any& Paste, const css::uno::Any& Operation, const css::uno::Any& SkipBlanks, const css::uno::Any& Transpose ) throw (css::uno::RuntimeException);
249 : : virtual ::sal_Bool SAL_CALL Replace( const ::rtl::OUString& What, const ::rtl::OUString& Replacement, const css::uno::Any& LookAt, const css::uno::Any& SearchOrder, const css::uno::Any& MatchCase, const css::uno::Any& MatchByte, const css::uno::Any& SearchFormat, const css::uno::Any& ReplaceFormat ) throw (css::uno::RuntimeException);
250 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Find( const css::uno::Any& What, const css::uno::Any& After, const css::uno::Any& LookIn, const css::uno::Any& LookAt, const css::uno::Any& SearchOrder, const css::uno::Any& SearchDirection, const css::uno::Any& MatchCase, const css::uno::Any& MatchByte, const css::uno::Any& SearchFormat ) throw (css::uno::RuntimeException);
251 : : virtual void SAL_CALL Sort( const css::uno::Any& Key1, const css::uno::Any& Order1, const css::uno::Any& Key2, const css::uno::Any& Type, const css::uno::Any& Order2, const css::uno::Any& Key3, const css::uno::Any& Order3, const css::uno::Any& Header, const css::uno::Any& OrderCustom, const css::uno::Any& MatchCase, const css::uno::Any& Orientation, const css::uno::Any& SortMethod, const css::uno::Any& DataOption1, const css::uno::Any& DataOption2, const css::uno::Any& DataOption3 ) throw (css::uno::RuntimeException);
252 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL End( ::sal_Int32 Direction ) throw (css::uno::RuntimeException);
253 : : virtual css::uno::Reference< ov::excel::XCharacters > SAL_CALL characters( const css::uno::Any& Start, const css::uno::Any& Length ) throw (css::uno::RuntimeException);
254 : : virtual void SAL_CALL Delete( const css::uno::Any& Shift ) throw (css::uno::RuntimeException);
255 : : virtual css::uno::Any SAL_CALL Areas( const css::uno::Any& ) throw (css::uno::RuntimeException);
256 : : virtual css::uno::Any SAL_CALL Borders( const css::uno::Any& ) throw ( css::script::BasicErrorException, css::uno::RuntimeException);
257 : : virtual css::uno::Any SAL_CALL BorderAround( const css::uno::Any& LineStyle,
258 : : const css::uno::Any& Weight, const css::uno::Any& ColorIndex, const css::uno::Any& Color ) throw (css::uno::RuntimeException);
259 : : virtual void SAL_CALL TextToColumns( const css::uno::Any& Destination, const css::uno::Any& DataType, const css::uno::Any& TextQualifier,
260 : : const css::uno::Any& ConsecutiveDelimiter, const css::uno::Any& Tab, const css::uno::Any& Semicolon, const css::uno::Any& Comma,
261 : : const css::uno::Any& Space, const css::uno::Any& Other, const css::uno::Any& OtherChar, const css::uno::Any& FieldInfo,
262 : : const css::uno::Any& DecimalSeparator, const css::uno::Any& ThousandsSeparator, const css::uno::Any& TrailingMinusNumbers ) throw (css::uno::RuntimeException);
263 : : virtual css::uno::Any SAL_CALL Hyperlinks( const css::uno::Any& aIndex ) throw (css::uno::RuntimeException);
264 : :
265 : : virtual void SAL_CALL AutoFilter( const css::uno::Any& Field, const css::uno::Any& Criteria1, const css::uno::Any& Operator, const css::uno::Any& Criteria2, const css::uno::Any& VisibleDropDown ) throw (css::uno::RuntimeException);
266 : : virtual void SAL_CALL Insert( const css::uno::Any& Shift, const css::uno::Any& CopyOrigin ) throw (css::uno::RuntimeException);
267 : : virtual void SAL_CALL Autofit() throw (css::uno::RuntimeException);
268 : : virtual void SAL_CALL PrintOut( const css::uno::Any& From, const css::uno::Any& To, const css::uno::Any& Copies, const css::uno::Any& Preview, const css::uno::Any& ActivePrinter, const css::uno::Any& PrintToFile, const css::uno::Any& Collate, const css::uno::Any& PrToFileName ) throw (css::uno::RuntimeException);
269 : : virtual void SAL_CALL AutoFill( const css::uno::Reference< ov::excel::XRange >& Destination, const css::uno::Any& Type ) throw (css::uno::RuntimeException) ;
270 : : void SAL_CALL Calculate( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
271 : : virtual void SAL_CALL AutoOutline( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
272 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Item( const ::css::uno::Any& row, const css::uno::Any& column ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
273 : : virtual void SAL_CALL ClearOutline( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
274 : : virtual void SAL_CALL Ungroup( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
275 : : virtual void SAL_CALL Group( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
276 : : virtual void SAL_CALL Merge( const css::uno::Any& Across ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
277 : : virtual void SAL_CALL UnMerge( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
278 : : virtual css::uno::Any SAL_CALL getStyle() throw (css::uno::RuntimeException);
279 : : virtual void SAL_CALL setStyle( const css::uno::Any& _style ) throw (css::uno::RuntimeException);
280 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Next() throw (css::script::BasicErrorException, css::uno::RuntimeException);
281 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL Previous() throw (css::script::BasicErrorException, css::uno::RuntimeException);
282 : : virtual void SAL_CALL RemoveSubtotal( ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
283 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL MergeArea() throw (css::script::BasicErrorException, css::uno::RuntimeException);
284 : : virtual void SAL_CALL Subtotal( ::sal_Int32 GroupBy, ::sal_Int32 Function, const css::uno::Sequence< ::sal_Int32 >& TotalList, const css::uno::Any& Replace, const css::uno::Any& PageBreaks, const css::uno::Any& SummaryBelowData ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
285 : : virtual css::uno::Any SAL_CALL AdvancedFilter( ::sal_Int32 Action, const css::uno::Any& CriteriaRange, const css::uno::Any& CopyToRange, const css::uno::Any& Unique ) throw (css::script::BasicErrorException, css::uno::RuntimeException);
286 : :
287 : : virtual css::uno::Reference< ov::excel::XPivotTable > SAL_CALL PivotTable( ) throw (css::uno::RuntimeException);
288 : :
289 : : virtual ::sal_Int32 SAL_CALL CopyFromRecordset( const ::com::sun::star::uno::Any& Data, const ::com::sun::star::uno::Any& MaxRows, const ::com::sun::star::uno::Any& MaxColumns ) throw (::com::sun::star::script::BasicErrorException, ::com::sun::star::uno::RuntimeException);
290 : : // XEnumerationAccess
291 : : virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() throw (css::uno::RuntimeException);
292 : : // XElementAccess
293 : 0 : virtual css::uno::Type SAL_CALL getElementType() throw (css::uno::RuntimeException)
294 : : {
295 : 0 : return ov::excel::XRange::static_type(0);
296 : :
297 : : }
298 : : virtual sal_Bool SAL_CALL hasElements() throw (css::uno::RuntimeException);
299 : : // XDefaultMethod
300 : : ::rtl::OUString SAL_CALL getDefaultMethodName( ) throw (css::uno::RuntimeException);
301 : : // XDefaultProperty
302 : 128 : ::rtl::OUString SAL_CALL getDefaultPropertyName( ) throw (css::uno::RuntimeException) { return ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Value")); }
303 : :
304 : :
305 : : // #TODO completely rewrite ScVbaRange, its become a hackfest
306 : : // it needs to be closer to ScCellRangeBase in that the underlying
307 : : // object model should probably be a ScRangelst.
308 : : // * would be nice to be able to construct a range from an address only
309 : : // * or a list of address ( multi-area )
310 : : // * object should be a lightweight as possible
311 : : // * we shouldn't need hacks like this below
312 : : static css::uno::Reference< ov::excel::XRange > ApplicationRange( const css::uno::Reference< css::uno::XComponentContext >& xContext, const css::uno::Any &Cell1, const css::uno::Any &Cell2 ) throw (css::uno::RuntimeException);
313 : : virtual sal_Bool SAL_CALL GoalSeek( const css::uno::Any& Goal, const css::uno::Reference< ov::excel::XRange >& ChangingCell ) throw (css::uno::RuntimeException);
314 : : virtual css::uno::Reference< ov::excel::XRange > SAL_CALL SpecialCells( const css::uno::Any& _oType, const css::uno::Any& _oValue) throw ( css::script::BasicErrorException );
315 : : // XErrorQuery
316 : : virtual ::sal_Bool SAL_CALL hasError( ) throw (css::uno::RuntimeException);
317 : : // XHelperInterface
318 : : virtual rtl::OUString getServiceImplName();
319 : : virtual css::uno::Sequence<rtl::OUString> getServiceNames();
320 : : };
321 : : #endif /* SC_VBA_RANGE_HXX */
322 : :
323 : : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
