Hi,
Well, the DateTime values are actually stored in numeric notations in MS Excel. I observed the issue as you mentioned. The DateAndTime and
CustomFormat demos give un-formatted results when specifying custom
dates as you pointed out, these should give formatted results. I even tried the following sample code by adding the lines to the demos but to no avail.
e.g
Sample code:
…
B2.putValue(value,true);
GridTableItemStyle style = B2.getStyle();
style.setNumberType(numberType);
B2.setStyle(style);
…
I have logged a ticket with an id “CELLSJAVA-41079” for your issue. We will look into it soon.
Once we have any update on it, we will let you know here.
Thank you.