Hello,
I am exporting a grid using: $.ig.GridExcelExporter.exportGrid(...);
My grid have null values in columns of type datetime, number, so on.
When I export the grid, the null fields appear fill with the before values concatenated.
How I keep the null fields empty?
Thanks you and kind regards.
This answer is perfect.
Thank you very much
Hello Sergio,
I have investigated in detail the differences between 16.2 and 17.2. The matter is the implementation of localizing in 17.2 has changed to ease the developers, so what worked for 16,2 is not expected to work for 17.2.
Below I will review the process of localizing all controls on the page:
1) Load the necessary locale resources using the igLoader:
$.ig.loader({ scriptPath: 'localhost/.../', cssPath: 'localhost/.../', resources: 'igGrid.*, igCombo', locale: 'es', regional: 'es' });
2) Set the regional/language options globally for all controls on the page:
$.ig.loader(function () { $.ig.util.changeGlobalRegional("es"); $.ig.util.changeGlobalLanguage("es");....});
I am uploading a sample where this is demonstrated and both the igGrid and igCombo on the page are localized in Spanishgrid+combo_localized_17.2.html.zip
Hi Sergio,
My suggestion is more like an immediate solution that I could give you at the moment.
I will take the time to investigate why there are differences between 16.2 and 17.2 and will update you about my findings. It may turn out my solution is not complete or proper or there is a mistake in our code.
I will update you tomorrow by the end of the day on that matter.
Thank you very much.
I will think if update the version.
I have many grids, dialogs... and set the attributes language and regional in all them is a hard work.
Regards
Exporter_2017.2.html.zip
It turns out the igLoader is told what locale resources to load, and the igGrid itself still needs to be told which if these locales to use:
$.ig.loader({ scriptPath: 'cdn-na.infragistics.com/.../', cssPath: 'cdn-na.infragistics.com/.../', resources: 'igGrid.*,' + 'igGridExcelExporter', locale: "es",});
$.ig.loader(function () { $("#grid1").igGrid({ language: "es", regional: "es-ES", ...
I have modified your sample with the 2017.2 version
Please let me know if you have further questions, I will be glad to help.