## Walls class

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

## Methods

| Name | Description |
| --- | --- |
| [getBackgroundColor()](#getbackgroundcolor) | Gets or sets the background com.aspose.cells.Color of the Area. |
| [getBorder()](#getborder) | Gets or sets the border Line. |
| [getCenterX()](#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.Cal |
| [getCenterXPx()](#getcenterxpx) | Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method. |
| [getCenterY()](#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.Ca |
| [getCenterYPx()](#getcenterypx) | Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method. |
| [getCubePointCount()](#getcubepointcount) | Gets the number of cube points after calls Chart.Calculate() method. |
| [getCubePointXPx()](#getcubepointxpx) | Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of wal |
| [getCubePointYPx()](#getcubepointypx) | Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of wal |
| [getDepth()](#getdepth) | Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method. |
| [getDepthPx()](#getdepthpx) | Gets the depth front to back in units of pixels after calls Chart.Calculate() method. |
| [getFillFormat()](#getfillformat) | Represents a FillFormat object that contains fill formatting properties for the specified chart or shape. |
| [getForegroundColor()](#getforegroundcolor) | Gets or sets the foreground com.aspose.cells.Color. |
| [getFormatting()](#getformatting) | Represents the formatting of the area. The value of the property is FormattingType integer constant. |
| [getHeight()](#getheight) | Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method. |
| [getHeightPx()](#getheightpx) | Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method. |
| [getInvertIfNegative()](#getinvertifnegative) | If the property is true and the value of chart point is a negative number, the foreground color and background color wil |
| [getTransparency()](#gettransparency) | Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |
| [getWidth()](#getwidth) | Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method. |
| [getWidthPx()](#getwidthpx) | Gets the width of left to right in units of pixels after calls Chart.Calculate() method. |
| [setBackgroundColor()](#setbackgroundcolor) | Gets or sets the background com.aspose.cells.Color of the Area. |
| [setBorder()](#setborder) | Gets or sets the border Line. |
| [setForegroundColor()](#setforegroundcolor) | Gets or sets the foreground com.aspose.cells.Color. |
| [setFormatting()](#setformatting) | Represents the formatting of the area. The value of the property is FormattingType integer constant. |
| [setInvertIfNegative()](#setinvertifnegative) | If the property is true and the value of chart point is a negative number, the foreground color and background color wil |
| [setTransparency()](#settransparency) | Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear). |

### getBackgroundColor() {#getbackgroundcolor}

Gets or sets the background com.aspose.cells.Color of the Area.

### getBorder() {#getborder}

Gets or sets the border Line.

### getCenterX() {#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.

### getCenterXPx() {#getcenterxpx}

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

### getCenterY() {#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.

### getCenterYPx() {#getcenterypx}

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

### getCubePointCount() {#getcubepointcount}

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

### getCubePointXPx() {#getcubepointxpx}

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

### getCubePointYPx() {#getcubepointypx}

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.

### getDepth() {#getdepth}

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

### getDepthPx() {#getdepthpx}

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

### getFillFormat() {#getfillformat}

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

### getForegroundColor() {#getforegroundcolor}

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

### getFormatting() {#getformatting}

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

### getHeight() {#getheight}

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

### getHeightPx() {#getheightpx}

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

### getInvertIfNegative() {#getinvertifnegative}

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:**

```js
//Instantiating a Workbook object
var workbook = new aspose.cells.Workbook();
//Adding a new worksheet to the Workbook object
var sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
var 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
var chartIndex = worksheet.getCharts().add(aspose.cells.ChartType.COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
var 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(aspose.cells.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(aspose.cells.Color.getYellow());
//Saving the Excel file
workbook.save("C:\\book1.xls");
```

### getTransparency() {#gettransparency}

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

### getWidth() {#getwidth}

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

### getWidthPx() {#getwidthpx}

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

### setBackgroundColor() {#setbackgroundcolor}

Gets or sets the background com.aspose.cells.Color of the Area.

### setBorder() {#setborder}

Gets or sets the border Line.

### setForegroundColor() {#setforegroundcolor}

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

### setFormatting() {#setformatting}

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

### setInvertIfNegative() {#setinvertifnegative}

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:**

```js
//Instantiating a Workbook object
var workbook = new aspose.cells.Workbook();
//Adding a new worksheet to the Workbook object
var sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
var 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
var chartIndex = worksheet.getCharts().add(aspose.cells.ChartType.COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
var 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(aspose.cells.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(aspose.cells.Color.getYellow());
//Saving the Excel file
workbook.save("C:\\book1.xls");
```

### setTransparency() {#settransparency}

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).