com.aspose.cells
Class Walls

java.lang.Object
  extended by Area
      extended by Floor
          extended by com.aspose.cells.Walls

public class Walls 
extends Floor

Encapsulates the object that represents the walls of a 3-D chart.

Property Getters/Setters Summary
com.aspose.cells.ColorgetBackgroundColor()→ inherited from Area
voidsetBackgroundColor(com.aspose.cells.Color value)
           Gets or sets the background com.aspose.cells.Color of the Area.
LinegetBorder()→ inherited from Floor
voidsetBorder(Line value)
           Gets or sets the border Line.
intgetCenterX()
voidsetCenterX(int value)
           Gets or sets the x coordinate of the left-bottom corner of Wall center.
intgetCenterY()
voidsetCenterY(int value)
           Gets or sets the y coordinate of the left-bottom corner of Wall center.
intgetDepth()
voidsetDepth(int value)
           Gets or sets the depth front to back.
FillFormatgetFillFormat()→ inherited from Area
           Represents a object that contains fill formatting properties for the specified chart or shape.
com.aspose.cells.ColorgetForegroundColor()→ inherited from Area
voidsetForegroundColor(com.aspose.cells.Color value)
           Gets or sets the foreground com.aspose.cells.Color.
intgetFormatting()→ inherited from Area
voidsetFormatting(int value)
           Represents the formatting of the area. The value of the property is FormattingType integer constant.
intgetHeight()
voidsetHeight(int value)
           Gets or sets the height of top to bottom.
booleangetInvertIfNegative()→ inherited from Area
voidsetInvertIfNegative(boolean value)
           If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.
doublegetTransparency()→ inherited from Area
voidsetTransparency(double value)
           Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
intgetWidth()
voidsetWidth(int value)
           Gets or sets the width of left to right.
 
Method Summary
booleanisAuto()→ inherited from Area
          
booleanisVisible()→ inherited from Area
          
voidsetAuto(boolean isAuto)→ inherited from Area
          
 

Property Getters/Setters Detail

getCenterX/setCenterX

public int getCenterX() / public void setCenterX(int value)
Gets or sets the x coordinate of the left-bottom corner of Wall center.

getCenterY/setCenterY

public int getCenterY() / public void setCenterY(int value)
Gets or sets the y coordinate of the left-bottom corner of Wall center.

getWidth/setWidth

public int getWidth() / public void setWidth(int value)
Gets or sets the width of left to right.

getDepth/setDepth

public int getDepth() / public void setDepth(int value)
Gets or sets the depth front to back.

getHeight/setHeight

public int getHeight() / public void setHeight(int value)
Gets or sets the height of top to bottom.

getBorder/setBorder

→ inherited from Floor
public Line getBorder() / public void setBorder(Line value)
Gets or sets the border Line.

getBackgroundColor/setBackgroundColor

→ inherited from Area
public com.aspose.cells.Color getBackgroundColor() / public void setBackgroundColor(com.aspose.cells.Color value)
Gets or sets the background com.aspose.cells.Color of the Area.

getForegroundColor/setForegroundColor

→ inherited from Area
public com.aspose.cells.Color getForegroundColor() / public void setForegroundColor(com.aspose.cells.Color value)
Gets or sets the foreground com.aspose.cells.Color.

getFormatting/setFormatting

→ inherited from Area
public int getFormatting() / public void setFormatting(int value)
Represents the formatting of the area. The value of the property is FormattingType integer constant.

getInvertIfNegative/setInvertIfNegative

→ inherited from Area
public boolean getInvertIfNegative() / public void setInvertIfNegative(boolean value)
If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Workbook object
int sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
//Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50);
//Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(-100);
//Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150);
//Adding a chart to the worksheet
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
Chart chart = worksheet.getCharts().get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "A3"
chart.getNSeries().add("A1:A3", true);
chart.getNSeries().get(0).getArea().setInvertIfNegative(true);
//Setting the foreground color of the 1st NSeries area
chart.getNSeries().get(0).getArea().setForegroundColor(Color.getRed());
//Setting the background color of the 1st NSeries area.
//The displayed area color of second chart point will be the background color.
chart.getNSeries().get(0).getArea().setBackgroundColor(Color.getYellow());
//Saving the Excel file
workbook.save("C:\\book1.xls");

getFillFormat

→ inherited from Area
public FillFormat getFillFormat()
Represents a object that contains fill formatting properties for the specified chart or shape.
See Also:
FillFormat

getTransparency/setTransparency

→ inherited from Area
public double getTransparency() / public void setTransparency(double value)
Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

Method Detail

isAuto

→ inherited from Area
public boolean isAuto()

isVisible

→ inherited from Area
public boolean isVisible()

setAuto

→ inherited from Area
public void setAuto(boolean isAuto)

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.