1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd"> 3*b1cdbd2cSJim Jagielski<script:module xmlns:script="http://openoffice.org/2000/script" script:name="chart_XChartDataArray" script:language="StarBasic"> 4*b1cdbd2cSJim Jagielski 5*b1cdbd2cSJim Jagielski 6*b1cdbd2cSJim Jagielski'************************************************************************* 7*b1cdbd2cSJim Jagielski' 8*b1cdbd2cSJim Jagielski' Licensed to the Apache Software Foundation (ASF) under one 9*b1cdbd2cSJim Jagielski' or more contributor license agreements. See the NOTICE file 10*b1cdbd2cSJim Jagielski' distributed with this work for additional information 11*b1cdbd2cSJim Jagielski' regarding copyright ownership. The ASF licenses this file 12*b1cdbd2cSJim Jagielski' to you under the Apache License, Version 2.0 (the 13*b1cdbd2cSJim Jagielski' "License"); you may not use this file except in compliance 14*b1cdbd2cSJim Jagielski' with the License. You may obtain a copy of the License at 15*b1cdbd2cSJim Jagielski' 16*b1cdbd2cSJim Jagielski' http://www.apache.org/licenses/LICENSE-2.0 17*b1cdbd2cSJim Jagielski' 18*b1cdbd2cSJim Jagielski' Unless required by applicable law or agreed to in writing, 19*b1cdbd2cSJim Jagielski' software distributed under the License is distributed on an 20*b1cdbd2cSJim Jagielski' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21*b1cdbd2cSJim Jagielski' KIND, either express or implied. See the License for the 22*b1cdbd2cSJim Jagielski' specific language governing permissions and limitations 23*b1cdbd2cSJim Jagielski' under the License. 24*b1cdbd2cSJim Jagielski' 25*b1cdbd2cSJim Jagielski'************************************************************************* 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski' Be sure that all variables are dimensioned: 32*b1cdbd2cSJim Jagielskioption explicit 33*b1cdbd2cSJim Jagielski 34*b1cdbd2cSJim Jagielski'************************************************************************* 35*b1cdbd2cSJim Jagielski' This Interface/Service test depends on the following GLOBAL variables, 36*b1cdbd2cSJim Jagielski' which must be specified in the object creation: 37*b1cdbd2cSJim Jagielski 38*b1cdbd2cSJim Jagielski' Global nTableH As Integer 39*b1cdbd2cSJim Jagielski' Global nTableW As Integer 40*b1cdbd2cSJim Jagielski 41*b1cdbd2cSJim Jagielski'************************************************************************* 42*b1cdbd2cSJim Jagielski 43*b1cdbd2cSJim Jagielski 44*b1cdbd2cSJim Jagielski 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski 47*b1cdbd2cSJim JagielskiSub RunTest() 48*b1cdbd2cSJim Jagielski 49*b1cdbd2cSJim Jagielski'************************************************************************* 50*b1cdbd2cSJim Jagielski' INTERFACE: 51*b1cdbd2cSJim Jagielski' com.sun.star.chart.XChartDataArray 52*b1cdbd2cSJim Jagielski'************************************************************************* 53*b1cdbd2cSJim JagielskiOn Error Goto ErrHndl 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski Dim bOK As Boolean 56*b1cdbd2cSJim Jagielski Dim i As Integer, j As Integer 57*b1cdbd2cSJim Jagielski Dim objRowDsc As Variant, objColDsc As Variant 58*b1cdbd2cSJim Jagielski Dim objEl As Variant, newEl As Variant 59*b1cdbd2cSJim Jagielski Dim chData As Variant 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski Out.Log("Object is '" + cObjectName + "'") 62*b1cdbd2cSJim Jagielski if (cObjectName = "sw.SwXTextTable") then 63*b1cdbd2cSJim Jagielski Out.Log("Object is 'SwXTextTable'. First, remove labels.") 64*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartRowAsLabel", false) 65*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartColumnAsLabel", false) 66*b1cdbd2cSJim Jagielski end if 67*b1cdbd2cSJim Jagielski 68*b1cdbd2cSJim Jagielski Test.StartMethod("getData()") 69*b1cdbd2cSJim Jagielski bOK = true 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski Dim oData As Object 72*b1cdbd2cSJim Jagielski oData = oObj.getData() 73*b1cdbd2cSJim Jagielski bOK = bOK AND NOT isNULL(oData) 74*b1cdbd2cSJim Jagielski Test.MethodTested("getData()", bOK) 75*b1cdbd2cSJim Jagielski 76*b1cdbd2cSJim Jagielski Test.StartMethod("setData()") 77*b1cdbd2cSJim Jagielski bOK = true 78*b1cdbd2cSJim Jagielski 79*b1cdbd2cSJim Jagielski Dim newData(nTableH - 1) As Variant 80*b1cdbd2cSJim Jagielski Dim a(nTableW - 1) As Double 81*b1cdbd2cSJim Jagielski 82*b1cdbd2cSJim Jagielski for i = 0 to nTableH - 1 83*b1cdbd2cSJim Jagielski ReDim a(nTableW - 1) As Double 84*b1cdbd2cSJim Jagielski for j = 0 to nTableW - 1 85*b1cdbd2cSJim Jagielski a(j) = ((nTableW * 4) / (i + 2) + j * 2) + 16 86*b1cdbd2cSJim Jagielski next j 87*b1cdbd2cSJim Jagielski newData(i) = a() 88*b1cdbd2cSJim Jagielski next i 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski oObj.setData(newData()) 91*b1cdbd2cSJim Jagielski chData = oObj.getData() 92*b1cdbd2cSJim Jagielski 93*b1cdbd2cSJim Jagielski bOK = bOK AND ubound(oObj.getRowDescriptions()) = nTableH - 1 94*b1cdbd2cSJim Jagielski bOK = bOK AND ubound(oObj.getColumnDescriptions()) = nTableW - 1 95*b1cdbd2cSJim Jagielski 96*b1cdbd2cSJim Jagielski for i = 0 to nTableH - 1 97*b1cdbd2cSJim Jagielski objEl = chData(i) 98*b1cdbd2cSJim Jagielski newEl = newData(i) 99*b1cdbd2cSJim Jagielski for j = 0 to nTableW - 1 100*b1cdbd2cSJim Jagielski bOK = bOK AND objEl(j) = newEl(j) 101*b1cdbd2cSJim Jagielski next j 102*b1cdbd2cSJim Jagielski next i 103*b1cdbd2cSJim Jagielski 104*b1cdbd2cSJim Jagielski Test.MethodTested("setData()", bOK) 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski if (cObjectName = "sw.SwXTextTable") then 107*b1cdbd2cSJim Jagielski Out.Log("Object is 'SwXTextTable'. Initialize labels.") 108*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartRowAsLabel", true) 109*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartColumnAsLabel", true) 110*b1cdbd2cSJim Jagielski end if 111*b1cdbd2cSJim Jagielski 112*b1cdbd2cSJim Jagielski Test.StartMethod("getRowDescriptions()") 113*b1cdbd2cSJim Jagielski bOK = true 114*b1cdbd2cSJim Jagielski 115*b1cdbd2cSJim Jagielski Dim oRowDsc() As String 116*b1cdbd2cSJim Jagielski oRowDsc = oObj.getRowDescriptions() 117*b1cdbd2cSJim Jagielski bOK = bOK AND NOT isNULL(oRowDsc) 118*b1cdbd2cSJim Jagielski Test.MethodTested("getRowDescriptions()", bOK) 119*b1cdbd2cSJim Jagielski 120*b1cdbd2cSJim Jagielski Test.StartMethod("setRowDescriptions()") 121*b1cdbd2cSJim Jagielski bOK = true 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski Dim newRowDsc(nTableH - 2) As String 124*b1cdbd2cSJim Jagielski for i = 0 to nTableH - 2 ' -1 for 0-index and -1 for columns labels 125*b1cdbd2cSJim Jagielski newRowDsc(i) = "RowDsc " + i 126*b1cdbd2cSJim Jagielski next i 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski oObj.setRowDescriptions(newRowDsc()) 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski objRowDsc = oObj.getRowDescriptions() 131*b1cdbd2cSJim Jagielski 132*b1cdbd2cSJim Jagielski for i = 0 to nTableH - 2 133*b1cdbd2cSJim Jagielski bOK = bOK AND newRowDsc(i) = objRowDsc(i) 134*b1cdbd2cSJim Jagielski next i 135*b1cdbd2cSJim Jagielski 136*b1cdbd2cSJim Jagielski Test.MethodTested("setRowDescriptions()", bOK) 137*b1cdbd2cSJim Jagielski 138*b1cdbd2cSJim Jagielski Test.StartMethod("getColumnDescriptions()") 139*b1cdbd2cSJim Jagielski bOK = true 140*b1cdbd2cSJim Jagielski bOK = bOK AND NOT isNULL(oObj.getColumnDescriptions()) 141*b1cdbd2cSJim Jagielski Test.MethodTested("getColumnDescriptions()", bOK) 142*b1cdbd2cSJim Jagielski 143*b1cdbd2cSJim Jagielski Test.StartMethod("setColumnDescriptions()") 144*b1cdbd2cSJim Jagielski bOK = true 145*b1cdbd2cSJim Jagielski 146*b1cdbd2cSJim Jagielski Dim newColDsc(nTableW - 2) As String 147*b1cdbd2cSJim Jagielski for i = 0 to nTableW - 2 148*b1cdbd2cSJim Jagielski newColDsc(i) = "ColDsc " + i 149*b1cdbd2cSJim Jagielski next i 150*b1cdbd2cSJim Jagielski 151*b1cdbd2cSJim Jagielski oObj.setColumnDescriptions(newColDsc()) 152*b1cdbd2cSJim Jagielski 153*b1cdbd2cSJim Jagielski objColDsc = oObj.getColumnDescriptions() 154*b1cdbd2cSJim Jagielski 155*b1cdbd2cSJim Jagielski for i = 0 to nTableW - 2 156*b1cdbd2cSJim Jagielski bOK = bOK AND newColDsc(i) = objColDsc(i) 157*b1cdbd2cSJim Jagielski next i 158*b1cdbd2cSJim Jagielski 159*b1cdbd2cSJim Jagielski if (cObjectName = "sw.SwXTextTable") then 160*b1cdbd2cSJim Jagielski Out.Log("Object is 'SwXTextTable'. Remove labels finally.") 161*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartRowAsLabel", false) 162*b1cdbd2cSJim Jagielski oObj.setPropertyValue("ChartColumnAsLabel", false) 163*b1cdbd2cSJim Jagielski end if 164*b1cdbd2cSJim Jagielski 165*b1cdbd2cSJim Jagielski Test.MethodTested("setColumnDescriptions()", bOK) 166*b1cdbd2cSJim Jagielski 167*b1cdbd2cSJim Jagielski 168*b1cdbd2cSJim JagielskiExit Sub 169*b1cdbd2cSJim JagielskiErrHndl: 170*b1cdbd2cSJim Jagielski Test.Exception() 171*b1cdbd2cSJim Jagielski bOK = false 172*b1cdbd2cSJim Jagielski resume next 173*b1cdbd2cSJim JagielskiEnd Sub 174*b1cdbd2cSJim Jagielski</script:module> 175