when we writing “Dec18” in aspose cells .net version , it is showing as “43521” like that. how to fix that.
Thanks for your query.
Well, Ms Excel stores DateTime values in numeric notations, so you are getting these values. You need to set your cells values to appropriate DateTime formattings, see the sample code for your reference:
Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets; Cells tmpCells = worksheet.Cells; tmpCells[0, 0].PutValue(Convert.ToDateTime("Dec18")); Style style = tmpCells[0, 0].GetStyle(); style.Custom = "mmm-yy"; tmpCells[0, 0].SetStyle(style); worksheet.AutoFitColumn(0); workbook.Save("e:\\test2\\out1.xlsx");
Hope, this helps a bit.
It was working fine in older version 7.6. but we are facing this when we tried from 8.3 version.
Any idea about the reason?
I am afraid, no idea, may be the relevant APIs (internal module) might have changed its behavior a bit in your upgraded version. I am afraid, we cannot evaluate your issue or fix any issue in older version. The fixes are based on latest APIs set only. So if you find any issue in newer version/fix (e.g v18.11.x (latest)) we will evaluate it and fix the issue (if found). We recommend you to kindly upgrade to and use latest APIs set and in case you find any issue with latest version, we will check and fix it soon.