AOO410/main/qadevOOo/tests/basic/ifc/sheet/XSheetCellRanges/sheet_XSheetCellRanges.xba

<?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="sheet_XSheetCellRanges" script:language="StarBasic">


'*************************************************************************
'
'  Licensed to the Apache Software Foundation (ASF) under one
'  or more contributor license agreements.  See the NOTICE file
'  distributed with this work for additional information
'  regarding copyright ownership.  The ASF licenses this file
'  to you under the Apache License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0
'  
'  Unless required by applicable law or agreed to in writing,
'  software distributed under the License is distributed on an
'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
'  KIND, either express or implied.  See the License for the
'  specific language governing permissions and limitations
'  under the License.
'
'*************************************************************************





' Be sure that all variables are dimensioned:
option explicit



Sub RunTest()

'*************************************************************************
' INTERFACE: 
' com.sun.star.sheet.XSheetCellRanges
'*************************************************************************
On Error Goto ErrHndl
    Dim bOK As Boolean
    Dim oCells, oRanges As Variant
    Dim cRanges As String

    Test.StartMethod("getCells()")
    bOK = true
    oCells = oObj.getCells()
    bOK = bOK AND hasUnoInterfaces(oCells, "com.sun.star.container.XEnumerationAccess")
    Test.MethodTested("getCells()", bOK)

    Test.StartMethod("getRangeAddressesAsString()")
    bOK = true
    cRanges = oObj.getRangeAddressesAsString()
    Out.Log("Returned ranges are : '" &amp; cRanges &amp; "'")
    bOK = bOK AND inStr(1, cRanges, "Sheet")
    Test.MethodTested("getRangeAddressesAsString()", bOK)

    Test.StartMethod("getRangeAddresses()")
    bOK = true
    oRanges = oObj.getRangeAddresses()
    bOK = bOK AND (oRanges(ubound(oRanges)).StartColumn &lt;&gt; 0 OR _
                   oRanges(ubound(oRanges)).StartRow &lt;&gt; 0 OR _
                   oRanges(ubound(oRanges)).EndRow &lt;&gt; 0 OR _
                   oRanges(ubound(oRanges)).EndColumn &lt;&gt; 0 OR _
                   oRanges(ubound(oRanges)).Sheet &lt;&gt; 0)
    Test.MethodTested("getRangeAddresses()", bOK)

Exit Sub
ErrHndl:
    Test.Exception()
    bOK = false
    resume next
End Sub
</script:module>