summaryrefslogtreecommitdiff
path: root/qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba
diff options
context:
space:
mode:
Diffstat (limited to 'qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba')
-rw-r--r--qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba128
1 files changed, 128 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba b/qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba
new file mode 100644
index 000000000000..33a8c47ae408
--- /dev/null
+++ b/qadevOOo/tests/basic/mod/sc/ScDataPilotFieldsObj/sc_ScDataPilotFieldsObj.xba
@@ -0,0 +1,128 @@
+<?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_ScDataPilotFieldsObj" script:language="StarBasic">
+
+
+'*************************************************************************
+'*
+'* $RCSfile: sc_ScDataPilotFieldsObj.xba,v $
+'*
+'* $Revision: 1.1 $
+'*
+'* last change:$Date: 2003-01-27 17:59:34 $
+'*
+'* The Contents of this file are made available subject to the terms of
+'* either of the following licenses
+'*
+'* - GNU Lesser General Public License Version 2.1
+'* - Sun Industry Standards Source License Version 1.1
+'*
+'* Sun Microsystems Inc., October, 2000
+'*
+'* GNU Lesser General Public License Version 2.1
+'* =============================================
+'* Copyright 2000 by Sun Microsystems, Inc.
+'* 901 San Antonio Road, Palo Alto, CA 94303, USA
+'*
+'* This library is free software; you can redistribute it and/or
+'* modify it under the terms of the GNU Lesser General Public
+'* License version 2.1, as published by the Free Software Foundation.
+'*
+'* This library 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 for more details.
+'*
+'* You should have received a copy of the GNU Lesser General Public
+'* License along with this library; if not, write to the Free Software
+'* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+'* MA 02111-1307 USA
+'*
+'*
+'* Sun Industry Standards Source License Version 1.1
+'* =================================================
+'* The contents of this file are subject to the Sun Industry Standards
+'* Source License Version 1.1 (the "License"); You may not use this file
+'* except in compliance with the License. You may obtain a copy of the
+'* License at http://www.openoffice.org/license.html.
+'*
+'* Software provided under this License is provided on an "AS IS" basis,
+'* WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+'* WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+'* MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+'* See the License for the specific provisions governing your rights and
+'* obligations concerning the Software.
+'*
+'* The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+'*
+'* Copyright: 2000 by Sun Microsystems, Inc.
+'*
+'* All Rights Reserved.
+'*
+'* Contributor(s): _______________________________________
+'*
+'*
+'*************************************************************************
+'*************************************************************************
+
+
+
+' Be sure that all variables are dimensioned:
+option explicit
+
+
+' REQUIRED VARIABLES for interface/service tests:
+
+Global nGlobalLong As Long
+
+
+Sub CreateObj()
+
+'*************************************************************************
+' COMPONENT:
+' sc.ScDataPilotFieldsObj
+'*************************************************************************
+On Error Goto ErrHndl
+ Dim bOK As Boolean
+ Dim i as Integer,j As Integer
+ Dim oSheet as Object, oDataPilotDescriptor As Object
+ Dim oFields as Variant , oDataPilotTable As Variant
+ Dim sCellRangeAddress As New com.sun.star.table.CellRangeAddress
+ Dim sCellAddress As New com.sun.star.table.CellAddress
+
+ 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
+
+ sCellRangeAddress.Sheet = 0
+ sCellRangeAddress.StartColumn = 1
+ sCellRangeAddress.StartRow = 1
+ sCellRangeAddress.EndColumn = 5
+ sCellRangeAddress.EndRow = 5
+
+ sCellAddress.Sheet = 0
+ sCellAddress.Column = 7
+ sCellAddress.Row = 8
+
+ oDataPilotTable = oSheet.getDataPilotTables
+ oDataPilotDescriptor = oDataPilotTable.createDataPilotDescriptor()
+ oDataPilotDescriptor.setSourceRange(sCellRangeAddress)
+
+ oDataPilotTable.insertNewByName(cObjectName, sCellAddress, oDataPilotDescriptor)
+
+ oFields = oDataPilotDescriptor.getDataPilotFields
+ oObj = oFields
+ nGlobalLong = oObj.Count
+
+
+Exit Sub
+ErrHndl:
+ Test.Exception()
+End Sub
+</script:module>