iconditionalformat-ag凯发旗舰厅

overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method

com.spire.xls.core
interface iconditionalformat

all known implementing classes:
conditionalformat, conditionalformatwrapper, xlsconditionalformat
public interface iconditionalformat

contains a condition and the formatting attributes applied to the cells, if the condition is met.

method summary
 java.awt.color getbackcolor()
          get pattern background color.
 com.spire.ms.system.drawing.color getbackcolorinner()
          pattern background color.
 excelcolors getbackknowncolor()
          pattern background color.
 java.awt.color getbottombordercolor()
          color of the bottom line
 excelcolors getbottomborderknowncolor()
          color of the bottom line.
 linestyletype getbottomborderstyle()
          bottom border line style.
 java.awt.color getcolor()
          pattern foreground color.
 colorscale getcolorscale()
          returns color scale settings.
 databar getdatabar()
          returns data bar settings.
 excelpatterntype getfillpattern()
          xlsfill pattern style.
 java.lang.string getfirstformula()
          get first formula.
 java.awt.color getfontcolor()
          get font color.
 com.spire.ms.system.drawing.color getfontcolorinner()
          font color.
 excelcolors getfontknowncolor()
          font color.
 conditionalformattype getformattype()
          get type of the conditional format.
 iconset geticonset()
          returns iconset settings.
 excelcolors getknowncolor()
          pattern foreground color.
 java.awt.color getleftbordercolor()
          color of the left line.
 excelcolors getleftborderknowncolor()
          color of the left line.
 linestyletype getleftborderstyle()
          left border line style
 comparisonoperatortype getoperator()
          get type of the comparison operator.
 int getpriority()
          priority.
 java.awt.color getrightbordercolor()
          color of the right line.
 excelcolors getrightborderknowncolor()
          color of the right line.
 linestyletype getrightborderstyle()
          right border line style.
 java.lang.string getsecondformula()
          second formula.
 java.awt.color gettopbordercolor()
           
 excelcolors gettopborderknowncolor()
          color of the top line.
 linestyletype gettopborderstyle()
          top border line style.
 fontunderlinetype getunderline()
          underline type.
 boolean isbold()
          indicates whether the font is bold.
 void isbold(boolean value)
          indicates whether the font is bold.
 boolean isitalic()
          indicates whether font is italic.
 void isitalic(boolean value)
          indicates whether font is italic.
 boolean isstrikethrough()
          indicates whether font is struck through.
 void isstrikethrough(boolean value)
          indicates whether font is struck through.
 boolean issubscript()
          indicates whether font is subscript.
 void issubscript(boolean value)
           
 boolean issuperscript()
          indicates whether font is superscript.
 void issuperscript(boolean value)
           
 void setbackcolor(com.spire.ms.system.drawing.color value)
           
 void setbackcolor(java.awt.color backcolor)
          sets pattern background color.
 void setbackknowncolor(excelcolors value)
          pattern background color.
 void setbottombordercolor(java.awt.color bottombordercolor)
          sets color of the bottom line
 void setbottomborderknowncolor(excelcolors value)
          color of the bottom line.
 void setbottomborderstyle(linestyletype bottomborderstyle)
          sets bottom border line style.
 void setcolor(java.awt.color value)
          pattern foreground color.
 void setfillpattern(excelpatterntype value)
          xlsfill pattern style.
 void setfirstformula(java.lang.string firstformula)
          sets first formula.
 void setfontcolor(com.spire.ms.system.drawing.color value)
          set font color.
 void setfontcolor(java.awt.color fontcolor)
          sets font color.
 void setfontknowncolor(excelcolors value)
          font color.
 void setformattype(conditionalformattype conditionalformattype)
          sets type of the conditional format.
 void setknowncolor(excelcolors value)
          pattern foreground color.
 void setleftbordercolor(java.awt.color leftbordercolor)
          sets color of the left line.
 void setleftborderknowncolor(excelcolors value)
          color of the left line.
 void setleftborderstyle(linestyletype leftborderstyle)
          sets left border line style
 void setoperator(comparisonoperatortype operator)
          sets type of the comparison operator.
 void setpriority(int value)
          priority.
 void setrightbordercolor(java.awt.color rightbordercolor)
          sets color of the right line.
 void setrightborderknowncolor(excelcolors value)
          color of the right line.
 void setrightborderstyle(linestyletype rightborderstyle)
          sets right border line style.
 void setsecondformula(java.lang.string value)
          second formula.
 void settopbordercolor(java.awt.color topbordercolor)
          sets color of the top line.
 void settopborderknowncolor(excelcolors value)
          color of the top line.
 void settopborderstyle(linestyletype topborderstyle)
          sets top border line style.
 
method detail

getformattype

conditionalformattype getformattype()
get type of the conditional format.
returns:

setformattype

void setformattype(conditionalformattype conditionalformattype)
sets type of the conditional format.
parameters:
conditionalformattype -

getoperator

comparisonoperatortype getoperator()
get type of the comparison operator.
returns:

setoperator

void setoperator(comparisonoperatortype operator)
sets type of the comparison operator.
parameters:
operator -

isbold

boolean isbold()
indicates whether the font is bold.

isbold

void isbold(boolean value)
indicates whether the font is bold.

isitalic

boolean isitalic()
indicates whether font is italic.

isitalic

void isitalic(boolean value)
indicates whether font is italic.

getpriority

int getpriority()
priority.

setpriority

void setpriority(int value)
priority.

getfontknowncolor

excelcolors getfontknowncolor()
font color.

setfontknowncolor

void setfontknowncolor(excelcolors value)
font color.

getfontcolorinner

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

getfontcolor

java.awt.color getfontcolor()
get font color.
returns:

setfontcolor

void setfontcolor(com.spire.ms.system.drawing.color value)
set font color.

setfontcolor

void setfontcolor(java.awt.color fontcolor)
sets font color.
parameters:
fontcolor -

getunderline

fontunderlinetype getunderline()
underline type.

isstrikethrough

boolean isstrikethrough()
indicates whether font is struck through.

isstrikethrough

void isstrikethrough(boolean value)
indicates whether font is struck through.

getleftborderknowncolor

excelcolors getleftborderknowncolor()
color of the left line.

setleftborderknowncolor

void setleftborderknowncolor(excelcolors value)
color of the left line.

getleftbordercolor

java.awt.color getleftbordercolor()
color of the left line.

setleftbordercolor

void setleftbordercolor(java.awt.color leftbordercolor)
sets color of the left line.
parameters:
leftbordercolor -

getleftborderstyle

linestyletype getleftborderstyle()
left border line style

setleftborderstyle

void setleftborderstyle(linestyletype leftborderstyle)
sets left border line style

getrightborderknowncolor

excelcolors getrightborderknowncolor()
color of the right line.

setrightborderknowncolor

void setrightborderknowncolor(excelcolors value)
color of the right line.

getrightbordercolor

java.awt.color getrightbordercolor()
color of the right line.

setrightbordercolor

void setrightbordercolor(java.awt.color rightbordercolor)
sets color of the right line.

getrightborderstyle

linestyletype getrightborderstyle()
right border line style.

setrightborderstyle

void setrightborderstyle(linestyletype rightborderstyle)
sets right border line style.

gettopborderknowncolor

excelcolors gettopborderknowncolor()
color of the top line.

settopborderknowncolor

void settopborderknowncolor(excelcolors value)
color of the top line.

gettopbordercolor

java.awt.color gettopbordercolor()
returns:
color of the top line.

settopbordercolor

void settopbordercolor(java.awt.color topbordercolor)
sets color of the top line.
parameters:
topbordercolor - color of the top line.

gettopborderstyle

linestyletype gettopborderstyle()
top border line style.

settopborderstyle

void settopborderstyle(linestyletype topborderstyle)
sets top border line style.

getbottomborderknowncolor

excelcolors getbottomborderknowncolor()
color of the bottom line.

setbottomborderknowncolor

void setbottomborderknowncolor(excelcolors value)
color of the bottom line.

getbottombordercolor

java.awt.color getbottombordercolor()
color of the bottom line

setbottombordercolor

void setbottombordercolor(java.awt.color bottombordercolor)
sets color of the bottom line

getbottomborderstyle

linestyletype getbottomborderstyle()
bottom border line style.
returns:

setbottomborderstyle

void setbottomborderstyle(linestyletype bottomborderstyle)
sets bottom border line style.

getfirstformula

java.lang.string getfirstformula()
get first formula.
returns:

setfirstformula

void setfirstformula(java.lang.string firstformula)
sets first formula.
parameters:
firstformula -

getsecondformula

java.lang.string getsecondformula()
second formula.

setsecondformula

void setsecondformula(java.lang.string value)
second formula.

getknowncolor

excelcolors getknowncolor()
pattern foreground color.

setknowncolor

void setknowncolor(excelcolors value)
pattern foreground color.

getcolor

java.awt.color getcolor()
pattern foreground color.

setcolor

void setcolor(java.awt.color value)
pattern foreground color.

getbackknowncolor

excelcolors getbackknowncolor()
pattern background color.

setbackknowncolor

void setbackknowncolor(excelcolors value)
pattern background color.

getbackcolorinner

com.spire.ms.system.drawing.color getbackcolorinner()
pattern background color.

getbackcolor

java.awt.color getbackcolor()
get pattern background color.
returns:

setbackcolor

void setbackcolor(com.spire.ms.system.drawing.color value)

setbackcolor

void setbackcolor(java.awt.color backcolor)
sets pattern background color.
parameters:
backcolor -

getfillpattern

excelpatterntype getfillpattern()
xlsfill pattern style.

setfillpattern

void setfillpattern(excelpatterntype value)
xlsfill pattern style.

issuperscript

boolean issuperscript()
indicates whether font is superscript.

issuperscript

void issuperscript(boolean value)

issubscript

boolean issubscript()
indicates whether font is subscript.

issubscript

void issubscript(boolean value)

getdatabar

databar getdatabar()
returns data bar settings. valid only if format type is set to data bar. read-only.

geticonset

iconset geticonset()
returns iconset settings. valid only if formattype is set to iconset. read-only.

getcolorscale

colorscale getcolorscale()
returns color scale settings. valid only if formattype is set to colorscale. read-only.
overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method
网站地图