If I understand you correctly, the issue is that the column with images is merged, which prevents the sorting in this column, unless the cells are unmerged. Still the rest content is rendered correctly without producing merged columns or rows. PictureBox items are rendered as Excel Picture Objects, thus my recommendation is to sort by other column containing value.
The Excel rendering produces XLS and XLSX files:
- Microsoft Excel 2007 and above (OpenXML 2.0)
- Microsoft Excel 97-2003 (BIFF, v.8)
Depending on the format sorting of images is different and requires additional settings. Feel free to log a feature request
for having images rendered in Excel in such manner they can be sorted based on the Excel version.
On report level, I can suggest you to allow users to sort data before exporting it:
- Sort data before loading it;
- Sort data via expressions e.g. How to add interactive sorting to a Table item?
I hope this information helps you.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items