We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

We are facing one issue in 8.3 aspose cells .net version

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:
Sample code:

Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            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);

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.