|
|||||||||
prev class next class | frames no frames | ||||||||
summary: nested | field | constr | method | detail: field | constr | method |
java.lang.objectcom.spire.xls.core.spreadsheet.xlsobject
com.spire.xls.core.spreadsheet.shapes.xlsshape
com.spire.xls.core.spreadsheet.shapes.xlschartshape
public class xlschartshape
constructor summary | |
---|---|
xlschartshape(java.lang.object parent)
|
method summary | |
---|---|
ishape |
deepclone(java.lang.object parent,
java.util.hashmap hashnewnames,
java.util.hashmap dicfontindexes,
boolean addtocollections)
creates a clone of the current shape. |
boolean |
getautoscaling()
true if microsoft excel scales a 3-d chart so that it's closer in size to the equivalent 2-d chart. |
int |
getbottomrow()
bottom row of the chart in the worksheet. |
java.lang.string |
getcategoryaxistitle()
title of the category axis. |
ichartframeformat |
getchartarea()
returns an object that represents the complete chart area for the chart. |
java.lang.string |
getcharttitle()
represents the title of the specified chart. |
icharttextarea |
getcharttitlearea()
gets title text area. |
excelcharttype |
getcharttype()
type of the chart. |
icheckboxes |
getcheckboxes()
returns collection with all checkboxes inside this worksheet. |
java.lang.string |
getcodename()
gets code name of the chart. |
icomboboxes |
getcomboboxes()
returns collection with all comboboxes inside this worksheet. |
ixlsrange |
getdatarange()
datarange for the chart series. |
ichartdatatable |
getdatatable()
represents charts datatable object. |
int |
getdepthpercent()
returns or sets the depth of a 3-d chart as a percentage of the chart width (between 20 and 2000 percent). |
boolean |
getdisplayaxisfieldbuttons()
gets or sets a value indicating whether [show axis field buttons]. |
chartplotemptytype |
getdisplayblanksas()
represents the way that blank cells are plotted on a chart. |
boolean |
getdisplayentirefieldbuttons()
gets or sets a value indicating whether [show all field buttons]. |
boolean |
getdisplaylegendfieldbuttons()
gets or sets a value indicating whether [show legend field buttons]. |
boolean |
getdisplayvaluefieldbuttons()
gets or sets a value indicating whether [show value field buttons]. |
int |
getelevation()
returns or sets the elevation of the 3-d chart view, in degrees (?0 to 90 degrees). |
ichartwallorfloor |
getfloor()
represents chart floor. |
int |
getgapdepth()
returns or sets the distance between the data series in a 3-d chart, as a percentage of the marker width.( 0 - 500 ) |
double |
getheightfordouble()
height of the chart in points (1/72 inch). |
int |
getheightpercent()
returns or sets the height of a 3-d chart as a percentage of the chart width (between 5 and 500 percent). |
int |
getleftcolumn()
left column of the chart in the worksheet. |
ichartlegend |
getlegend()
represents chart legend. |
ichartpagesetup |
getpagesetup()
page setup for the chart. |
int |
getperspective()
returns or sets the perspective for the 3-d chart view (0 to 100). |
excelcharttype |
getpivotcharttype()
gets or sets the type of the pivot chart. |
pivottable |
getpivottable()
gets or sets the pivot source. |
ichartframeformat |
getplotarea()
returns plot area frame format. |
boolean |
getplotvisibleonly()
true if only visible cells are plotted. |
ichartcategoryaxis |
getprimarycategoryaxis()
primary category axis. |
ichartseriesaxis |
getprimaryserieaxis()
primary serie axis. |
ichartvalueaxis |
getprimaryvalueaxis()
primary value axis. |
boolean |
getrightangleaxes()
true if the chart axes are at right angles, independent of chart rotation or elevation. |
int |
getrightcolumn()
right column of the chart in the worksheet. |
int |
getrotation()
returns or sets the rotation of the 3-d chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees). |
ichartcategoryaxis |
getsecondarycategoryaxis()
secondary category axis. |
java.lang.string |
getsecondarycategoryaxistitle()
title of the secondary category axis. |
ichartvalueaxis |
getsecondaryvalueaxis()
secondary value axis. |
java.lang.string |
getsecondaryvalueaxistitle()
title of the secondary value axis. |
java.lang.string |
getseriesaxistitle()
title of the series axis. |
boolean |
getseriesdatafromrange()
true if series are in rows in datarange; false otherwise. |
ishapes |
getshapes()
returns chart shapes. |
boolean |
getshowreportfilterfieldbuttons()
gets or sets a value indicating whether [show report filter field buttons]. |
boolean |
getsizewithwindow()
true if microsoft excel resizes the chart to match the size of the chart sheet window. |
boolean |
getsupportwallsandfloor()
indicates whether this chart supports walls and floor. |
itextboxes |
gettextboxes()
returns collection with all textboxes inside this worksheet. |
int |
gettoprow()
top row of the chart in the worksheet. |
java.lang.string |
getvalueaxistitle()
title of the value axis. |
ichartwallorfloor |
getwalls()
represents chart walls. |
boolean |
getwallsandgridlines2d()
true if gridlines are drawn two-dimensionally on a 3-d chart. |
double |
getwidthfordouble()
width of the chart in points (1/72 inch). |
double |
getxpos()
x coordinate of the upper-left corner of the chart in points (1/72 inch). |
double |
getypos()
y coordinate of the upper-left corner of the chart in points (1/72 inch). |
boolean |
haschartarea()
indicates whether chart has chart area. |
void |
haschartarea(boolean value)
indicates whether chart has chart area. |
boolean |
hascharttitle()
indicates wheather the chart has title |
boolean |
hasdatatable()
true if the chart has a data table. |
void |
hasdatatable(boolean hasdatatable)
sets true if the chart has a data table. |
boolean |
hasfloor()
gets value indicating whether floor object was created. |
boolean |
haslegend()
true if the chart has a legend object. |
void |
haslegend(boolean haslegend)
true if the chart has a legend object. |
boolean |
haspivottable()
indicates whether contains pivot table. |
boolean |
hasplotarea()
indicates whether chart has plot area. |
void |
hasplotarea(boolean value)
indicates whether chart has plot area. |
boolean |
haswalls()
gets value indicating whether floor object was created. |
boolean |
isrighttoleft()
indicates whether chart is displayed right to left. |
void |
isrighttoleft(boolean value)
indicates whether chart is displayed right to left. |
void |
setautoscaling(boolean value)
true if microsoft excel scales a 3-d chart so that it's closer in size to the equivalent 2-d chart. |
void |
setbottomrow(int bottomrow)
sets bottom row of the chart in the worksheet. |
void |
setcategoryaxistitle(java.lang.string value)
title of the category axis. |
void |
setcharttitle(java.lang.string charttitle)
sets the title of the specified chart. |
void |
setcharttype(excelcharttype charttype)
sets type of the chart. |
void |
setdatarange(ixlsrange value)
datarange for the chart series. |
void |
setdepthpercent(int value)
returns or sets the depth of a 3-d chart as a percentage of the chart width (between 20 and 2000 percent). |
void |
setdisplayaxisfieldbuttons(boolean value)
gets or sets a value indicating whether [show axis field buttons]. |
void |
setdisplayblanksas(chartplotemptytype value)
represents the way that blank cells are plotted on a chart. |
void |
setdisplayentirefieldbuttons(boolean value)
gets or sets a value indicating whether [show all field buttons]. |
void |
setdisplaylegendfieldbuttons(boolean value)
gets or sets a value indicating whether [show legend field buttons]. |
void |
setdisplayvaluefieldbuttons(boolean value)
gets or sets a value indicating whether [show value field buttons]. |
void |
setelevation(int value)
returns or sets the elevation of the 3-d chart view, in degrees (?0 to 90 degrees). |
void |
setgapdepth(int value)
returns or sets the distance between the data series in a 3-d chart, as a percentage of the marker width.( 0 - 500 ) |
void |
setheight(double value)
|
void |
setheightpercent(int value)
returns or sets the height of a 3-d chart as a percentage of the chart width (between 5 and 500 percent). |
void |
setleftcolumn(int leftcolumn)
sets left column of the chart in the worksheet. |
void |
setperspective(int value)
returns or sets the perspective for the 3-d chart view (0 to 100). |
void |
setpivotcharttype(excelcharttype value)
gets or sets the type of the pivot chart. |
void |
setpivottable(pivottable value)
gets or sets the pivot source. |
void |
setplotvisibleonly(boolean value)
true if only visible cells are plotted. |
void |
setrightangleaxes(boolean value)
true if the chart axes are at right angles, independent of chart rotation or elevation. |
void |
setrightcolumn(int rightcolumn)
sets right column of the chart in the worksheet. |
void |
setrotation(int value)
returns or sets the rotation of the 3-d chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees). |
void |
setsecondarycategoryaxistitle(java.lang.string value)
title of the secondary category axis. |
void |
setsecondaryvalueaxistitle(java.lang.string value)
title of the secondary value axis. |
void |
setseriesaxistitle(java.lang.string value)
title of the series axis. |
void |
setseriesdatafromrange(boolean seriesdatafromrange)
ture indicates the series data are from cell range in worksheet. |
void |
setshowreportfilterfieldbuttons(boolean value)
gets or sets a value indicating whether [show report filter field buttons]. |
void |
setsizewithwindow(boolean value)
true if microsoft excel resizes the chart to match the size of the chart sheet window. |
void |
settoprow(int toprow)
sets top row of the chart in the worksheet. |
void |
setvalueaxistitle(java.lang.string value)
title of the value axis. |
void |
setwallsandgridlines2d(boolean value)
true if gridlines are drawn two-dimensionally on a 3-d chart. |
void |
setwidth(double value)
width of the chart in points (1/72 inch). |
void |
setxpos(double value)
x coordinate of the upper-left corner of the chart in points (1/72 inch). |
void |
setypos(double value)
y coordinate of the upper-left corner of the chart in points (1/72 inch). |
methods inherited from class com.spire.xls.core.spreadsheet.shapes.xlsshape |
---|
deepclone, getalternativetext, getalternativetexttitle, getautosize, getbottomrowoffset, getfill, getheight, gethtmlstring, getid, getleft, getleftcolumnoffset, getline, getname, getonaction, getresizebehave, getrightcolumnoffset, getshadow, getshapeid, getshapetype, getthreed, gettop, gettoprowoffset, getupdatepositions, getvisible, getvmlshape, getwidth, hasfill, hasfill, haslineformat, haslineformat, isfliph, isfliph, isflipv, isflipv, isgroup, islockaspectratio, islockaspectratio, islocked, islocked, isprintable, isprintable, isrelative, isrelative, remove, scale, setalternativetext, setalternativetexttitle, setautosize, setbottomrowoffset, setheight, sethtmlstring, setleft, setleftcolumnoffset, setname, setonaction, setresizebehave, setrightcolumnoffset, setshapetype, settop, settoprowoffset, setupdatepositions, setvisible, setwidth |
methods inherited from class com.spire.xls.core.spreadsheet.xlsobject |
---|
dispose |
methods inherited from interface com.spire.xls.core.ishape |
---|
getalternativetext, getfill, getheight, gethtmlstring, getid, getleft, getname, getonaction, getresizebehave, getshadow, getshapetype, getthreed, gettop, getvisible, getwidth, islockaspectratio, islockaspectratio, islocked, islocked, isprintable, isprintable, remove, scale, setheight, sethtmlstring, setname, setonaction, setresizebehave, settop, setvisible, setwidth |
methods inherited from interface com.spire.xls.core.ichart |
---|
getname |
constructor detail |
---|
public xlschartshape(java.lang.object parent)
method detail |
---|
public excelcharttype getcharttype()
getcharttype
in interface ichart
public void setcharttype(excelcharttype charttype)
setcharttype
in interface ichart
charttype
- public ixlsrange getdatarange()
getdatarange
in interface ichart
public void setdatarange(ixlsrange value)
setdatarange
in interface ichart
public boolean getseriesdatafromrange()
getseriesdatafromrange
in interface ichart
public void setseriesdatafromrange(boolean seriesdatafromrange)
setseriesdatafromrange
in interface ichart
public ichartpagesetup getpagesetup()
getpagesetup
in interface ichart
public double getxpos()
getxpos
in interface ichart
public void setxpos(double value)
public double getypos()
getypos
in interface ichart
public void setypos(double value)
public double getwidthfordouble()
getwidthfordouble
in interface ichart
public void setwidth(double value)
public double getheightfordouble()
getheightfordouble
in interface ichart
public void setheight(double value)
public ichartcategoryaxis getprimarycategoryaxis()
getprimarycategoryaxis
in interface ichart
public ichartvalueaxis getprimaryvalueaxis()
getprimaryvalueaxis
in interface ichart
public ichartseriesaxis getprimaryserieaxis()
getprimaryserieaxis
in interface ichart
public ichartcategoryaxis getsecondarycategoryaxis()
getsecondarycategoryaxis
in interface ichart
public ichartvalueaxis getsecondaryvalueaxis()
getsecondaryvalueaxis
in interface ichart
public ichartframeformat getchartarea()
getchartarea
in interface ichart
public ichartframeformat getplotarea()
getplotarea
in interface ichart
public ichartwallorfloor getwalls()
getwalls
in interface ichart
public boolean getsupportwallsandfloor()
public ichartwallorfloor getfloor()
getfloor
in interface ichart
public ichartdatatable getdatatable()
getdatatable
in interface ichart
public boolean hascharttitle()
public boolean haschartarea()
public void haschartarea(boolean value)
public boolean hasdatatable()
hasdatatable
in interface ichart
public void hasdatatable(boolean hasdatatable)
hasdatatable
in interface ichart
public boolean hasfloor()
public boolean haswalls()
public ichartlegend getlegend()
getlegend
in interface ichart
public boolean haslegend()
haslegend
in interface ichart
public void haslegend(boolean haslegend)
haslegend
in interface ichart
public boolean haspivottable()
public int getrotation()
getrotation
in interface ichart
getrotation
in interface ishape
getrotation
in class xlsshape
public void setrotation(int value)
setrotation
in interface ichart
setrotation
in interface ishape
setrotation
in class xlsshape
public int getelevation()
getelevation
in interface ichart
public void setelevation(int value)
setelevation
in interface ichart
public int getperspective()
getperspective
in interface ichart
public void setperspective(int value)
setperspective
in interface ichart
public int getheightpercent()
getheightpercent
in interface ichart
public void setheightpercent(int value)
setheightpercent
in interface ichart
public int getdepthpercent()
getdepthpercent
in interface ichart
public void setdepthpercent(int value)
setdepthpercent
in interface ichart
public int getgapdepth()
getgapdepth
in interface ichart
public void setgapdepth(int value)
setgapdepth
in interface ichart
public boolean getrightangleaxes()
getrightangleaxes
in interface ichart
public void setrightangleaxes(boolean value)
setrightangleaxes
in interface ichart
public boolean getautoscaling()
getautoscaling
in interface ichart
public void setautoscaling(boolean value)
setautoscaling
in interface ichart
public boolean getwallsandgridlines2d()
getwallsandgridlines2d
in interface ichart
public void setwallsandgridlines2d(boolean value)
setwallsandgridlines2d
in interface ichart
public boolean hasplotarea()
hasplotarea
in interface ichart
public void hasplotarea(boolean value)
hasplotarea
in interface ichart
public chartplotemptytype getdisplayblanksas()
getdisplayblanksas
in interface ichart
public void setdisplayblanksas(chartplotemptytype value)
setdisplayblanksas
in interface ichart
public boolean getplotvisibleonly()
getplotvisibleonly
in interface ichart
public void setplotvisibleonly(boolean value)
setplotvisibleonly
in interface ichart
public boolean getsizewithwindow()
getsizewithwindow
in interface ichart
public void setsizewithwindow(boolean value)
setsizewithwindow
in interface ichart
public pivottable getpivottable()
getpivottable
in interface ichart
public void setpivottable(pivottable value)
setpivottable
in interface ichart
public excelcharttype getpivotcharttype()
getpivotcharttype
in interface ichart
public void setpivotcharttype(excelcharttype value)
setpivotcharttype
in interface ichart
public boolean getdisplayentirefieldbuttons()
getdisplayentirefieldbuttons
in interface ichart
public void setdisplayentirefieldbuttons(boolean value)
setdisplayentirefieldbuttons
in interface ichart
public boolean getdisplayvaluefieldbuttons()
getdisplayvaluefieldbuttons
in interface ichart
public void setdisplayvaluefieldbuttons(boolean value)
setdisplayvaluefieldbuttons
in interface ichart
public boolean getdisplayaxisfieldbuttons()
getdisplayaxisfieldbuttons
in interface ichart
public void setdisplayaxisfieldbuttons(boolean value)
setdisplayaxisfieldbuttons
in interface ichart
public boolean getdisplaylegendfieldbuttons()
getdisplaylegendfieldbuttons
in interface ichart
public void setdisplaylegendfieldbuttons(boolean value)
setdisplaylegendfieldbuttons
in interface ichart
public boolean getshowreportfilterfieldbuttons()
getshowreportfilterfieldbuttons
in interface ichart
public void setshowreportfilterfieldbuttons(boolean value)
setshowreportfilterfieldbuttons
in interface ichart
public int gettoprow()
gettoprow
in interface ichartshape
gettoprow
in class xlsshape
public void settoprow(int toprow)
settoprow
in interface ichartshape
settoprow
in class xlsshape
public int getbottomrow()
getbottomrow
in interface ichartshape
getbottomrow
in class xlsshape
public void setbottomrow(int bottomrow)
setbottomrow
in interface ichartshape
setbottomrow
in class xlsshape
public int getleftcolumn()
getleftcolumn
in interface ichartshape
getleftcolumn
in class xlsshape
public void setleftcolumn(int leftcolumn)
setleftcolumn
in interface ichartshape
setleftcolumn
in class xlsshape
public int getrightcolumn()
getrightcolumn
in interface ichartshape
getrightcolumn
in class xlsshape
public void setrightcolumn(int rightcolumn)
setrightcolumn
in interface ichartshape
setrightcolumn
in class xlsshape
public icharttextarea getcharttitlearea()
public java.lang.string getcharttitle()
public void setcharttitle(java.lang.string charttitle)
public java.lang.string getcategoryaxistitle()
public void setcategoryaxistitle(java.lang.string value)
public java.lang.string getvalueaxistitle()
public void setvalueaxistitle(java.lang.string value)
public java.lang.string getsecondarycategoryaxistitle()
public void setsecondarycategoryaxistitle(java.lang.string value)
public java.lang.string getsecondaryvalueaxistitle()
public void setsecondaryvalueaxistitle(java.lang.string value)
public java.lang.string getseriesaxistitle()
public void setseriesaxistitle(java.lang.string value)
public ishapes getshapes()
public itextboxes gettextboxes()
public icheckboxes getcheckboxes()
public icomboboxes getcomboboxes()
public java.lang.string getcodename()
public boolean isrighttoleft()
public void isrighttoleft(boolean value)
public ishape deepclone(java.lang.object parent, java.util.hashmap hashnewnames, java.util.hashmap dicfontindexes, boolean addtocollections)
deepclone
in class xlsshape
parent
- new parent for the shape object.hashnewnames
- hashtable with new worksheet names.dicfontindexes
- dictionary with new font indexes.
|
|||||||||
prev class next class | frames no frames | ||||||||
summary: nested | field | constr | method | detail: field | constr | method |