1 files changed, 138 insertions, 0 deletions
diff --git a/qadevOOo/tests/basic/mod/sc/ScTableConditionalFormat/sc_ScTableConditionalFormat.xba b/qadevOOo/tests/basic/mod/sc/ScTableConditionalFormat/sc_ScTableConditionalFormat.xba
new file mode 100644
index 000000000000..501f2e524921
--- /dev/null
+++ b/qadevOOo/tests/basic/mod/sc/ScTableConditionalFormat/sc_ScTableConditionalFormat.xba
@@ -0,0 +1,138 @@
+<?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_ScTableConditionalFormat" script:language="StarBasic">
+
+
+'*************************************************************************
+'*
+'*  $RCSfile: sc_ScTableConditionalFormat.xba,v $ 
+'*
+'*  $Revision: 1.1 $ 
+'*
+'*  last change:$Date: 2003-01-27 18:00:41 $ 
+'*
+'*  The Contents of this file are made available subject to the terms of
+'*  either of the following licenses
+'*
+'*         - GNU Lesser General Public License Version 2.1
+'*         - Sun Industry Standards Source License Version 1.1
+'*
+'*  Sun Microsystems Inc., October, 2000
+'*
+'*  GNU Lesser General Public License Version 2.1
+'*  =============================================
+'*  Copyright 2000 by Sun Microsystems, Inc.
+'*  901 San Antonio Road, Palo Alto, CA 94303, USA
+'*
+'*  This library is free software; you can redistribute it and/or
+'*  modify it under the terms of the GNU Lesser General Public
+'*  License version 2.1, as published by the Free Software Foundation.
+'*
+'*  This library 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 for more details.
+'*
+'*  You should have received a copy of the GNU Lesser General Public
+'*  License along with this library; if not, write to the Free Software
+'*  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+'*  MA  02111-1307  USA
+'*
+'*
+'*  Sun Industry Standards Source License Version 1.1
+'*  =================================================
+'*  The contents of this file are subject to the Sun Industry Standards
+'*  Source License Version 1.1 (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.openoffice.org/license.html.
+'*
+'*  Software provided under this License is provided on an "AS IS" basis,
+'*  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
+'*  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
+'*  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
+'*  See the License for the specific provisions governing your rights and
+'*  obligations concerning the Software.
+'*
+'*  The Initial Developer of the Original Code is: Sun Microsystems, Inc.
+'*
+'*  Copyright: 2000 by Sun Microsystems, Inc.
+'*
+'*  All Rights Reserved.
+'*
+'*  Contributor(s): _______________________________________
+'*
+'*
+'*************************************************************************
+'*************************************************************************
+
+
+
+' Be sure that all variables are dimensioned:
+option explicit
+
+
+
+Sub CreateObj()
+
+'*************************************************************************
+' COMPONENT: 
+' sc.ScTableConditionalFormat
+'*************************************************************************
+On Error Goto ErrHndl
+    Dim oSheet As Object
+
+    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
+
+    oObj = 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
+
+    oObj.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
+
+    oObj.AddNew(oProps())
+
+Exit Sub
+ErrHndl:
+    Test.Exception()
+End Sub
+
+Sub ReCreateObj()
+    if not isNULL(oDoc) then oDoc.dispose()
+    CreateObj()
+End Sub
+</script:module>