Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
2060
Timezone offsets showing in times in Excel export
posted

Hi,

I posted this in the igGridExcelExporter forum here, but I can see there are some Excel related questions here too, so I'm posting it again as this forum seems to have a wider audience.:

When I export data from the grid to Excel I'm getting +1hr timezone offsets on some dates, because of DST adjustments in the UK I'm guessing.  

This is what it looks like, on the left is the igGrid and on the right is the corresponding output in Excel:

The dates in my datasource don't have time offsets, so I think the grid (or maybe moment, if that's what the grid is using to handle dates?) is introducing these?  How can I turn that off and have the dates exported as they are shown in the grid without time offsets added?