diff options
Diffstat (limited to 'qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba')
-rw-r--r-- | qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba | 103 |
1 files changed, 0 insertions, 103 deletions
diff --git a/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba b/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba deleted file mode 100644 index e6956b4cb952..000000000000 --- a/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba +++ /dev/null @@ -1,103 +0,0 @@ -<?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="sc_ScTableConditionalEntry" script:language="StarBasic"> - - -'************************************************************************* -' -' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. -' -' Copyright 2000, 2010 Oracle and/or its affiliates. -' -' OpenOffice.org - a multi-platform office productivity suite -' -' This file is part of OpenOffice.org. -' -' OpenOffice.org is free software: you can redistribute it and/or modify -' it under the terms of the GNU Lesser General Public License version 3 -' only, as published by the Free Software Foundation. -' -' OpenOffice.org is distributed in the hope that it will be useful, -' but WITHOUT ANY WARRANTY; without even the implied warranty of -' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -' GNU Lesser General Public License version 3 for more details -' (a copy is included in the LICENSE file that accompanied this code). -' -' You should have received a copy of the GNU Lesser General Public License -' version 3 along with OpenOffice.org. If not, see -' <http://www.openoffice.org/license.html> -' for a copy of the LGPLv3 License. -' -'************************************************************************* -'************************************************************************* - - - -' Be sure that all variables are dimensioned: -option explicit - - - -Sub CreateObj() - -'************************************************************************* -' COMPONENT: -' sc.ScTableConditionalEntry -'************************************************************************* -On Error Goto ErrHndl - Dim bOK As Boolean - Dim oSheet, oConditionalFormat As Object - - bOK = true - oDoc = utils.createDocument("scalc", cObjectName) - - oSheet = oDoc.Sheets(0) - oSheet.getCellByPosition(5, 5).Value = 15 - oSheet.getCellByPosition(1, 4).Value = 10 - oSheet.getCellByPosition(2, 0).Value = -5.15 - - oConditionalFormat = oSheet.getPropertyValue("ConditionalFormat") - - Dim oCellAddress As New com.sun.star.table.CellAddress - oCellAddress.Sheet = 0 - oCellAddress.Row = 1 - oCellAddress.Column = 5 - - Dim oProps(4) As New com.sun.star.beans.PropertyValue - oProps(0).Name = "StyleName" - oProps(0).Value = "Result2" - oProps(1).Name = "Formula1" - oProps(1).Value = "$Sheet1.$B$5" - oProps(2).Name = "Formula2" - oProps(2).Value = "" - oProps(3).Name = "Operator" - oProps(3).Value = com.sun.star.sheet.ConditionOperator.EQUAL - oProps(4).Name = "SourcePosition" - oProps(4).Value = oCellAddress - - oConditionalFormat.AddNew(oProps()) - - oCellAddress.Sheet = 0 - oCellAddress.Row = 1 - oCellAddress.Column = 5 - - oProps(0).Name = "StyleName" - oProps(0).Value = "Result2" - oProps(1).Name = "Formula1" - oProps(1).Value = "$Sheet1.$B$3" - oProps(2).Name = "Formula2" - oProps(2).Value = "" - oProps(3).Name = "Operator" - oProps(3).Value = com.sun.star.sheet.ConditionOperator.EQUAL - oProps(4).Name = "SourcePosition" - oProps(4).Value = oCellAddress - - oConditionalFormat.AddNew(oProps()) - - oObj = oConditionalFormat.getByIndex(0) - -Exit Sub -ErrHndl: - Test.Exception() -End Sub -</script:module> |