conditionalformatwrapper-ag凯发旗舰厅

com.spire.xls
class conditionalformatwrapper

java.lang.object
  com.spire.xls.core.spreadsheet.commonwrapper
      com.spire.xls.conditionalformatwrapper

all implemented interfaces:

iconditionalformat, ioptimizedupdate

public class conditionalformatwrapper
extends commonwrapper
implements iconditionalformat

summary description for conditional format wrapper.

conditionalformatwrapper

public conditionalformatwrapper(condformatcollectionwrapper formats,
                                int iindex)

creates new instance of the wrapper.

parameters:

formats - parent formats collection.

iindex - condition index.

getparent

public java.lang.object getparent()

gets parent object for this object.

getpriority

public int getpriority()

description copied from interface: iconditionalformat

priority.

specified by:

getpriority in interface iconditionalformat

setpriority

public void setpriority(int priority)

description copied from interface: iconditionalformat

priority.

specified by:

setpriority in interface iconditionalformat

gettopbottom

public topbottom gettopbottom()

getaverage

public average getaverage()

getformattype

public conditionalformattype getformattype()

gets type of the conditional format.

specified by:

getformattype in interface iconditionalformat

returns:

setformattype

public void setformattype(conditionalformattype formattype)

sets type of the conditional format.

specified by:

setformattype in interface iconditionalformat

getstopiftrue

public boolean getstopiftrue()

setstopiftrue

public void setstopiftrue(boolean stopiftrue)

getoperator

public comparisonoperatortype getoperator()

gets type of the comparison operator.

specified by:

getoperator in interface iconditionalformat

returns:

setoperator

public void setoperator(comparisonoperatortype operator)

sets type of the comparison operator.

specified by:

setoperator in interface iconditionalformat

isbold

public boolean isbold()

indicates whether the font is bold.

specified by:

isbold in interface iconditionalformat

isbold

public void isbold(boolean isbold)

sets whether the font is bold.

specified by:

isbold in interface iconditionalformat

isitalic

public boolean isitalic()

indicates whether font is italic.

specified by:

isitalic in interface iconditionalformat

isitalic

public void isitalic(boolean isitalic)

sets whether font is italic.

specified by:

isitalic in interface iconditionalformat

getfontknowncolor

public excelcolors getfontknowncolor()

gets font color.

specified by:

getfontknowncolor in interface iconditionalformat

setfontknowncolor

public void setfontknowncolor(excelcolors fontknowncolor)

sets font color.

specified by:

setfontknowncolor in interface iconditionalformat

getfontcolorinner

public com.spire.ms.system.drawing.color getfontcolorinner()

gets font color.

specified by:

getfontcolorinner in interface iconditionalformat

getfontcolor

public java.awt.color getfontcolor()

gets font color.

specified by:

getfontcolor in interface iconditionalformat

returns:

setfontcolor

public void setfontcolor(java.awt.color fontcolor)

description copied from interface: iconditionalformat

sets font color.

specified by:

setfontcolor in interface iconditionalformat

getunderline

public fontunderlinetype getunderline()

gets underline type.

specified by:

getunderline in interface iconditionalformat

setunderline

public void setunderline(fontunderlinetype underline)

sets underline type.

isstrikethrough

public boolean isstrikethrough()

indicates whether font is struck through.

specified by:

isstrikethrough in interface iconditionalformat

isstrikethrough

public void isstrikethrough(boolean flag)

sets whether font is struck through.

specified by:

isstrikethrough in interface iconditionalformat

getleftborderknowncolor

public excelcolors getleftborderknowncolor()

gets color of the left line.

specified by:

getleftborderknowncolor in interface iconditionalformat

setleftborderknowncolor

public void setleftborderknowncolor(excelcolors leftborderknowncolor)

sets color of the left line.

specified by:

setleftborderknowncolor in interface iconditionalformat

getleftbordercolor

public java.awt.color getleftbordercolor()

gets color of the left line.

specified by:

getleftbordercolor in interface iconditionalformat

setleftbordercolor

public void setleftbordercolor(java.awt.color leftbordercolor)

sets color of the left line.

specified by:

setleftbordercolor in interface iconditionalformat

parameters:

leftbordercolor -

getleftborderstyle

public linestyletype getleftborderstyle()

gets left border line style.

specified by:

getleftborderstyle in interface iconditionalformat

setleftborderstyle

public void setleftborderstyle(linestyletype leftborderstyle)

sets left border line style.

specified by:

setleftborderstyle in interface iconditionalformat

getrightborderknowncolor

public excelcolors getrightborderknowncolor()

gets color of the right line.

specified by:

getrightborderknowncolor in interface iconditionalformat

setrightborderknowncolor

public void setrightborderknowncolor(excelcolors rightborderknowncolor)

sets color of the right line.

specified by:

setrightborderknowncolor in interface iconditionalformat

getrightbordercolor

public java.awt.color getrightbordercolor()

gets color of the right line.

specified by:

getrightbordercolor in interface iconditionalformat

returns:

color of the right line.

setrightbordercolor

public void setrightbordercolor(java.awt.color rightbordercolor)

color of the right line.

specified by:

setrightbordercolor in interface iconditionalformat

getrightborderstyle

public linestyletype getrightborderstyle()

gets right border line style.

specified by:

getrightborderstyle in interface iconditionalformat

setrightborderstyle

public void setrightborderstyle(linestyletype rightborderstyle)

sets right border line style.

specified by:

setrightborderstyle in interface iconditionalformat

gettopborderknowncolor

public excelcolors gettopborderknowncolor()

gets color of the top line.

specified by:

gettopborderknowncolor in interface iconditionalformat

settopborderknowncolor

public void settopborderknowncolor(excelcolors topborderknowncolor)

sets color of the top line.

specified by:

settopborderknowncolor in interface iconditionalformat

getinnertopbordercolor

public com.spire.ms.system.drawing.color getinnertopbordercolor()

gets color of the top line

gettopbordercolor

public java.awt.color gettopbordercolor()

gets color of the top line

specified by:

gettopbordercolor in interface iconditionalformat

returns:

color of the top line

settopbordercolor

public void settopbordercolor(java.awt.color topbordercolor)

sets color of the top line

specified by:

settopbordercolor in interface iconditionalformat

parameters:

topbordercolor - color of the top line

gettopborderstyle

public linestyletype gettopborderstyle()

gets top border line style.

specified by:

gettopborderstyle in interface iconditionalformat

settopborderstyle

public void settopborderstyle(linestyletype topborderstyle)

sets top border line style.

specified by:

settopborderstyle in interface iconditionalformat

getbottomborderknowncolor

public excelcolors getbottomborderknowncolor()

gets color of the bottom line.

specified by:

getbottomborderknowncolor in interface iconditionalformat

setbottomborderknowncolor

public void setbottomborderknowncolor(excelcolors bottomborderknowncolor)

sets color of the bottom line.

specified by:

setbottomborderknowncolor in interface iconditionalformat

getbottombordercolor

public java.awt.color getbottombordercolor()

gets color of the bottom line

specified by:

getbottombordercolor in interface iconditionalformat

returns:

color of the bottom line

setbottombordercolor

public void setbottombordercolor(java.awt.color bottombordercolor)

sets color of the bottom line

specified by:

setbottombordercolor in interface iconditionalformat

getbottomborderstyle

public linestyletype getbottomborderstyle()

gets bottom border line style.

specified by:

getbottomborderstyle in interface iconditionalformat

returns:

setbottomborderstyle

public void setbottomborderstyle(linestyletype bottomborderstyle)

sets bottom border line style.

specified by:

setbottomborderstyle in interface iconditionalformat

getfirstformula

public java.lang.string getfirstformula()

gets first formula.

specified by:

getfirstformula in interface iconditionalformat

returns:

setfirstformula

public void setfirstformula(java.lang.string firstformula)

sets first formula.

specified by:

setfirstformula in interface iconditionalformat

getfirstformular1c1

public java.lang.string getfirstformular1c1()

gets first formula.

setfirstformular1c1

public void setfirstformular1c1(java.lang.string firstformular1c1)

sets first formula.

getsecondformular1c1

public java.lang.string getsecondformular1c1()

gets first formula.

setsecondformular1c1

public void setsecondformular1c1(java.lang.string secondformular1c1)

sets first formula.

getsecondformula

public java.lang.string getsecondformula()

gets second formula.

specified by:

getsecondformula in interface iconditionalformat

setsecondformula

public void setsecondformula(java.lang.string secondformula)

sets second formula.

specified by:

setsecondformula in interface iconditionalformat

getknowncolor

public excelcolors getknowncolor()

gets pattern foreground color.

specified by:

getknowncolor in interface iconditionalformat

setknowncolor

public void setknowncolor(excelcolors knowncolor)

sets pattern foreground color.

specified by:

setknowncolor in interface iconditionalformat

getcolor

public java.awt.color getcolor()

gets pattern foreground color.

specified by:

getcolor in interface iconditionalformat

setcolor

public void setcolor(java.awt.color color)

sets pattern foreground color.

specified by:

setcolor in interface iconditionalformat

getbackknowncolor

public excelcolors getbackknowncolor()

gets pattern background color.

specified by:

getbackknowncolor in interface iconditionalformat

setbackknowncolor

public void setbackknowncolor(excelcolors backknowncolor)

sets pattern background color.

specified by:

setbackknowncolor in interface iconditionalformat

getbackcolor

public java.awt.color getbackcolor()

gets pattern background color.

specified by:

getbackcolor in interface iconditionalformat

returns:

setbackcolor

public void setbackcolor(java.awt.color backcolor)

sets pattern background color.

specified by:

setbackcolor in interface iconditionalformat

parameters:

backcolor -

getfillpattern

public excelpatterntype getfillpattern()

gets xls fill pattern style.

specified by:

getfillpattern in interface iconditionalformat

setfillpattern

public void setfillpattern(excelpatterntype fillpattern)

sets xls fill pattern style.

specified by:

setfillpattern in interface iconditionalformat

issuperscript

public boolean issuperscript()

indicates whether font is superscript.

specified by:

issuperscript in interface iconditionalformat

issuperscript

public void issuperscript(boolean issuperscript)

sets whether font is superscript.

specified by:

issuperscript in interface iconditionalformat

issubscript

public boolean issubscript()

indicates whether font is subscript.

specified by:

issubscript in interface iconditionalformat

issubscript

public void issubscript(boolean issubscript)

sets whether font is subscript.

specified by:

issubscript in interface iconditionalformat

getnumberformat

public java.lang.string getnumberformat()

setnumberformat

public void setnumberformat(java.lang.string numberformat)

getcolorscale

public colorscale getcolorscale()

returns color scale settings. valid only if format type is set to color scale. read-only.

specified by:

getcolorscale in interface iconditionalformat

getdatabar

public databar getdatabar()

returns data bar settings. valid only if format type is set to data bar. read-only.

specified by:

getdatabar in interface iconditionalformat

geticonset

public iconset geticonset()

returns iconset settings. valid only if format type is set to icon set. read-only.

specified by:

geticonset in interface iconditionalformat

makeformula

public java.lang.string makeformula()

makeformula

public java.lang.string makeformula(java.lang.string para)

settimeperiod

public void settimeperiod(timeperiodtype timeperiod)

getocolor

public ocolor getocolor()

gets conditional format color. read-only.

getbackcolorobject

public ocolor getbackcolorobject()

gets conditional format background color. read-only.

gettopbordercolorobject

public ocolor gettopbordercolorobject()

gets conditional format top border color. read-only.

getbottombordercolorobject

public ocolor getbottombordercolorobject()

gets conditional format bottom border color. read-only.

getleftbordercolorobject

public ocolor getleftbordercolorobject()

conditional format left border color. read-only.

getfontcolorobject

public ocolor getfontcolorobject()

gets conditional format font color. read-only.

isbackgroundcolorpresent

public boolean isbackgroundcolorpresent()

gets if true - background color present. otherwise - false.

isbackgroundcolorpresent

public void isbackgroundcolorpresent(boolean flag)

sets if true - background color present. otherwise - false.

isborderformatpresent

public boolean isborderformatpresent()

gets if contains border formatting.

isborderformatpresent

public void isborderformatpresent(boolean value)

sets if contains border formatting.

isfontcolorpresent

public boolean isfontcolorpresent()

if true - format color present. otherwise - false.

isfontcolorpresent

public void isfontcolorpresent(boolean value)

if true - format color present. otherwise - false.

isfontformatpresent

public boolean isfontformatpresent()

true if contains font formatting.

isfontformatpresent

public void isfontformatpresent(boolean value)

sets if contains font formatting.

ispatterncolorpresent

public boolean ispatterncolorpresent()

indicates whether pattern color .

ispatterncolorpresent

public void ispatterncolorpresent(boolean value)

sets whether pattern color .

ispatternformatpresent

public boolean ispatternformatpresent()

true if contains pattern formatting.

ispatternformatpresent

public void ispatternformatpresent(boolean value)

true if contains pattern formatting.

getdxfid

public int getdxfid()

setdxfid

public void setdxfid(int dxfid)