Hello,
Hi Jeff,
Hello Amjad,
Hi Jeff,
Hi,
Please download: Aspose.Cells for Java v7.1.0.4
We have fixed the issue of saving number format “dd.MM.yyyy” for ODS file. For the issue of showing number format in excel for the generated xlsx/xls, it is the behavior of ms excel. If cells are merged and the merged cells do not have same style, the number format cannot be displayed. To make it be shown, please unmerge the cells, or make all cells in the merged area have the same style, such as change your code as:
Java
Style cellStyle = cell.getStyle();
cellStyle.setCustom(format);
cell.setStyle(cellStyle);
for(int i=1; i<3; i++)
cell.getWorksheet().getCells().get(cell.getRow(), cell.getColumn()+i).setStyle(cellStyle);
Hello,
Thank you, I will try this new version.
Btw, I found better way to set correct custom number format for merged cells:
if (cell.isMerged()) {
Range range = cell.getMergedRange();
StyleFlag flag = new StyleFlag();
flag.setAll(false);
flag.setNumberFormat(true);
range.applyStyle(cellStyle, flag);
}
Regards, Jeff
Hello,
Hi,
Please download the latest Major version:
Aspose.Cells for Java 7.1.0
Once you have downloaded it, then update the apsose.cells jar with the latest Minor version:
Aspose.Cells
for Java v7.1.0.4
In this fix we have fixed the similar issue of this one. If you still get the same issue, please give us your template file and code to reproduce the issue.
The issues you have found earlier (filed as CELLSJAVA-40126) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.