Version: IgniteUi (R) 2015 Volume1 (JavaScript)
Problem description:
We try to export an igGrid with a date column to excel. Export is successful for all columns except the date column.The column value for the date column contains the values from all rows instead of only the current row.
Also during the 'cellExporting' event of 'ig.GridExcelExporter.export...' we can see that the 'args.cellValue' contains the values of all rows
Screenshot:
igGrid:
Excel:
Any ideas what could be wrong here?
Hello,
Thank you for posting in our community.
I have created and attached a sample trying to reproduce the behavior that you described using the latest 2015.1 service release. The cell value for the date column contains only the row's date value.
If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me.
0574.Sample.zip
Hi Martin,
thanks for your reply and sample.The version that you are using in your sample is newer than the version we have.
Because you also don't need to use the following 'quick-fix' that is an known reported bug in this version:www.infragistics.com/.../gridexcelexporter-uncaught-error-empty-color-cannot-be-used-to-create-a-workbookcolorinfo-instance
We already tried to replace all 'latest' tags in your sample with a specific version string without success ;-)
Your sample is using:
/*!@license Infragistics.Web.Loader 15.1.20151.2410 * * Copyright (c) 2011-2016 Infragistics Inc. * * http://ko.infragistics.com/ * */
We are using:
/*!@license Infragistics.Web.Loader 15.1.20151.1005 * * Copyright (c) 2011-2015 Infragistics Inc. * * http://ko.infragistics.com/ * */
This part is also not working in our version:
$.ig.loader({ scriptPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/js/", cssPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/css/", resources: "igGrid, igGridExcelExporter" });
We have to use the following code, because 'igGridExcelExporter' is not known:
$.ig.loader({ scriptPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/js/", cssPath: "https://cdn-na.infragistics.com/igniteui/2015.1/latest/css/", resources: "igGrid.*, igCombo, igEditors, modules/infragistics.util.js, modules/infragistics.documents.core.js, modules/infragistics.excel.js, modules/infragistics.gridexcelexporter.js" });
Can you create a sample with the exact same version that we have?
Hi Hubert,
I have modified the sample for the igLoader to use local resources and test it with the version you mentioned. Still, the exported cell value for the date column contains only the row's date value.
Attached you will find my sample. Please test it on your side and let me know how it behaves. If this is not an accurate demonstration of what you are trying to achieve please feel free to modify it and send it back to me along with steps to reproduce.
70678.Sample.zip