com.aspose.cells

  • java.lang.Object
public class Walls 
extends Floor

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

Property Getters/Setters Summary
ColorgetBackgroundColor()
void
           Gets or sets the background com.aspose.cells.Color of the Area.
LinegetBorder()
void
setBorder(Line value)
           Gets or sets the border Line.
intgetCenterX()
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.
intgetCenterXPx()
Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
intgetCenterY()
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.
intgetCenterYPx()
Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
intgetDepth()
Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.
intgetDepthPx()
Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
FillFormatgetFillFormat()
Represents a object that contains fill formatting properties for the specified chart or shape.
ColorgetForegroundColor()
void
           Gets or sets the foreground com.aspose.cells.Color.
intgetFormatting()
void
setFormatting(intvalue)
           Represents the formatting of the area. The value of the property is FormattingType integer constant.
intgetHeight()
Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method.
intgetHeightPx()
Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
booleangetInvertIfNegative()
void
setInvertIfNegative(booleanvalue)
           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()
void
setTransparency(doublevalue)
           Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
intgetWidth()
Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method.
intgetWidthPx()
Gets the width of left to right in units of pixels after calls Chart.Calculate() method.
 
Method Summary
intgetCubePointCount()
Gets the number of cube points after calls Chart.Calculate() method.
floatgetCubePointXPx(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
floatgetCubePointYPx(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.
booleanisAuto()
booleanisVisible()
voidsetAuto(boolean isAuto)
 

    • Property Getters/Setters Detail

      • 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.
      • 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.
      • 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.
      • getDepth

        public int getDepth()
        
        Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.
      • 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.
      • 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.
      • 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.
      • getWidthPx

        public int getWidthPx()
        
        Gets the width of left to right in units of pixels after calls Chart.Calculate() method.
      • getDepthPx

        public int getDepthPx()
        
        Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
      • getHeightPx

        public int getHeightPx()
        
        Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
      • getBorder/setBorder

        public Line getBorder() / public void setBorder(Line value)
        
        Gets or sets the border Line.
      • getBackgroundColor/setBackgroundColor

        public Color getBackgroundColor() / public void setBackgroundColor(Color value)
        
        Gets or sets the background com.aspose.cells.Color of the Area.
      • getForegroundColor/setForegroundColor

        public Color getForegroundColor() / public void setForegroundColor(Color value)
        
        Gets or sets the foreground com.aspose.cells.Color.
      • getFormatting/setFormatting

        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

        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());
      • getFillFormat

        public FillFormat getFillFormat()
        
        Represents a object that contains fill formatting properties for the specified chart or shape.
        See Also:
        FillFormat
      • getTransparency/setTransparency

        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

      • getCubePointCount

        public int getCubePointCount()
        Gets the number of cube points after calls Chart.Calculate() method.
      • getCubePointXPx

        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
      • getCubePointYPx

        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.
      • isAuto

        public boolean isAuto()
      • isVisible

        public boolean isVisible()
      • setAuto

        public void setAuto(boolean isAuto)