I am trying to export to excel using Kendo Grid with grouping enabled.
When the data is exported without any grouping applied, the HTML encoding / decoding works as expected and the text is displayed correctly when I open up the spreadsheet in Excel. However when I group by a column whose value contains an apostrophe (or any character needing encoding), the grouped row is exported to excel without decoding the apostrophe which the users find unpleasant.
The grouping row is being auto-generated from Kendo MVC HTMLHelper for Grid and after reviewing the documentation regarding limitations around Kendo templates when exporting data to Excel.
What is the correct way to export a grid with grouping enabled -- in particular, how does one use Kendo Export To Excel functionality with grouping row values whose text contains characters that must be HTML encoded? Is this functionality possible by default, or is custom code required to address this scenario when using ASP.NET MVC?