1<?xml version="1.0" encoding="UTF-8"?> 2<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd"> 3<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sheet_XCellRangeData" script:language="StarBasic"> 4 5 6'************************************************************************* 7' 8' Licensed to the Apache Software Foundation (ASF) under one 9' or more contributor license agreements. See the NOTICE file 10' distributed with this work for additional information 11' regarding copyright ownership. The ASF licenses this file 12' to you under the Apache License, Version 2.0 (the 13' "License"); you may not use this file except in compliance 14' with the License. You may obtain a copy of the License at 15' 16' http://www.apache.org/licenses/LICENSE-2.0 17' 18' Unless required by applicable law or agreed to in writing, 19' software distributed under the License is distributed on an 20' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21' KIND, either express or implied. See the License for the 22' specific language governing permissions and limitations 23' under the License. 24' 25'************************************************************************* 26 27 28 29' Be sure that all variables are dimensioned: 30option explicit 31 32'************************************************************************* 33' This Interface/Service test depends on the following GLOBAL variables, 34' which must be specified in the object creation: 35 36'Global newData As Variant 37 38'************************************************************************* 39 40Sub RunTest() 41 42'************************************************************************* 43' INTERFACE: 44' com.sun.star.sheet.XCellRangeData 45'************************************************************************* 46On Error Goto ErrHndl 47 Dim bOK As Boolean 48 Dim data As Variant 49 Dim myNewData as Variant 50 51 Test.StartMethod("getDataArray()") 52 data = oObj.getDataArray() 53 bOK = Not IsEmpty(data) AND ubound(data) > 0 54 Test.MethodTested("getDataArray()", bOK) 55 56 Test.StartMethod("setDataArray()") 57 oObj.setDataArray(createUnoValue("[][]any",newData)) 58 data = oObj.getDataArray() 59 bOK = equals(data, newData) 60 Test.MethodTested("setDataArray()", bOK) 61Exit Sub 62ErrHndl: 63 Test.Exception() 64 bOK = false 65 resume next 66End Sub 67</script:module> 68