ipivotfield-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 ipivotfield

all known implementing classes:
pivotfield, xlspivotfield
public interface ipivotfield

represents pivot field object.

method summary
 boolean candragoff()
           
 void candragoff(boolean candragoff)
           
 boolean candragtocolumn()
           
 void candragtocolumn(boolean candragtocolumn)
           
 boolean candragtodata()
           
 void candragtodata(boolean candragtodata)
           
 boolean candragtopage()
           
 void candragtopage(boolean candragtopage)
           
 boolean candragtorow()
           
 void candragtorow(boolean candragtorow)
           
 axistypes getaxis()
          gets field axis.
 java.lang.string getformula()
           
 java.lang.string getname()
           
 java.lang.string getnumberformat()
           
 boolean getshowblankrow()
           
 subtotaltypes getsubtotals()
           
 boolean isformulafield()
           
 void setaxis(axistypes axistypes)
           
 void setformula(java.lang.string formula)
           
 void setnumberformat(java.lang.string numberformat)
           
 void setshowblankrow(boolean showblankrow)
           
 void setsubtotals(subtotaltypes subtotals)
           
 
method detail

getname

java.lang.string getname()
returns:
returns pivot field name. read-only.

getaxis

axistypes getaxis()
gets field axis.
returns:
axistypes

setaxis

void setaxis(axistypes axistypes)
parameters:
axistypes - sets field axis.

getnumberformat

java.lang.string getnumberformat()
returns:
gets/sets number format.

setnumberformat

void setnumberformat(java.lang.string numberformat)
parameters:
numberformat - sets number format.

getsubtotals

subtotaltypes getsubtotals()
returns:
gets type of field subtotals.

setsubtotals

void setsubtotals(subtotaltypes subtotals)
parameters:
subtotals - sets type of field subtotals.

candragtorow

boolean candragtorow()
returns:
user can drag field to row area.

candragtorow

void candragtorow(boolean candragtorow)
parameters:
candragtorow - ser can drag field to row area.

candragtocolumn

boolean candragtocolumn()
returns:
user can drag field to column area.

candragtocolumn

void candragtocolumn(boolean candragtocolumn)
parameters:
candragtocolumn - user can drag field to column area.

candragtopage

boolean candragtopage()
returns:
user can drag field to page area.

candragtopage

void candragtopage(boolean candragtopage)
parameters:
candragtopage - user can drag field to page area.

candragoff

boolean candragoff()
returns:
user can remove field from view.

candragoff

void candragoff(boolean candragoff)
parameters:
candragoff - user can remove field from view.

getshowblankrow

boolean getshowblankrow()
returns:
true if a blank row is inserted after the specified row field in a pivottable report.

setshowblankrow

void setshowblankrow(boolean showblankrow)
parameters:
showblankrow - true if a blank row is inserted after the specified row field in a pivottable report.

candragtodata

boolean candragtodata()
returns:
true if the specified field can be dragged to the data position. the default value is true.

candragtodata

void candragtodata(boolean candragtodata)
parameters:
candragtodata - true if the specified field can be dragged to the data position. the default value is true.

isformulafield

boolean isformulafield()
returns:
indicates whether this field is formula field

getformula

java.lang.string getformula()
returns:
specifies the formula for the calculated field

setformula

void setformula(java.lang.string formula)
parameters:
formula - specifies the formula for the calculated field
overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method
网站地图