When using named references in formula columns on the UltraGrid is it possible to export them to Excel when using the ExportFormulas option. The formulas are being exported with an error.
Hi,
No, this is currently not supported. Only references to other cells in the grid are exported, because there's no way to translate external references (such as other controls on the form) into Excel.
In theory, as long as a NamedReference doesn't reference anything outside of the grid, it could be exported into a hidden worksheet and referenced by the Excel sheet, but this is currently not implemented.
You should Submit a feature request to Infragistics
It would seem that the easiest way to replicate a NamedReference would be to define a Name in Excel with the formula being equal to the NamedReference value at the time of export. I will definitely create a feature request for this because as it stands it is impossible to export a grid column that references a NamedReference in its formula.