Some of the cells like Date,Time datatypes are coming as “######”

Aspose.Cells Product Family
1

Hi,
We are using Aspose Version 8.6.3.0 to generate excel .Some of the cells like Date,Time datatypes are coming as “######” , instead of displaying value. when we expand the column we can able to see the values.
Please let me know if any fix is available?

2

@anand30,

Thanks for providing us some details.

Well, you need to extend the column’s width to display the DateTime value fully. You may either auto-fit columns width using worksheet.AutoFitColumns()/AutoFitColumn() or extenad the width of the columns using Worksheet.Cells.SetColumnWidth() method accordingly. See the sample code segment for your reference:
e.g
Sample code:

..........
//Get the first worksheet.
            Worksheet worksheet = workbook.Worksheets[0];
            //Apply auto-fit operation to all the columns .
            worksheet.AutoFitColumns();

Hope, this helps a bit.