com.aspose.cells
Class Walls

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

public class Walls 
extends Floor

public int getCenterX()

Gets the x coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's width after calls Chart.Calculate() method.

public int getCenterY()

Gets the y coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's height after calls Chart.Calculate() method.

public int getWidth()

Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method.

public int getDepth()

Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.

public int getHeight()

Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method.

public int getCenterXPx()

Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.

public int getCenterYPx()

Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.

public int getWidthPx()

Gets the width of left to right in units of pixels after calls Chart.Calculate() method.

public int getDepthPx()

Gets the depth front to back in units of pixels after calls Chart.Calculate() method.

public int getHeightPx()

Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.

public Line getBorder() / public void setBorder(Line value)

Gets or sets the border Line.

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.

public com.aspose.cells.Color getForegroundColor() / public void setForegroundColor(com.aspose.cells.Color value)

Gets or sets the foreground com.aspose.cells.Color.

public int getFormatting() / public void setFormatting(int value)

Represents the formatting of the area. The value of the property is FormattingType integer constant.

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("book1.xls");

public FillFormat getFillFormat()

Represents a object that contains fill formatting properties for the specified chart or shape.

See Also:

FillFormat

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).

public int getCubePointCount()

Gets the number of cube points after calls Chart.Calculate() method.

public float getCubePointXPx(int index)

Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight

public float getCubePointYPx(int index)

Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight.

public boolean isAuto()

public boolean isVisible()

public void setAuto(boolean isAuto)