I'm using AgGrid React with row groupings. For entries that do not have a value for the Column I'm grouping by, it shows as '(Blanks)' in the table which is fine, but exporting to excel loses that text and I can't find an option to modify it.
The data underneath exports fine, just the title of the grouping is blank. I was hoping something like the following would help, but apparently AgGrid handles the empty
row groups by default and overwrites in this case Empty Group
with a blank cell
processRowGroupCallback: (params) => {
if (!params.node.groupData) {
return `Empty Group`
}
return params.node.key
}