Walls

Inheritance: java.lang.Object, com.aspose.cells.Area, com.aspose.cells.Floor

public class Walls extends Floor

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

Methods

MethodDescription
equals(Object arg0)
getBackgroundColor()Gets the background Color of the Area.
getBorder()Gets the border Line.
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()Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
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()Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
getClass()
getCubePointCount()Gets the number of cube points after calls Chart.Calculate() method.
getCubePointXPx(int index)Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
getCubePointYPx(int index)Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
getDepth()Gets the depth front to back in units of 1/4000 of chart’s width after calls Chart.Calculate() method.
getDepthPx()Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
getFillFormat()Represents a getFillFormat() object that contains fill formatting properties for the specified chart or shape.
getForegroundColor()Gets the foreground Color.
getFormatting()Represents the formatting of the area.
getHeight()Gets the height of top to bottom in units of 1/4000 of chart’s height after calls Chart.Calculate() method.
getHeightPx()Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
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.
getTransparency()Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
getWidth()Gets the width of left to right in units of 1/4000 of chart’s width after calls Chart.Calculate() method.
getWidthPx()Gets the width of left to right in units of pixels after calls Chart.Calculate() method.
hashCode()
notify()
notifyAll()
setBackgroundColor(Color value)Sets the background Color of the Area.
setBorder(Line value)Sets the border Line.
setForegroundColor(Color value)Sets the foreground Color.
setFormatting(int value)Represents the formatting of the area.
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.
setTransparency(double value)Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getBackgroundColor()

public Color getBackgroundColor()

Gets the background Color of the Area.

Returns: Color

getBorder()

public Line getBorder()

Gets the border Line.

Returns: Line

getCenterX()

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.

Returns: int

getCenterXPx()

public int getCenterXPx()

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

Returns: int

getCenterY()

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.

Returns: int

getCenterYPx()

public int getCenterYPx()

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

Returns: int

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getCubePointCount()

public int getCubePointCount()

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

Returns: int

getCubePointXPx(int index)

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

Parameters:

ParameterTypeDescription
indexint

Returns: float

getCubePointYPx(int index)

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.

Parameters:

ParameterTypeDescription
indexint

Returns: float

getDepth()

public int getDepth()

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

Returns: int

getDepthPx()

public int getDepthPx()

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

Returns: int

getFillFormat()

public FillFormat getFillFormat()

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

Returns: FillFormat

getForegroundColor()

public Color getForegroundColor()

Gets the foreground Color.

Returns: Color

getFormatting()

public int getFormatting()

Represents the formatting of the area.

See FormattingType.

Returns: int

getHeight()

public int getHeight()

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

Returns: int

getHeightPx()

public int getHeightPx()

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

Returns: int

getInvertIfNegative()

public boolean 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

         //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");

Returns: boolean

getTransparency()

public double getTransparency()

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

Returns: double

getWidth()

public int getWidth()

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

Returns: int

getWidthPx()

public int getWidthPx()

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

Returns: int

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setBackgroundColor(Color value)

public void setBackgroundColor(Color value)

Sets the background Color of the Area.

Parameters:

ParameterTypeDescription
valueColor

setBorder(Line value)

public void setBorder(Line value)

Sets the border Line.

Parameters:

ParameterTypeDescription
valueLine

setForegroundColor(Color value)

public void setForegroundColor(Color value)

Sets the foreground Color.

Parameters:

ParameterTypeDescription
valueColor

setFormatting(int value)

public void setFormatting(int value)

Represents the formatting of the area.

See FormattingType.

Parameters:

ParameterTypeDescription
valueint

setInvertIfNegative(boolean value)

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.

Parameters:

ParameterTypeDescription
valueboolean

setTransparency(double value)

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

Parameters:

ParameterTypeDescription
valuedouble

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int