'************************************************************************* ' ' 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_XNamedRanges.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.XNamedRanges '************************************************************************* On Error Goto ErrHndl Dim bOK As Boolean Dim count As Integer Dim outRange As New com.sun.star.table.CellAddress Dim range As New com.sun.star.table.CellRangeAddress Dim i As Integer Test.StartMethod("addNewByName()") bOK = true outRange.Sheet = 0 outRange.Row = 1 outRange.Column = 1 count = oObj.Count oObj.addNewByName(cIfcShortName, "T4:Y7", outRange, 0) bOK = bOK AND oObj.count = count + 1 bOK = bOK AND oObj.hasByName(cIfcShortName) Test.MethodTested("addNewByName()", bOK) Test.StartMethod("addNewFromTitles()") bOK = true count = oObj.count range.Sheet = 0 range.StartRow = 1 range.StartColumn = 2 range.EndRow = 3 range.EndColumn = 4 for i = 1 to 5 oDoc.Sheets(0).getCellByPosition(i, 1).String = "Col" & i next i oObj.addNewFromTitles(range, com.sun.star.sheet.Border.TOP) bOK = bOK AND (oObj.count = count + 3) bOK = bOK AND NOT oObj.hasByName("Col1") bOK = bOK AND oObj.hasByName("Col2") bOK = bOK AND oObj.hasByName("Col3") bOK = bOK AND oObj.hasByName("Col4") bOK = bOK AND NOT oObj.hasByName("Col5") Test.MethodTested("addNewFromTitles()", bOK) Test.StartMethod("removeByName()") bOK = true count = oObj.Count oObj.removeByName(cIfcShortName) bOK = bOK AND (count = oObj.count + 1) bOK = bOK AND NOT oObj.hasByName(cIfcShortName) Test.MethodTested("removeByName()", bOK) Test.StartMethod("outputList()") bOK = true outRange.Sheet = 0 outRange.Row = 5 outRange.Column = 5 count = oObj.count for i = 4 to 5 + count oDoc.Sheets(0).getCellByPosition(5, i).String = "a" oDoc.Sheets(0).getCellByPosition(6, i).String = "b" next i oObj.outputList(outRange) bOK = bOK AND oDoc.Sheets(0).getCellByPosition(5, 4).String = "a" bOK = bOK AND oDoc.Sheets(0).getCellByPosition(6, 4).String = "b" bOK = bOK AND oDoc.Sheets(0).getCellByPosition(5, 5 + count).String = "a" bOK = bOK AND oDoc.Sheets(0).getCellByPosition(6, 5 + count).String = "b" for i = 5 to 4 + count bOK = bOK AND oDoc.Sheets(0).getCellByPosition(5, i).String <> "a" bOK = bOK AND oDoc.Sheets(0).getCellByPosition(6, i).String <> "b" bOK = bOK AND oObj.hasByName(oDoc.Sheets(0).getCellByPosition(5, i).String) next i Test.MethodTested("outputList()", bOK) Exit Sub ErrHndl: Test.Exception() bOK = false resume next End Sub