I can manipulate the args.cellValue but after transforming a number value to a string and assigning it back to args.cellValue the headerTitle comes out as NaN(not a number).
Is there any way to prevent this behaviour?
Hello Eugenio,
Thank you for contacting the Infragistics support!
We have tried to reproduce the issue that you describe but were not able to reproduce the issue. Would you be able to provide an isolated sample that reproduces the problem that you are facing so that we would be able to investigate this matter further?
Thank you in advance!
I am looking forward to your response!
Alexander Marinov
I can't quite make it work in JSFiddle at all, can you provide me of the right js and css files to include in the jsfiddle to make igGrid and GridExcelExporter work?
Hello Eugenio,you may use this JSFiddle sample as a starting point - http://jsfiddle.net/gh/get/jquery/1.9.1/igniteuisamples/jsfiddle-samples/tree/master/EN/HtmlSamples/grid/export-basic-grid/Please, let us know if you face any issues related to this case.
Regards,Alexander
Thanks, I was able to have the right scripts.Here's the jsfiddle that reproduce the "NaN" header title issue:jsfiddle.net/.../
Thank you for the provided sample!
The reason for the behavior you see is that
Number(args.cellValue)
Can you please see this updated example and tell me if it is working well for your scenario - https://jsfiddle.net/epyh7bLa/
This example produces the same output and the header text is exported correctly.
Please, let me know if this approach is working fine for you.
Best regards,Alexander
Not at all, it just deletes any punctuation.
But anyway, from what I grasp, cellValue can also assume the value of the header, that explains NaN.So the best way is to introduce "if (args.cellValue == "value" || args.cellValue == "trend") return" and being able to skip the header cells.
Thanks for the support