NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: Vinnie on April 04, 2015, 01:32:34 AM

Title: Export XML / Xfiles date format Libre Office.
Post by: Vinnie on April 04, 2015, 01:32:34 AM

Bruce thanks for your help at Thursday's webinar.

Problem with date format when export to Libre Office rather then Excel.

Export works OK except the date format.

Solution

Add 'T0' to the end of the date field.

XML field type is set to 'DateTime' but the time part is not set in the export. So adding 'T0' sets the time to zero. Date now works OK.

Added to xCell.SetCell Procedure in xFiles.clw
  If self.workbook.WorksheetQueue.Table.RowQueue.Cells.type = 'DateTime' and p_Data<>''
    self.workbook.WorksheetQueue.Table.RowQueue.Cells.data = left(p_Data)&'T0'
    End

 

Title: Re: Export XML / Xfiles date format Libre Office.
Post by: Vinnie on April 06, 2015, 10:55:59 PM

This solution works great for Libre Office but does not work with Excel.

I need to find another solution for this problem.

Cheers

Vinnie