1 files changed, 103 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba b/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba
new file mode 100644
index 000000000000..e6956b4cb952
--- /dev/null
+++ b/qadevOOo/tests/basic/mod/sc/ScTableConditionalEntry/sc_ScTableConditionalEntry.xba
@@ -0,0 +1,103 @@
+<?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>