Hello,
I tried to export a grid with a date = '01/01/0001' which is actually a null value in our Oracle database.
When exporting the grid to Excel I see in that column that the date is mentioned as: "Mon Jan 01 1 01:00:00 GMT+0100 (Romance Standard Time)".
I have tried to alter the export method as follows:
cellExporting: function (e, args) { if (args.columnKey == "expiryDate" && args.cellValue == "Mon Jan 01 1 01:00:00 GMT+0100 (Romance Standard Time)") {args.xlRow.getCellFormat(args.columnIndex).font().bold(1); args.xlRow.setCellValue(args.columnIndex, new Date(2055,1,1)); } },
Above code is setting the date in bold for that specific row, but it is not changing the date as requested.
Is it possible to empty the date field?
I have also noted that in your fiddle example when I try to add a date column with a date = '01/01/0001' it shows in Excel as '01/01/2001' ?
http://jsfiddle.net/h7cw52y0/
Kind regards
Hello Michael,
Thank you for contacting Infragistics!
You can use cellExported instead so you cna modify the value of the exported cell.
About the second issue, this is by design of JavaScript. The igGrid creates a object of type date, i.e. new Date("01/01/0001"), which is Mon Jan 01 1 01:00:00 GMT+0100 (Romance Standard Time). Note that is also impossible to set year of 1, since the lowest value of year is 1901.