com.aspose.cells

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

  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

  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)