summaryrefslogtreecommitdiff
path: root/qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba
diff options
context:
space:
mode:
Diffstat (limited to 'qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba')
-rw-r--r--qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba89
1 files changed, 89 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba b/qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba
new file mode 100644
index 000000000000..74078410d2b1
--- /dev/null
+++ b/qadevOOo/tests/basic/mod/sc/ScIndexEnumeration_DataPilotTablesEnumeration/sc_ScIndexEnumeration_DataPilotTablesEnumeration.xba
@@ -0,0 +1,89 @@
+<?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="sc_ScIndexEnumeration_DataPilotTablesEnumeration" 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
+
+
+' REQUIRED VARIABLES for interface/service tests:
+
+
+Sub CreateObj()
+
+'*************************************************************************
+' COMPONENT:
+' sc.ScIndexEnumeration_DataPilotTablesEnumeration
+'*************************************************************************
+On Error Goto ErrHndl
+
+ Dim bOK As Boolean
+ Dim i as Integer,j As Integer
+ Dim oSheet as Object, oDataPilotDescriptor As Object
+ Dim oDataPilotTables As Variant
+
+ bOK = true
+ oDoc = utils.createDocument("scalc", cObjectName)
+ oSheet = oDoc.Sheets.getByIndex(0)
+
+ for i = 1 to 5
+ for j = 1 to 5
+ oSheet.getCellByPosition(i, j).Value = 2.5 * j + i
+ next j
+ next i
+
+ Dim sCellRangeAddress As New com.sun.star.table.CellRangeAddress
+ sCellRangeAddress.Sheet = 0
+ sCellRangeAddress.StartColumn = 1
+ sCellRangeAddress.StartRow = 1
+ sCellRangeAddress.EndColumn = 5
+ sCellRangeAddress.EndRow = 5
+
+ Dim sCellAddress As New com.sun.star.table.CellAddress
+ sCellAddress.Sheet = 0
+ sCellAddress.Column = 7
+ sCellAddress.Row = 8
+
+ oDataPilotTables = oSheet.getDataPilotTables
+ oDataPilotDescriptor = oDataPilotTables.createDataPilotDescriptor()
+ oDataPilotDescriptor.setSourceRange(sCellRangeAddress)
+
+ oDataPilotTables.insertNewByName(cObjectName, sCellAddress, oDataPilotDescriptor)
+
+ oObj = oDataPilotTables.createEnumeration()
+
+Exit Sub
+ErrHndl:
+ Test.Exception()
+End Sub
+</script:module>