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_ScCellsObj" 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
36cdf0e10cSrcweirSub CreateObj()
37cdf0e10cSrcweir
38cdf0e10cSrcweir'*************************************************************************
39cdf0e10cSrcweir' COMPONENT:
40cdf0e10cSrcweir' sc.ScCellsObj
41cdf0e10cSrcweir'*************************************************************************
42cdf0e10cSrcweirOn Error Goto ErrHndl
43cdf0e10cSrcweir    Dim bOK As Boolean
44cdf0e10cSrcweir    Dim oCell1, oCell2, oCell3, oSheet As Object
45cdf0e10cSrcweir    Dim oCellsRange, oCells As Variant
46cdf0e10cSrcweir
47cdf0e10cSrcweir    bOK = true
48cdf0e10cSrcweir    oDoc = utils.createDocument("scalc", cObjectName)
49cdf0e10cSrcweir    oSheet = oDoc.Sheets(0)
50cdf0e10cSrcweir
51cdf0e10cSrcweir    ' Filling some cells with the text
52cdf0e10cSrcweir    oCell1 = oSheet.getCellByPosition(0, 0)
53cdf0e10cSrcweir    oCell1.setString("ScCellsObj, Cell 1")
54cdf0e10cSrcweir    oCell2 = oSheet.getCellByPosition(4, 2)
55cdf0e10cSrcweir    oCell2.setString("ScCellsObj, Cell 2")
56cdf0e10cSrcweir    oCell3 = oSheet.getCellByPosition(3, 3)
57cdf0e10cSrcweir    oCell3.setValue(-10)
58cdf0e10cSrcweir
59cdf0e10cSrcweir    oCellsRange = oSheet.queryVisibleCells
60cdf0e10cSrcweir    oCells = oCellsRange.getCells
61cdf0e10cSrcweir
62cdf0e10cSrcweir    oObj = oCells
63cdf0e10cSrcweir
64cdf0e10cSrcweir
65cdf0e10cSrcweirExit Sub
66cdf0e10cSrcweirErrHndl:
67cdf0e10cSrcweir    Test.Exception()
68cdf0e10cSrcweirEnd Sub
69cdf0e10cSrcweir</script:module>
70