diff options
Diffstat (limited to 'qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba')
-rw-r--r-- | qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba | 80 |
1 files changed, 80 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba b/qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba new file mode 100644 index 000000000000..f700d2c2bf7c --- /dev/null +++ b/qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba @@ -0,0 +1,80 @@ +<?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_XScenarios" 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.XScenarios +'************************************************************************* +On Error Goto ErrHndl + Dim bOK As Boolean + Dim nCount As Integer + Dim aCRA(1) As New com.sun.star.table.CellRangeAddress + + aCRA(0).Sheet = 0 : aCRA(1).Sheet = 0 + aCRA(0).StartColumn = 3 : aCRA(1).StartColumn = 13 + aCRA(0).StartRow = 4 : aCRA(1).StartRow = 14 + aCRA(0).EndColumn = 8 : aCRA(1).EndColumn = 18 + aCRA(0).EndRow = 9 : aCRA(1).EndRow = 19 + + Test.StartMethod("addNewByName()") + bOK = true + nCount = oObj.getCount() + Out.Log("Initialy there are " & nCount & " scenarios.") + oObj.addNewByName("NewScenario", aCRA(), "New comment") + Out.Log("After inserting there are " & oObj.getCount() & " scenarios.") + bOK = bOK AND oObj.getCount() = nCount + 1 + Test.MethodTested("addNewByName()", bOK) + + Test.StartMethod("removeByName()") + bOK = true + oObj.removeByName("NewScenario") + Out.Log("After removing there are " & oObj.getCount() & " scenarios.") + bOK = bOK AND oObj.getCount() = nCount + Test.MethodTested("removeByName()", bOK) + +Exit Sub +ErrHndl: + Test.Exception() + bOK = false + resume next +End Sub +</script:module> |