'************************************************************************* ' ' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. ' ' Copyright 2008 by Sun Microsystems, Inc. ' ' OpenOffice.org - a multi-platform office productivity suite ' ' $RCSfile: sheet_XDataPilotDescriptor.xba,v $ ' ' $Revision: 1.3 $ ' ' This file is part of OpenOffice.org. ' ' OpenOffice.org is free software: you can redistribute it and/or modify ' it under the terms of the GNU Lesser General Public License version 3 ' only, as published by the Free Software Foundation. ' ' OpenOffice.org is distributed in the hope that it will be useful, ' but WITHOUT ANY WARRANTY; without even the implied warranty of ' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ' GNU Lesser General Public License version 3 for more details ' (a copy is included in the LICENSE file that accompanied this code). ' ' You should have received a copy of the GNU Lesser General Public License ' version 3 along with OpenOffice.org. If not, see ' ' for a copy of the LGPLv3 License. ' '************************************************************************* '************************************************************************* ' Be sure that all variables are dimensioned: option explicit Sub RunTest() '************************************************************************* ' INTERFACE: ' com.sun.star.sheet.XDataPilotDescriptor '************************************************************************* On Error Goto ErrHndl Dim bOK, bOK1 As Boolean Dim Tag, oldTag As String Dim oldRange, newRange, FD As Object Dim Range As New com.sun.star.table.CellRangeAddress Dim Fields() As Object Test.StartMethod("getTag()") bOK = true bOK = bOK AND NOT isNULL(oObj.getTag()) Test.MethodTested("getTag()", bOK) Test.StartMethod("setTag()") bOK = true Tag = cIfcShortName oldTag = oObj.getTag() oObj.SetTag(Tag) bOK = bOK AND (oldTag <> oObj.getTag()) oObj.setTag(oldTag) Test.MethodTested("setTag()", bOK) Test.StartMethod("getSourceRange()") bOK = true bOK = bOK AND NOT isNULL(oObj.getSourceRange()) Test.MethodTested("getSourceRange()", bOK) Test.StartMethod("setSourceRange()") bOK = true Range.Sheet = 0 Range.StartColumn = 1 Range.StartRow = 1 Range.EndColumn = 4 Range.EndRow = 4 oldRange = oObj.getSourceRange oObj.setSourceRange(Range) newRange = oObj.getSourceRange bOK1 = false bOK1 = bOK1 OR newRange.Sheet <> oldRange.Sheet bOK1 = bOK1 OR newRange.StartColumn <> oldRange.StartColumn bOK1 = bOK1 OR newRange.EndColumn <> oldRange.EndColumn bOK1 = bOK1 OR newRange.StartRow <> oldRange.StartRow bOK1 = bOK1 OR newRange.EndRow <> oldRange.EndRow bOK = bOK AND bOK1 oObj.setSourceRange(oldRange) Test.MethodTested("setSourceRange()", bOK) Test.StartMethod("getFilterDescriptor()") bOK = true FD = oObj.getFilterDescriptor bOK = (NOT isNULL(FD)) AND (ubound(FD.getFilterFields) > 0) Test.MethodTested("getFilterDescriptor()", bOK) Test.StartMethod("getDataPilotFields()") bOK = true Fields = oObj.getDataPilotFields bOK = NOT isNULL(Fields) Test.MethodTested("getDataPilotFields()", bOK) Test.StartMethod("getColumnFields()") bOK = true Fields = oObj.getColumnFields bOK = NOT isNULL(Fields) Test.MethodTested("getColumnFields()", bOK) Test.StartMethod("getRowFields()") bOK = true Fields = oObj.getRowFields bOK = NOT isNULL(Fields) Test.MethodTested("getRowFields()", bOK) Test.StartMethod("getPageFields()") bOK = true Fields = oObj.getPageFields() bOK = NOT isNULL(Fields) Test.MethodTested("getPageFields()", bOK) Test.StartMethod("getDataFields()") bOK = true Fields = oObj.getDataFields bOK = bOK AND NOT isNULL(Fields) Test.MethodTested("getDataFields()", bOK) Test.StartMethod("getHiddenFields()") bOK = true Fields = oObj.getHiddenFields() bOK = NOT isNULL(Fields) Test.MethodTested("getHiddenFields()", bOK) Exit Sub ErrHndl: Test.Exception() bOK = false resume next End Sub