1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3cdf0e10cSrcweir<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sc_ScDataPilotTablesObj" script:language="StarBasic">
4cdf0e10cSrcweir
5cdf0e10cSrcweir
6cdf0e10cSrcweir'*************************************************************************
7cdf0e10cSrcweir'
8*5846f787SAndrew Rist'  Licensed to the Apache Software Foundation (ASF) under one
9*5846f787SAndrew Rist'  or more contributor license agreements.  See the NOTICE file
10*5846f787SAndrew Rist'  distributed with this work for additional information
11*5846f787SAndrew Rist'  regarding copyright ownership.  The ASF licenses this file
12*5846f787SAndrew Rist'  to you under the Apache License, Version 2.0 (the
13*5846f787SAndrew Rist'  "License"); you may not use this file except in compliance
14*5846f787SAndrew Rist'  with the License.  You may obtain a copy of the License at
15*5846f787SAndrew Rist'
16*5846f787SAndrew Rist'    http://www.apache.org/licenses/LICENSE-2.0
17*5846f787SAndrew Rist'
18*5846f787SAndrew Rist'  Unless required by applicable law or agreed to in writing,
19*5846f787SAndrew Rist'  software distributed under the License is distributed on an
20*5846f787SAndrew Rist'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
21*5846f787SAndrew Rist'  KIND, either express or implied.  See the License for the
22*5846f787SAndrew Rist'  specific language governing permissions and limitations
23*5846f787SAndrew Rist'  under the License.
24cdf0e10cSrcweir'
25cdf0e10cSrcweir'*************************************************************************
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir
29*5846f787SAndrew Rist
30*5846f787SAndrew Rist
31cdf0e10cSrcweir' Be sure that all variables are dimensioned:
32cdf0e10cSrcweiroption explicit
33cdf0e10cSrcweir
34cdf0e10cSrcweir
35cdf0e10cSrcweir' REQUIRED VARIABLES for interface/service tests:
36cdf0e10cSrcweirGlobal nGlobalLong As Long
37cdf0e10cSrcweir
38cdf0e10cSrcweir
39cdf0e10cSrcweirSub CreateObj()
40cdf0e10cSrcweir
41cdf0e10cSrcweir'*************************************************************************
42cdf0e10cSrcweir' COMPONENT:
43cdf0e10cSrcweir' sc.ScDataPilotTablesObj
44cdf0e10cSrcweir'*************************************************************************
45cdf0e10cSrcweirOn Error Goto ErrHndl
46cdf0e10cSrcweir    Dim bOK As Boolean
47cdf0e10cSrcweir    Dim i as Integer,j As Integer
48cdf0e10cSrcweir    Dim oSheet as Object, oDataPilotDescriptor As Object
49cdf0e10cSrcweir    Dim oDataPilotTables As Variant
50cdf0e10cSrcweir
51cdf0e10cSrcweir    bOK = true
52cdf0e10cSrcweir    oDoc = utils.createDocument("scalc", cObjectName)
53cdf0e10cSrcweir    oSheet = oDoc.Sheets.getByIndex(0)
54cdf0e10cSrcweir
55cdf0e10cSrcweir    for i = 1 to 5
56cdf0e10cSrcweir        for j = 1 to 5
57cdf0e10cSrcweir            oSheet.getCellByPosition(i, j).Value = 2.5 * j + i
58cdf0e10cSrcweir        next j
59cdf0e10cSrcweir    next i
60cdf0e10cSrcweir
61cdf0e10cSrcweir    Dim sCellRangeAddress As New com.sun.star.table.CellRangeAddress
62cdf0e10cSrcweir    sCellRangeAddress.Sheet = 0
63cdf0e10cSrcweir    sCellRangeAddress.StartColumn = 1
64cdf0e10cSrcweir    sCellRangeAddress.StartRow = 1
65cdf0e10cSrcweir    sCellRangeAddress.EndColumn = 5
66cdf0e10cSrcweir    sCellRangeAddress.EndRow = 5
67cdf0e10cSrcweir
68cdf0e10cSrcweir    Dim sCellAddress As New com.sun.star.table.CellAddress
69cdf0e10cSrcweir    sCellAddress.Sheet = 0
70cdf0e10cSrcweir    sCellAddress.Column = 7
71cdf0e10cSrcweir    sCellAddress.Row = 8
72cdf0e10cSrcweir
73cdf0e10cSrcweir    oDataPilotTables = oSheet.getDataPilotTables
74cdf0e10cSrcweir    oDataPilotDescriptor = oDataPilotTables.createDataPilotDescriptor()
75cdf0e10cSrcweir    oDataPilotDescriptor.setSourceRange(sCellRangeAddress)
76cdf0e10cSrcweir
77cdf0e10cSrcweir    oDataPilotTables.insertNewByName(cObjectName, sCellAddress, oDataPilotDescriptor)
78cdf0e10cSrcweir
79cdf0e10cSrcweir    oObj = oDataPilotTables
80cdf0e10cSrcweir    nGlobalLong = oObj.Count
81cdf0e10cSrcweir
82cdf0e10cSrcweirExit Sub
83cdf0e10cSrcweirErrHndl:
84cdf0e10cSrcweir    Test.Exception()
85cdf0e10cSrcweirEnd Sub
86cdf0e10cSrcweir</script:module>
87