addtionalformatwrapper-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.spreadsheet
class addtionalformatwrapper

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

all implemented interfaces:: iextendedformat, ioptimizedupdate, istyle

direct known subclasses:: cellbasestyle

public class addtionalformatwrapper
extends commonwrapper
implements istyle
extends commonwrapper
implements istyle

constructor summary
`addtionalformatwrapper(xlsworkbook book)`

method summary
`void`	`beginupdate()` this method should be called before several updates to the object will take place.
`void`	`endupdate()` this method should be called after several updates to the object took place.
`java.awt.color`	`getbackgroundcolor()` gets fill background color.
`excelcolors`	`getbackgroundknowncolor()` gets index of fill background excel color.
`ocolor`	`getbottombordercolor()` gets bottom border color.
`linestyletype`	`getbottomborderlinestyle()` gets line style of the bottom border.
`java.awt.color`	`getcolor()` gets the cell shading color.
`ocolor`	`getdiagonalbordercolor()` gets diagonal border color.
`linestyletype`	`getdiagonaldownborderlinestyle()` gets line style of the diagonal border.
`boolean`	`getdiagonaldownvisible()` indicates whether diagonal down line is visible.
`linestyletype`	`getdiagonalupborderlinestyle()` gets line style of the diagonal border.
`boolean`	`getdiagonalupvisible()` indicates whether diagonal up line is visible.
`int`	`getextendedformatindex()` gets extended format index.
`excelpatterntype`	`getfillpattern()` gets fill pattern type.
`com.spire.ms.system.drawing.color`	`getforegroundcolor()` gets fill foreground color.
`excelcolors`	`getforegroundknowncolor()` gets fill foreground excel color.
`boolean`	`getformulahidden()` true if the formula will be hidden when the worksheet is protected.
`horizontalaligntype`	`gethorizontalalignment()` returns the horizontal alignment for the specified object.
`boolean`	`getincludealignment()` true if the style includes the add indent, horizontal alignment, vertical alignment, wrap text, and orientation properties.
`boolean`	`getincludeborder()` true if the style includes the color, knowncolor, linestyle, and weight border properties
`boolean`	`getincludefont()` true if the style includes the background, bold, color, knowncolor, fontstyle, italic, name, outlinefont, shadow, size, strikethrough, subscript, superscript, and underline font properties.
`boolean`	`getincludenumberformat()` true if the style includes the numberformat property.
`boolean`	`getincludepatterns()` true if the style includes the color, knowncolor, invertifnegative, pattern, patterncolor, and patternknowncolor interior properties.
`boolean`	`getincludeprotection()` true if the style includes the formulahidden and locked protection properties.
`int`	`getindentlevel()` returns or sets the indent level for the style.
`boolean`	`getjustifylast()` represents justify text alignment
`excelcolors`	`getknowncolor()` gets the cell shading excel color.
`ocolor`	`getleftbordercolor()` gets left border color.
`linestyletype`	`getleftborderlinestyle()` gets line style of the left border.
`boolean`	`getlocked()` true if the object is locked; false if the object can be modified when the sheet is protected.
`java.lang.string`	`getnumberformat()` returns or sets the format code for the object.
`int`	`getnumberformatindex()` gets format index.
`java.lang.string`	`getnumberformatlocal()` returns or sets the format code for the object as a string in the language of the user.
`inumberformat`	`getnumberformatsettings()` returns object that describes number format.
`java.awt.color`	`getpatterncolor()` returns the color of the interior pattern.
`excelcolors`	`getpatternknowncolor()` returns the excel color of the interior.
`readingordertype`	`getreadingorder()` returns or sets the reading order for the specified object.
`ocolor`	`getrightbordercolor()` gets right border color.
`linestyletype`	`getrightborderlinestyle()` gets line style of the right border.
`int`	`getrotation()` the text orientation.
`boolean`	`getshrinktofit()` true if text automatically shrinks to fit in the available column width.
`ocolor`	`gettopbordercolor()` gets top border color.
`linestyletype`	`gettopborderlinestyle()` gets line style of the top border.
`verticalaligntype`	`getverticalalignment()` returns the vertical alignment of the specified object.
`boolean`	`getwraptext()` true if microsoft excel wraps the text in the object.
`boolean`	`isfirstsymbolapostrophe()` if true then first symbol in cell is apostrophe.
`void`	`setbackgroundcolor(java.awt.color color)` sets fill background color.
`void`	`setcolor(java.awt.color color)` sets the cell shading color.
`void`	`setpatterncolor(java.awt.color color)` sets the color of the interior pattern.

methods inherited from interface com.spire.xls.core.istyle
`getbuiltin, getinterior, getname, isinitialized`

methods inherited from interface com.spire.xls.core.iextendedformat
`getborders, getfont, isfirstsymbolapostrophe, ismodified, setfillpattern, setformulahidden, sethorizontalalignment, setincludealignment, setincludefont, setincludenumberformat, setincludepatterns, setincludeprotection, setindentlevel, setknowncolor, setlocked, setnumberformat, setnumberformatindex, setnumberformatlocal, setpatternknowncolor, setreadingorder, setrotation, setshrinktofit, setverticalalignment, setwraptext`

methods inherited from interface com.spire.xls.core.iextendedformat

getborders, getfont, isfirstsymbolapostrophe, ismodified, setfillpattern, setformulahidden, sethorizontalalignment, setincludealignment, setincludefont, setincludenumberformat, setincludepatterns, setincludeprotection, setindentlevel, setknowncolor, setlocked, setnumberformat, setnumberformatindex, setnumberformatlocal, setpatternknowncolor, setreadingorder, setrotation, setshrinktofit, setverticalalignment, setwraptext

constructor detail

addtionalformatwrapper

public addtionalformatwrapper(xlsworkbook book)

method detail

getbottombordercolor

public ocolor getbottombordercolor()

gets bottom border color.

gettopbordercolor

public ocolor gettopbordercolor()

gets top border color.

getleftbordercolor

public ocolor getleftbordercolor()

gets left border color.

getrightbordercolor

public ocolor getrightbordercolor()

gets right border color.

getdiagonalbordercolor

public ocolor getdiagonalbordercolor()

gets diagonal border color.

getleftborderlinestyle

public linestyletype getleftborderlinestyle()

gets line style of the left border.

getrightborderlinestyle

public linestyletype getrightborderlinestyle()

gets line style of the right border.

gettopborderlinestyle

public linestyletype gettopborderlinestyle()

gets line style of the top border.

getbottomborderlinestyle

public linestyletype getbottomborderlinestyle()

gets line style of the bottom border.

getdiagonalupborderlinestyle

public linestyletype getdiagonalupborderlinestyle()

gets line style of the diagonal border.

getdiagonaldownborderlinestyle

public linestyletype getdiagonaldownborderlinestyle()

gets line style of the diagonal border.

getdiagonalupvisible

public boolean getdiagonalupvisible()

indicates whether diagonal up line is visible.

getdiagonaldownvisible

public boolean getdiagonaldownvisible()

indicates whether diagonal down line is visible.

getfillpattern

public excelpatterntype getfillpattern()

gets fill pattern type.

specified by:: getfillpattern in interface iextendedformat

getextendedformatindex

public int getextendedformatindex()

gets extended format index.

getbackgroundknowncolor

public excelcolors getbackgroundknowncolor()

gets index of fill background excel color.

getbackgroundcolor

public java.awt.color getbackgroundcolor()

gets fill background color.

setbackgroundcolor

public void setbackgroundcolor(java.awt.color color)

sets fill background color.

getforegroundknowncolor

public excelcolors getforegroundknowncolor()

gets fill foreground excel color.

getforegroundcolor

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

gets fill foreground color.

getnumberformatindex

public int getnumberformatindex()

gets format index.

specified by:: getnumberformatindex in interface iextendedformat

gethorizontalalignment

public horizontalaligntype gethorizontalalignment()

returns the horizontal alignment for the specified object.

specified by:: gethorizontalalignment in interface iextendedformat

getincludealignment

public boolean getincludealignment()

true if the style includes the add indent, horizontal alignment, vertical alignment, wrap text, and orientation properties.

specified by:: getincludealignment in interface iextendedformat

getincludeborder

public boolean getincludeborder()

true if the style includes the color, knowncolor, linestyle, and weight border properties

specified by:: getincludeborder in interface iextendedformat

getincludefont

public boolean getincludefont()

true if the style includes the background, bold, color, knowncolor, fontstyle, italic, name, outlinefont, shadow, size, strikethrough, subscript, superscript, and underline font properties.

specified by:: getincludefont in interface iextendedformat

getincludenumberformat

public boolean getincludenumberformat()

true if the style includes the numberformat property.

specified by:: getincludenumberformat in interface iextendedformat

getincludepatterns

public boolean getincludepatterns()

true if the style includes the color, knowncolor, invertifnegative, pattern, patterncolor, and patternknowncolor interior properties.

specified by:: getincludepatterns in interface iextendedformat

getincludeprotection

public boolean getincludeprotection()

true if the style includes the formulahidden and locked protection properties.

specified by:: getincludeprotection in interface iextendedformat

getindentlevel

public int getindentlevel()

returns or sets the indent level for the style.

specified by:: getindentlevel in interface iextendedformat

getformulahidden

public boolean getformulahidden()

true if the formula will be hidden when the worksheet is protected.

specified by:: getformulahidden in interface iextendedformat

getlocked

public boolean getlocked()

true if the object is locked; false if the object can be modified when the sheet is protected.

specified by:: getlocked in interface iextendedformat

getjustifylast

public boolean getjustifylast()

represents justify text alignment

specified by:: getjustifylast in interface iextendedformat

getnumberformat

public java.lang.string getnumberformat()

returns or sets the format code for the object.

specified by:: getnumberformat in interface iextendedformat

getnumberformatlocal

public java.lang.string getnumberformatlocal()

returns or sets the format code for the object as a string in the language of the user.

specified by:: getnumberformatlocal in interface iextendedformat

getnumberformatsettings

public inumberformat getnumberformatsettings()

returns object that describes number format. read-only.

specified by:: getnumberformatsettings in interface iextendedformat

getreadingorder

public readingordertype getreadingorder()

returns or sets the reading order for the specified object.

specified by:: getreadingorder in interface iextendedformat

getrotation

public int getrotation()

the text orientation. can be an integer value from 1 to 180 degrees

specified by:: getrotation in interface iextendedformat

getshrinktofit

public boolean getshrinktofit()

true if text automatically shrinks to fit in the available column width.

specified by:: getshrinktofit in interface iextendedformat

getverticalalignment

public verticalaligntype getverticalalignment()

returns the vertical alignment of the specified object.

specified by:: getverticalalignment in interface iextendedformat

getwraptext

public boolean getwraptext()

true if microsoft excel wraps the text in the object.

specified by:: getwraptext in interface iextendedformat

isfirstsymbolapostrophe

public boolean isfirstsymbolapostrophe()

if true then first symbol in cell is apostrophe.

specified by:: isfirstsymbolapostrophe in interface iextendedformat

getpatternknowncolor

public excelcolors getpatternknowncolor()

returns the excel color of the interior.

specified by:: getpatternknowncolor in interface iextendedformat

getpatterncolor

public java.awt.color getpatterncolor()

returns the color of the interior pattern.

specified by:: getpatterncolor in interface iextendedformat

returns:: pattern color

setpatterncolor

public void setpatterncolor(java.awt.color color)

sets the color of the interior pattern.

specified by:: setpatterncolor in interface iextendedformat

getknowncolor

public excelcolors getknowncolor()

gets the cell shading excel color.

specified by:: getknowncolor in interface iextendedformat

returns:: shading excel color

getcolor

public java.awt.color getcolor()

gets the cell shading color.

specified by:: getcolor in interface iextendedformat

returns:: shading color

setcolor

public void setcolor(java.awt.color color)

sets the cell shading color.

specified by:: setcolor in interface iextendedformat

beginupdate

public void beginupdate()

this method should be called before several updates to the object will take place.

specified by:: beginupdate in interface ioptimizedupdate
overrides:: beginupdate in class commonwrapper

endupdate

public void endupdate()

this method should be called after several updates to the object took place.

specified by:: endupdate in interface ioptimizedupdate
overrides:: endupdate in class commonwrapper