Change Text Direction of the Comment

Microsoft Excel users can add comments to cells in spreadsheets to add additional information to cells and highlight the data. Developers might need to customize the comment to specify alignment settings and text direction. Aspose.Cells provides APIs to accomplish the task.

Aspose.Cells provides a Shape.setTextDirection() method to set the desired text direction for a comment.

The following image shows the comment with its format settings in Microsoft Excel. The output file is obtained after running the below code segment.

Comment with right-to-left text direction

// 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 wb = new Workbook();
// Get the first worksheet
Worksheet sheet = wb.getWorksheets().get(0);

// Add a comment to A1 cell
Comment comment = sheet.getComments().get(sheet.getComments().add("A1"));
// Set its vertical alignment setting
comment.getCommentShape().setTextVerticalAlignment(TextAlignmentType.CENTER);
// Set its horizontal alignment setting
comment.getCommentShape().setTextHorizontalAlignment(TextAlignmentType.RIGHT);
// Set the Text Direction - Right-to-Left
comment.getCommentShape().setTextDirection(TextDirectionType.RIGHT_TO_LEFT);
// Set the Comment note
comment.setNote("This is my Comment Text. This is test");

// Save the Excel file
wb.save(dataDir + "outCommentShape1.xlsx");