I have template formatting for one of the columns in the grid which renders data depending on the condition. When I am trying to export that grid to excel, the conditional formatted data is not showing up in excel.
Please find below the example in which second row under "Location Name" column is coming empty from backend, but is being rendered as "No Location". But if this grid is exported into excel, the Location Name on second row appears as empty, not as "No Location".
Can you please let me know the fix?