I have a master detail grid and I have to export to excel. The master detail grid is all collapsed  and users see the details when expanding the required item. Everything works fine except that when I export to excel all data that have bee EXPANDED since last refresh will bee expanded in Excel.   Enay one have a solution to this ...