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

Free Support Forum - aspose.com

DateTime formatting when displaying GridWeb

Aspose.Cells Product Family
#1

Hello,

using Aspose.Cells.GridWeb 2.1.0.2000
I import an Excel file in a GridWeb by doing :

Grid.WebWorksheets.ImportExcelFile


When displaying the GridWeb, the dates are formatted with an english Culture, whatever the current thread culture or UI culture may be.

The same file opened in Excel would display dates according to the user’s regional settings.


Is there any way to control the display of dates in a GridWeb ?
please help,

Regards,
Vincent

#2

Hi,

Could you post your sample file with sample code here, which culture you are using?

Thank you.

#3

Hi Vincent,

Please use the updated version of Aspose.Cells.GridWeb v2.3.1.2002 attached with this post. Now the cells with default date format will be formatted according to your regional settings.

Thanks,

#4

Thank you for you quick feedback and solution ! This will be of great help for us.

Regards !
Vincent