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="text_XTextTable" 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 nTableW As Integer 39*b1cdbd2cSJim Jagielski' - Global nTableH 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.text.XTextTable 52*b1cdbd2cSJim Jagielski'************************************************************************* 53*b1cdbd2cSJim JagielskiOn Error Goto ErrHndl 54*b1cdbd2cSJim Jagielski Dim bOK As Boolean 55*b1cdbd2cSJim Jagielski Dim i As Integer, j As Integer 56*b1cdbd2cSJim Jagielski Dim oRows As Object, oColumns As Object 57*b1cdbd2cSJim Jagielski Dim oCursor As Object, oCell As Object 58*b1cdbd2cSJim Jagielski Dim aNames As Variant 59*b1cdbd2cSJim Jagielski Dim nDscColumns As Integer, nDscRows As Integer 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski Test.StartMethod("initialize()") 62*b1cdbd2cSJim Jagielski bOK = true 63*b1cdbd2cSJim Jagielski ' Object is already was initialized, when it was created... So, assume that this is OK. 64*b1cdbd2cSJim Jagielski 65*b1cdbd2cSJim Jagielski For i = 0 to nTableW - 1 66*b1cdbd2cSJim Jagielski For j = 0 to nTableH - 1 67*b1cdbd2cSJim Jagielski oObj.getCellByPosition(i, j).Value = i + j * nTableW 68*b1cdbd2cSJim Jagielski Next j 69*b1cdbd2cSJim Jagielski Next i 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski nDscColumns = ubound(oObj.getColumnDescriptions()) + 1 72*b1cdbd2cSJim Jagielski nDscRows = ubound(oObj.getRowDescriptions()) + 1 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski bOK = bOK AND nDscRows = nTableH AND nDscColumns = nTableW 75*b1cdbd2cSJim Jagielski if NOT bOK then 76*b1cdbd2cSJim Jagielski Out.Log("The table must have size (" + nTableW + "," + nTableH + _ 77*b1cdbd2cSJim Jagielski "), but descriptions returned for size (" + nDscColumns + "," + nDscRows + ")") 78*b1cdbd2cSJim Jagielski endif 79*b1cdbd2cSJim Jagielski Test.MethodTested("initialize()", bOK) 80*b1cdbd2cSJim Jagielski 81*b1cdbd2cSJim Jagielski Test.StartMethod("getRows()") 82*b1cdbd2cSJim Jagielski bOK = true 83*b1cdbd2cSJim Jagielski 84*b1cdbd2cSJim Jagielski oRows = oObj.getRows() 85*b1cdbd2cSJim Jagielski 86*b1cdbd2cSJim Jagielski bOK = bOK AND hasUnoInterfaces(oRows, "com.sun.star.table.XTableRows") 87*b1cdbd2cSJim Jagielski bOK = bOK AND oRows.getCount() = nTableH 88*b1cdbd2cSJim Jagielski Test.MethodTested("getRows()", bOK) 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski Test.StartMethod("getColumns()") 91*b1cdbd2cSJim Jagielski bOK = true 92*b1cdbd2cSJim Jagielski 93*b1cdbd2cSJim Jagielski oColumns = oObj.getColumns() 94*b1cdbd2cSJim Jagielski 95*b1cdbd2cSJim Jagielski bOK = bOK AND hasUnoInterfaces(oColumns, "com.sun.star.table.XTableColumns") 96*b1cdbd2cSJim Jagielski bOK = bOK AND oColumns.getCount() = nTableW 97*b1cdbd2cSJim Jagielski Test.MethodTested("getColumns()", bOK) 98*b1cdbd2cSJim Jagielski 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski Test.StartMethod("createCursorByCellName()") 101*b1cdbd2cSJim Jagielski bOK = true 102*b1cdbd2cSJim Jagielski oCursor = oObj.createCursorByCellName("B2") 103*b1cdbd2cSJim Jagielski bOK = bOK AND hasUnoInterfaces(oCursor, "com.sun.star.text.XTextTableCursor") 104*b1cdbd2cSJim Jagielski bOK = bOK AND oCursor.getRangeName() = "B2" 105*b1cdbd2cSJim Jagielski Test.MethodTested("createCursorByCellName()", bOK) 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski oCursor.splitRange(1, true) 108*b1cdbd2cSJim Jagielski oCursor.splitRange(1, false) 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski Test.StartMethod("getCellNames()") 111*b1cdbd2cSJim Jagielski bOK = true 112*b1cdbd2cSJim Jagielski aNames = oObj.getCellNames() 113*b1cdbd2cSJim Jagielski bOK = bOK AND ubound(aNames) = nTableW * nTableH + 1 ' = nTableW * nTableH - 1 + 2(after splitting) 114*b1cdbd2cSJim Jagielski Test.MethodTested("getCellNames()", bOK) 115*b1cdbd2cSJim Jagielski 116*b1cdbd2cSJim Jagielski Test.StartMethod("getCellByName()") 117*b1cdbd2cSJim Jagielski bOK = true 118*b1cdbd2cSJim Jagielski oCell = oObj.getCellByPosition(0,0) 119*b1cdbd2cSJim Jagielski oCell.String = "A1" 120*b1cdbd2cSJim Jagielski oCell = oObj.getCellByName("A1") 121*b1cdbd2cSJim Jagielski bOK = bOK AND oCell.String = "A1" 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski oCell = oObj.getCellByName("B2.2.1") 124*b1cdbd2cSJim Jagielski bOK = bOK AND hasUnoInterfaces(oCell, "com.sun.star.table.XCell") 125*b1cdbd2cSJim Jagielski 126*b1cdbd2cSJim Jagielski Test.MethodTested("getCellByName()", bOK) 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski ReCreateObj() 129*b1cdbd2cSJim JagielskiExit Sub 130*b1cdbd2cSJim JagielskiErrHndl: 131*b1cdbd2cSJim Jagielski Test.Exception() 132*b1cdbd2cSJim Jagielski bOK = false 133*b1cdbd2cSJim Jagielski resume next 134*b1cdbd2cSJim JagielskiEnd Sub 135*b1cdbd2cSJim Jagielski</script:module> 136