Hello,
when I convert excel to html, if I use cells-java-20.12, the merge cell D4 width become smaller, but in cells-java-8.8.2, it‘s same width as excel.
Hope the result is the same as 8.8.2
code show as below:
Workbook workbook = new Workbook("test-merge.xlsx");
WorksheetCollection worksheets = workbook.getWorksheets();
for (int sheetIndex = 0; sheetIndex < worksheets.getCount(); sheetIndex++) {
Worksheet worksheet = worksheets.get(sheetIndex);
Range maxDisplayRange = worksheet.getCells().getMaxDisplayRange();
int maxDisplayRow = maxDisplayRange.getFirstRow() + maxDisplayRange.getRowCount();
for (int i = 0; i < maxDisplayRow; i++) {
worksheet.getCells().get(i, 0);
}
}
workbook.save("test-merge.html");
result.zip (93.2 KB)