Hi,
I am using Infragistics with SilverLight and using the Excel Engine to open the excel file on client side and refresh the data however the document needs to be refreshed for formulas and one of the sheet uses GetPivotData function which was not supported any idea if with new release it is supported or not ? Also can someone suggest an alternative.
Thanks
Hi shaileng,
The current release does not support the GetPivotData function. You can see a list of supported and unsupported functions here: http://help.infragistics.com/doc/WPF/2014.2/CLR4.0/?page=IGExcelEngine_List_of_Supported_Built_in_Functions.html
I recommend that you submit this as a new product idea here: http://ideas.infragistics.com