Format lost after export the sheet into excel file

Format lost after export the sheet into excel file

Posted by: josedavid.cordero on 4 January 2018, 5:35 am EST

• 

  josedavid.cordero

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 January 2018, 5:35 am EST

  Hello,
  
  When I try to export the sheet I’m loosing the date format. The value comes like this 2017-03-10T03:12:14 and I’m applying the format like this:

  var dateTimeStyle = new GC.Spread.Sheets.Style();
  dateTimeStyle.formatter = 'MM/DD/YYYY hh:mm:ss AM/PM';
  sheet.setStyle(1, 5, dateTimeStyle);
  

  In the sheet the format is applied successfully but when I do the export into the excel file I lost the format

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 5 January 2018, 1:43 am EST

  Hello,

  This seems to be working fine at my end. I set the format as your code and it gets exported to Excel with Time. Please refer to the attached image and sample application. It shows the time as soon as I start editing the cell.

  Thanks,
  
  Deepak Sharma

  ImportIssue.zip