isparklinegroup-ag凯发旗舰厅

com.spire.xls.core.spreadsheet
interface isparklinegroup

all superinterfaces:

java.util.collection<isparklines>, java.lang.iterable<isparklines>, java.util.list<isparklines>

all known implementing classes:

sparklinegroup

public interface isparklinegroup
extends java.util.list<isparklines>

getshowhorizontalaxis

boolean getshowhorizontalaxis()

indicates whether to show the sparkline horizontal axis. the horizontal axis appears if the sparkline has data that crosses the zero axis.

setshowhorizontalaxis

void setshowhorizontalaxis(boolean value)

isdisplayhidden

boolean isdisplayhidden()

indicates whether to show data in hidden rows and columns.

isdisplayhidden

void isdisplayhidden(boolean value)

getplotrighttoleft

boolean getplotrighttoleft()

indicates whether the plot data is right to left.

setplotrighttoleft

void setplotrighttoleft(boolean value)

getshowfirstpoint

boolean getshowfirstpoint()

indicates whether to highlight the first point of data in the sparkline group.

setshowfirstpoint

void setshowfirstpoint(boolean value)

getshowlastpoint

boolean getshowlastpoint()

indicates whether to highlight the last point of data in the sparkline group.

setshowlastpoint

void setshowlastpoint(boolean value)

getshowlowpoint

boolean getshowlowpoint()

indicates whether to highlight the lowest points of data in the sparkline group.

setshowlowpoint

void setshowlowpoint(boolean value)

getshowhighpoint

boolean getshowhighpoint()

indicates whether to highlight the highest points of data in the sparkline group.

setshowhighpoint

void setshowhighpoint(boolean value)

getshownegativepoint

boolean getshownegativepoint()

indicates whether to highlight the negative values on the sparkline group with a different color or marker.

setshownegativepoint

void setshownegativepoint(boolean value)

getshowmarkers

boolean getshowmarkers()

indicates whether to highlight each point in each line sparkline in the sparkline group.

setshowmarkers

void setshowmarkers(boolean value)

getsparklinetype

sparklinetype getsparklinetype()

indicates the sparkline type of the sparkline group.

setsparklinetype

void setsparklinetype(sparklinetype value)

ishorizontaldateaxis

boolean ishorizontaldateaxis()

the horizontaldateaxis property represents the horizontal axis type as dateaxis.

ishorizontaldateaxis

void ishorizontaldateaxis(boolean value)

getemptycellstype

 getemptycellstype()

indicates how to display empty cells.

setemptycellstype

void setemptycellstype( value)

gethorizontaldateaxisrange

cellrange gethorizontaldateaxisrange()

represents the range that contains the date values for the sparkline data.

throws:

java.lang.exception - cref=" argumentoutofrangeexception" value.rows.length ifis not equal to 1 value.column.length ifis not equal to 1 horizontaldateaxis ifis not true

sethorizontaldateaxisrange

void sethorizontaldateaxisrange(cellrange value)

gethorizontalaxiscolor

java.awt.color gethorizontalaxiscolor()

gets and sets the color of the horizontal axis in the sparkline group.

sethorizontalaxiscolor

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

getfirstpointcolor

java.awt.color getfirstpointcolor()

gets and sets the color of the first point of data in the sparkline group.

setfirstpointcolor

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

gethighpointcolor

java.awt.color gethighpointcolor()

gets and sets the color of the highest points of data in the sparkline group.

sethighpointcolor

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

getlastpointcolor

java.awt.color getlastpointcolor()

gets and sets the color of the last point of data in the sparkline group.

setlastpointcolor

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

getlineweight

double getlineweight()

gets and sets the line weight in each line sparkline in the sparkline group, in the unit of points.

setlineweight

void setlineweight(double value)

getlowpointcolor

java.awt.color getlowpointcolor()

gets and sets the color of the lowest points of data in the sparkline group.

setlowpointcolor

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

getmarkerscolor

java.awt.color getmarkerscolor()

gets and sets the color of points in each line sparkline in the sparkline group.

setmarkerscolor

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

getnegativepointcolor

java.awt.color getnegativepointcolor()

gets and sets the color of the negative values on the sparkline group.

setnegativepointcolor

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

getsparklinecolor

java.awt.color getsparklinecolor()

gets and sets the color of the sparklines in the sparkline group.

setsparklinecolor

void setsparklinecolor(java.awt.color value)

add

sparklinecollection add()