Method Details

• getColor

  IFormatColor getColor()

  Gets an object that specifies the border color of data bars in a conditional formatting rule.

  Use the returned IFormatColor object to read or modify the border color for the current data bar rule.

  
   worksheet.getRange("A1:A5").setValue(new Object[][] {{1}, {2}, {3}, {4}, {5}});
   IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
   IDataBarBorder border = dataBar.getBarBorder();
   border.setType(DataBarBorderType.Solid);
   IFormatColor color = border.getColor();
   color.setColor(Color.GetRed());
   

  Returns:

  The IFormatColor object that specifies the border color of data bars in a conditional formatting rule; see IFormatColor.

• getType

  DataBarBorderType getType()

  Gets the border type for data bars specified by a conditional formatting rule.

  The returned value indicates whether the data bar border is disabled or displayed as a solid border.

  
   worksheet.getRange("A1:A5").setValue(new Object[][] {{1}, {2}, {3}, {4}, {5}});
   IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
   IDataBarBorder border = dataBar.getBarBorder();
   border.setType(DataBarBorderType.Solid);
   DataBarBorderType type = border.getType();
   

  Returns:

  The border type for data bars specified by a conditional formatting rule.

• setType

  void setType(DataBarBorderType value)

  Sets the border type for data bars in this conditional formatting rule.

  Use this method to control whether the data bar displays no border or a solid border.

  
   worksheet.getRange("A1:A5").setValue(new Object[][] {{1}, {2}, {3}, {4}, {5}});
   IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
   IDataBarBorder border = dataBar.getBarBorder();
   border.setType(DataBarBorderType.Solid);
   

  Parameters:

  value - The data bar border type. Must not be null.