I am using Aspose.Cells 7.7.1 library and trying to use autoFitColumns() for the sheet. It is not adjusting the width properly for the cells having font size set as bold.
In some cases where we have combination of both font settings and merge columns autoFit is not behaving properly. Could you please check?
Below is the code snippet for your reference:
try {
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Accessing the added worksheet in the Excel file
int sheetIndex = workbook.getWorksheets().add();
Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();
Style colStyle;
Font font;
//Adding a some value to “A1” cell
Cell cell = cells.get(“A1”);
cell.setValue(“Some long text need to test auto fit COLUMN”);
colStyle = cell.getStyle();
font = colStyle.getFont();
font.setSize(8);
font.setName(“Verdana”);
font.setBold(true);
cell.setStyle(colStyle);
//Adding a some value to “B1” cell
cell = cells.get(“B1”);
cell.setValue(“Some long text”);
colStyle = cell.getStyle();
font = colStyle.getFont();
font.setSize(8);
font.setBold(true);
font.setName(“Verdana”);
cell.setStyle(colStyle);
//Adding a some value to “A2” cell
cell = cells.get(“A2”);
cells.merge(1, 0, 1, 3);
cell.setValue(“Some long text need to test”);
colStyle = cell.getStyle();
font = colStyle.getFont();
font.setSize(8);
font.setName(“Verdana”);
cell.setStyle(colStyle);
//Adding a some value to “B3” cell
cell = cells.get(“B3”);
cell.setValue(“Some long text need to test”);
colStyle = cell.getStyle();
font = colStyle.getFont();
font.setSize(8);
font.setName(“Verdana”);
font.setBold(true);
cell.setStyle(colStyle);
//Adding a some value to “C3” cell
cell = cells.get(“C3”);
cell.setValue(“Some long text need to test autofit”);
colStyle = cell.getStyle();
font = colStyle.getFont();
font.setSize(8);
font.setName(“Verdana”);
cell.setStyle(colStyle);
String sdPath = “…”; //any path
for (Iterator i = workbook.getWorksheets().iterator(); i.hasNext()
{
{ Worksheet sheet = i.next();
sheet.autoFitColumns();
sheet.autoFitRows();
}
//Saving the modified Excel file in default format
workbook.save(sdPath + “/output.xls”);
} catch (Exception ex) {
System.out.println(ex);
}