aspose.cells

Property Getters/Setters Detail

• getType/setType : Number 

  function getType() / function setType(value)
  

  Represents error bar amount type. The value of the property is ErrorBarType integer constant.

  Example:

  var workbook = new aspose.cells.Workbook();
  var cells = workbook.getWorksheets().get(0).getCells();
  cells.get("a1").putValue(2);
  cells.get("a2").putValue(5);
  cells.get("a3").putValue(3);
  cells.get("a4").putValue(6);
  cells.get("b1").putValue(4);
  cells.get("b2").putValue(3);
  cells.get("b3").putValue(6);
  cells.get("b4").putValue(7);
   
  cells.get("C1").putValue("Q1");
  cells.get("C2").putValue("Q2");
  cells.get("C3").putValue("Y1");
  cells.get("C4").putValue("Y2");
   
  var chartIndex = workbook.getWorksheets().get(0).getCharts().add(aspose.cells.ChartType.COLUMN, 11, 0, 27, 10);
  var chart = workbook.getWorksheets().get(0).getCharts().get(chartIndex);
  chart.getNSeries().add("A1:B4", true);
   
  chart.getNSeries().setCategoryData("C1:C4");
  
  for (var i = 0; i < chart.getNSeries().getCount(); i++)
  {
      var aseries = chart.getNSeries().get(i);
      //Sets custom error bar type
      aseries.getXErrorBar().setType(aspose.cells.ErrorBarType.CUSTOM);
      aseries.getXErrorBar().setPlusValue("=Sheet1!A1");
      aseries.getXErrorBar().setMinusValue("=Sheet1!A2");
  }

• getDisplayType/setDisplayType : Number 

  function getDisplayType() / function setDisplayType(value)
  

  Represents error bar display type. The value of the property is ErrorBarDisplayType integer constant.

• getAmount/setAmount : Number 

  function getAmount() / function setAmount(value)
  

  Represents amount of error bar. The amount must be greater than and equal to zero.

• getShowMarkerTTop/setShowMarkerTTop : boolean 

  function getShowMarkerTTop() / function setShowMarkerTTop(value)
  

  Indicates if formatting error bars with a T-top.

• getPlusValue/setPlusValue : String 

  function getPlusValue() / function setPlusValue(value)
  

  Represents positive error amount when error bar type is Custom.

• getMinusValue/setMinusValue : String 

  function getMinusValue() / function setMinusValue(value)
  

  Represents negative error amount when error bar type is Custom.

• getCompoundType/setCompoundType : Number 

  function getCompoundType() / function setCompoundType(value)
  

  Specifies the compound line type The value of the property is MsoLineStyle integer constant.

• getDashType/setDashType : Number 

  function getDashType() / function setDashType(value)
  

  Specifies the dash line type The value of the property is MsoLineDashStyle integer constant.

• getCapType/setCapType : Number 

  function getCapType() / function setCapType(value)
  

  Specifies the ending caps. The value of the property is LineCapType integer constant.

• getJoinType/setJoinType : Number 

  function getJoinType() / function setJoinType(value)
  

  Specifies the joining caps. The value of the property is LineJoinType integer constant.

• getBeginType/setBeginType : Number 

  function getBeginType() / function setBeginType(value)
  

  Specifies an arrowhead for the begin of a line. The value of the property is MsoArrowheadStyle integer constant.

• getEndType/setEndType : Number 

  function getEndType() / function setEndType(value)
  

  Specifies an arrowhead for the end of a line. The value of the property is MsoArrowheadStyle integer constant.

• getBeginArrowLength/setBeginArrowLength : Number 

  function getBeginArrowLength() / function setBeginArrowLength(value)
  

  Specifies the length of the arrowhead for the begin of a line. The value of the property is MsoArrowheadLength integer constant.

• getEndArrowLength/setEndArrowLength : Number 

  function getEndArrowLength() / function setEndArrowLength(value)
  

  Specifies the length of the arrowhead for the end of a line. The value of the property is MsoArrowheadLength integer constant.

• getBeginArrowWidth/setBeginArrowWidth : Number 

  function getBeginArrowWidth() / function setBeginArrowWidth(value)
  

  Specifies the width of the arrowhead for the begin of a line. The value of the property is MsoArrowheadWidth integer constant.

• getEndArrowWidth/setEndArrowWidth : Number 

  function getEndArrowWidth() / function setEndArrowWidth(value)
  

  Specifies the width of the arrowhead for the end of a line. The value of the property is MsoArrowheadWidth integer constant.

• getThemeColor/setThemeColor : ThemeColor 

  function getThemeColor() / function setThemeColor(value)
  

  Gets and sets the theme color.

  If the foreground color is not a theme color, NULL will be returned.

• getColor/setColor : Color 

  function getColor() / function setColor(value)
  

  Represents the com.aspose.cells.Color of the line.

• getTransparency/setTransparency : Number 

  function getTransparency() / function setTransparency(value)
  

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

• getStyle/setStyle : Number 

  function getStyle() / function setStyle(value)
  

  Represents the style of the line. The value of the property is LineType integer constant.

• getWeight/setWeight : Number 

  function getWeight() / function setWeight(value)
  

  Gets or sets the WeightType of the line. The value of the property is WeightType integer constant.

• getWeightPt/setWeightPt : Number 

  function getWeightPt() / function setWeightPt(value)
  

  Gets or sets the weight of the line in unit of points.

• getWeightPx/setWeightPx : Number 

  function getWeightPx() / function setWeightPx(value)
  

  Gets or sets the weight of the line in unit of pixels.

• getFormattingType/setFormattingType : Number 

  function getFormattingType() / function setFormattingType(value)
  

  Gets or sets format type. The value of the property is ChartLineFormattingType integer constant.

• isAutomaticColor : boolean 

  function isAutomaticColor()
  

  Indicates whether the color of line is auotmatic assigned.

• isVisible/setVisible : boolean 

  function isVisible() / function setVisible(value)
  

  Represents whether the line is visible.

• isAuto/setAuto : boolean 

  function isAuto() / function setAuto(value)
  

  Indicates whether this line style is auto assigned.

• getGradientFill : GradientFill 

  function getGradientFill()
  

  Represents gradient fill.