summaryrefslogtreecommitdiff
path: root/qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba
diff options
context:
space:
mode:
Diffstat (limited to 'qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba')
-rw-r--r--qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba110
1 files changed, 110 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba b/qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba
new file mode 100644
index 000000000000..69ef24c93c5c
--- /dev/null
+++ b/qadevOOo/tests/basic/ifc/sheet/XNamedRange/sheet_XNamedRange.xba
@@ -0,0 +1,110 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
+<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sheet_XNamedRange" script:language="StarBasic">
+
+
+'*************************************************************************
+'
+' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+'
+' Copyright 2000, 2010 Oracle and/or its affiliates.
+'
+' OpenOffice.org - a multi-platform office productivity suite
+'
+' 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
+' <http://www.openoffice.org/license.html>
+' for a copy of the LGPLv3 License.
+'
+'*************************************************************************
+'*************************************************************************
+
+
+
+' Be sure that all variables are dimensioned:
+option explicit
+
+
+
+Sub RunTest()
+
+'*************************************************************************
+' INTERFACE:
+' com.sun.star.sheet.XNamedRange
+'*************************************************************************
+On Error Goto ErrHndl
+ Dim bOK As Boolean
+ Dim oldContent, newContent As String
+ Dim position, oldPosition As Object
+ Dim newPosition As New com.sun.star.table.CellAddress
+ Dim oldType, newType As Long
+
+ Test.StartMethod("getContent()")
+ bOK = true
+ bOK = bOK AND NOT isNULL(oObj.getContent())
+ Test.MethodTested("getContent()", bOK)
+
+ Test.StartMethod("setContent()")
+ bOK = true
+ oldContent = oObj.getContent
+ newContent = cIfcShortName
+ oObj.setContent(newContent)
+ bOK = bOK AND (oldContent &lt;&gt; oObj.getContent)
+ oObj.setContent(oldContent)
+ Test.MethodTested("setContent()", bOK)
+
+ Test.StartMethod("getReferencePosition()")
+ bOK = true
+ bOK = bOK AND NOT isNULL(oObj.getReferencePosition())
+ Test.MethodTested("getReferencePosition()", bOK)
+
+ Test.StartMethod("setReferencePosition()")
+ bOK = true
+ oldPosition = oObj.getReferencePosition()
+
+ newPosition.sheet = oldPosition.sheet
+ newPosition.row = oldPosition.row + 1
+ newPosition.column = oldPosition.column + 1
+ oObj.setReferencePosition(newPosition)
+ position = oObj.getReferencePosition()
+
+ bOK = bOK AND NOT isNULL(position)
+ bOK = bOK AND position.Row &lt;&gt; oldPosition.row
+ bOK = bOK AND position.Column &lt;&gt; oldPosition.Column
+
+ oObj.setReferencePosition(oldPosition)
+ Test.MethodTested("setReferencePosition()", bOK)
+
+ Test.StartMethod("getType()")
+ bOK = true
+ bOK = bOK AND NOT isNULL(oObj.getType)
+ Test.MethodTested("getType()", bOK)
+
+ Test.StartMethod("setType()")
+ bOK = true
+ oldType = oObj.getType()
+ newType = oldType XOR com.sun.star.sheet.NamedRangeFlag.PRINT_AREA
+ oObj.setType(newType)
+ bOK = bOK AND (oldType &lt;&gt; oObj.getType())
+ oObj.setType(oldType)
+ Test.MethodTested("setType()", bOK)
+
+Exit Sub
+ErrHndl:
+ Test.Exception()
+ bOK = false
+ resume next
+End Sub
+</script:module>