How to change the Comment Font Color

Microsoft Excel allows users to add comments to cells to add additional information and highlight data. Developers may need to customize the comment to specify alignment settings, text direction Font Color, etc. Aspose.Cells provides APIs to accomplish the task.

Aspose.Cells provides a Shape.TextBody property to the font color of the comment. The following sample code demonstrates the use of Shape.TextBody property to set text direction for a comment.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
String dataDir = "";
// Instantiate a new Workbook
Workbook workbook = new Workbook();
// Get the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);

//Add some text in cell A1
worksheet.getCells().get("A1").putValue("Here");

// Add a comment to A1 cell
Comment comment = worksheet.getComments().get(worksheet.getComments().add("A1"));
// Set its vertical alignment setting
comment.getCommentShape().setTextVerticalAlignment(TextAlignmentType.CENTER);
// Set the Comment note
comment.setNote("This is my Comment Text. This is test");

Shape shape = worksheet.getComments().get("A1").getCommentShape();

shape.getFill().getSolidFill().setColor(Color.getBlack());
Font font = shape.getFont();
font.setColor(Color.getWhite());
StyleFlag styleFlag = new StyleFlag();
styleFlag.setFontColor(true);
shape.getTextBody().format(0, shape.getText().length(), font, styleFlag);

// Save the Excel file
workbook.save(dataDir + "outputChangeCommentFontColor.xlsx");

The output file generated by the above code is attached for your reference.