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=
"sc_ScStyleObj" script:
language=
"StarBasic">
6 '*************************************************************************
8 ' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 ' Copyright
2008 by Sun Microsystems, Inc.
12 ' OpenOffice.org - a multi-platform office productivity suite
14 ' $RCSfile: sc_ScStyleObj.xba,v $
18 ' This file is part of OpenOffice.org.
20 ' OpenOffice.org is free software: you can redistribute it and/or modify
21 ' it under the terms of the GNU Lesser General Public License version
3
22 ' only, as published by the Free Software Foundation.
24 ' OpenOffice.org is distributed in the hope that it will be useful,
25 ' but WITHOUT ANY WARRANTY; without even the implied warranty of
26 ' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
27 ' GNU Lesser General Public License version
3 for more details
28 ' (a copy is included in the LICENSE file that accompanied this code).
30 ' You should have received a copy of the GNU Lesser General Public License
31 ' version
3 along with OpenOffice.org. If not, see
32 '
<http://www.openoffice.org/license.html
>
33 ' for a copy of the LGPLv3 License.
35 '*************************************************************************
36 '*************************************************************************
40 ' Be sure that all variables are dimensioned:
44 ' REQUIRED VARIABLES for interface/service tests:
46 ' Requiered for com.sun.star.container.XNamed
47 Global cNameToSet As String '
"fixed" if name is fixed
49 ' Requiered for com.sun.star.style.XStyle
50 Global oStandartStyle As Object
55 '*************************************************************************
58 '*************************************************************************
60 Dim oStyleFamilies, aElementNames As Variant
61 Dim oCell, oStyleFamily, oNew As Object
63 oDoc = utils.createDocument(
"scalc", cObjectName)
64 oCell = oDoc.Sheets(
0).getCellByPosition(
0,
0)
65 oStyleFamilies = oDoc.StyleFamilies
66 aElementNames = oStyleFamilies.Elementnames
67 oNew = oDoc.createInstance(
"com.sun.star.style.CellStyle")
68 oStyleFamily = oStyleFamilies.getByIndex(
0)'
69 oStyleFamily.insertByName(
"Dummy", oNew)
70 oObj = oStyleFamily.getByName(
"Dummy")
72 oCell.setPropertyValue(
"CellStyle",
"Dummy")
74 cNameToSet = aElementNames(
0)
75 oStandartStyle = oStyleFamily.getByIndex(
0)