Also waiting for a solution to this for years. For small reports I can sometimes screenshot what I need but that is a very primitive workaround.
I made a report and grouped values in the report. When sending it via email as an Excel spreadsheet, I get a raw Excel file with no grouping/filters applied.
Probably a quick fix for SS dev team.
Best regards,
Primoz