Hi,

I'm using V2010.3.1314.35 of Telerik and when I export my grid content to an Excel file format, Excel refuse to open
it with an error message. My RadGridView can contain data such "<Service>" and some DateTime.MinValue.

The problem seem's to be related to the kind of data I have in my grid but how I can solve my issue.

Here is my exportation method:

private void export()
        {
   stopRefreshTimer();
   try
   {
    try
    {
     const string extension = "xml";  // ExcelML is in XML. This xml file is intended to be opened by Excel
     const ExportFormat format = ExportFormat.ExcelML;

     SaveFileDialog dialog = new SaveFileDialog
     {
      Title = LocGeneral.GetControlText("ExcelExportation"),
      DefaultExt = extension,
      Filter = String.Format("{1} files (*.{0})|*.{0}", extension, "Excel"),
      FilterIndex = 1
     };

     // In this implementation, we do:
     // - If no items are selected in the grid, we export all items. In fact, the case where only 1 item is selected is considered as an intent to have them all.
     // - If 2 items or more are currently selected, we only export these items. This is considered a partial selection.
     IEnumerable allItems = (IEnumerable)ItemsList.Items;
     IEnumerable selectedItems = (IEnumerable)ItemsList.SelectedItems;
     int selectedItemCount = (ItemsList.SelectedItems != null && ItemsList.SelectedItems.Count > 0) ? ItemsList.SelectedItems.Count : 0;
     
     if (dialog.ShowDialog() == true)
     {
      formatGridDataBeforeExporting(selectedItemCount > 1 ? selectedItems : allItems);

      using (Stream stream = dialog.OpenFile())
      {
       GridViewExportOptions exportOptions = new GridViewExportOptions
       {        
        Format = format,
        ShowColumnFooters = false,
        ShowColumnHeaders = true,
        ShowGroupFooters = false,
        Items = (selectedItemCount > 1) ? selectedItems : allItems
       };

       ItemsList.Export(stream, exportOptions);
      }
     }
    }
    catch (Exception ex)
    {
     // Tell the user that exportation is not possible at this time. Ex: Selected file is in use.
     ClientUtilities.AlertDialog(this, LocGeneral.GetControlText("Error"), ex.Message);
    }
   }
   finally
   {
    modifyRefreshTimer();
   }
        }

Here is the new created Excel file:
<?xml version="1.0" encoding="UTF-8"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<Styles>
<Style ss:ID="GeneralDate">
<NumberFormat ss:Format="General Date"/>
</Style>
</Styles>
<Worksheet ss:Name="Worksheet1">
<Table>
<Column ss:Width="120"></Column><Column ss:Width="104"></Column><Column ss:Width="127"></Column><Column ss:Width="112"></Column><Column ss:Width="102"></Column><Column ss:Width="93"></Column><Column ss:Width="61"></Column><Column ss:Width="84"></Column><Column ss:Width="108"></Column><Row>
<Cell ss:Index="1"><Data ss:Type="String">Date d'ouverture</Data></Cell><Cell ss:Index="2"><Data ss:Type="String">Heure d'ouverture</Data></Cell><Cell ss:Index="3"><Data ss:Type="String">Date de fermeture</Data></Cell><Cell ss:Index="4"><Data ss:Type="String">Heure de fermeture</Data></Cell><Cell ss:Index="5"><Data ss:Type="String">Poste de travail</Data></Cell><Cell ss:Index="6"><Data ss:Type="String">Location</Data></Cell><Cell ss:Index="7"><Data ss:Type="String">Utilisateur</Data></Cell><Cell ss:Index="8"><Data ss:Type="String">Module</Data></Cell><Cell ss:Index="9"><Data ss:Type="String">Durée</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-01-24T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">07:45</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:11</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">albany-ris</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">server room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">94.07:26:03</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:25</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:25</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-A16B51</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:00</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:26</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:26</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-A16B51</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:00</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:27</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:27</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-A16B51</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:00</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:27</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:27</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-A16B51</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:00</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:07</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:39</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-D168AE</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">01:32:19</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:19</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:21</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-D168AE</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:56</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:25</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:26</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-D168AE</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">RIS</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:50</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:26</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:27</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:11</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:41</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:45</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:04:22</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:46</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:48</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:57</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">15:52</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">15:53</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:27</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:04</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:06</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:19</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:05</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:07</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:38</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:10</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:11</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:24</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:18</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:27</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:08:34</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:40</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">17:39</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-D168AE</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:58:07</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">16:41</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">16:52</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:11:30</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">17:25</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">17:26</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:32</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">17:42</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">1980-01-01T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">00:00</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">CHRISTIE-D168AE</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">Server Room</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String"><Service></Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Business Logic</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">-11805.17:42:14</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">17:43</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-27T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">17:45</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:02:00</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">09:11</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">10:48</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">01:37:18</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">10:59</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:01</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:01:35</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:12</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:13</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:58.5930000</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:16</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">11:17</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">00:00:43.7800000</Data></Cell></Row>
<Row>
<Cell ss:StyleID="GeneralDate" ss:Index="1"><Data ss:Type="DateTime">2012-04-30T00:00:00.000</Data></Cell><Cell  ss:Index="2"><Data ss:Type="String">11:26</Data></Cell><Cell ss:StyleID="GeneralDate" ss:Index="3"><Data ss:Type="DateTime">1980-01-01T00:00:00.000</Data></Cell><Cell  ss:Index="4"><Data ss:Type="String">00:00</Data></Cell><Cell  ss:Index="5"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="6"><Data ss:Type="String">AGOSSELIN-380</Data></Cell><Cell  ss:Index="7"><Data ss:Type="String">Superuser</Data></Cell><Cell  ss:Index="8"><Data ss:Type="String">Manager</Data></Cell><Cell  ss:Index="9"><Data ss:Type="String">-11808.11:26:53.2170000</Data></Cell></Row>
</Table>
<AutoFilter x:Range="R1C1:R1C9" xmlns="urn:schemas-microsoft-com:office:excel"></AutoFilter>
</Worksheet>
</Workbook>

Hello

Is there anyway to adjust the panels that are not " bringto view" transparency?
I'm trying to display one panel at a time, when the user navigates left or right the panel will appear accordingly.
Any thoughts?

Regards,
Rick

Hello,

I have wrapped a RadCarousel in a listbox.. Im not able to click on the radcarouselpanel to bring to the front.. Everything works fine

Help?
thank you
Rick

I have a LINQ to SQL Object in an ObservableCollection.  It has child objects which in turn have child objects of their own.  This structure mimics a recursive join on the table.

My issue is that when I remove a control from one of the child collections, it does not update the treeview.

i.e.


If I remove the item from the collection itself - that does not appear to work either.

I'm wondering what it would take to implement the entire drag and drop functionality on the right mouse button, ending with a context menu like in Explorer when you have a choice to Move or Copy files.  Any help would be appreciated.

Thanks in advance,
Steve

Hello!
I've RagGridView with some string type columns, one datetime typed and two decimal typed.
When I put random string, there (in CreateFilterExpression) allways stay records with decimal value equal 0 (zero).
I managed, that convert any string in decimal columns to 0 and check for equality. How can I skip the bolded part? Filter implementation is from your examples.

_compositeFilterDesriptor.CreateFilterExpression(parameterExpression);
In example:
Filter value is: "dasdasddasdasd"
Expression is: (stringColumn1 contains dasdasddasdasd) OR (stringColumn2 contains dasdasddasdasd) OR (dateTimeColumn IsEqual 01-01-0000) OR (decimalColumn1 IsEqual 0) OR (decimalColumn2 IsEqual 0)

Hi,

as you cann see on the attached File i'm looking for a approach or example to create a RadGridView with 7 Columns where
i can drag & drop Items between these columns and also in the column itself. Or an other Control to realize this request.

I need a Control with 7 Columns or 7 Controls or....
I need to drag & drop Items from one columns/control to the next column/control.
Each Item should be in his own color...

Can someone tell me an idea of ​​how I can implement this requirement?

I use: c# and wpf RadControls 2012 SP1

Thanks a lot Regards
Rene

I am using the RadGridView and RadDataPager in a WPF application. I have a method that pulls pages of Employees from a database (or some other data source). There are more Employees than I want to put in memory at one time, so I need to page the data retrieved from the database.

 

So, I have a method that returns pages of data in the form of IEnumerable<Employee>. Each IEnumerable<Employee> is one page of data.  The xaml is set up this way:

 

    <Grid>

...

        <telerik:RadGridView ItemsSource="{Binding PagedSource, ElementName=radDataPager}"

                             Horizontal Alignment="Left"

                             AutoGenerateColumns="False"

                             x:Name="radGridView1"

                             VerticalAlignment="Top"

                             Height="Auto"

                             Width="Auto"

                             Grid.Row="0">

            <telerik:RadGridView.Columns>

                <telerik:GridViewDataColumn DataMemberBinding="{Binding FirstName}"

                                            Header="First Name"

                                            UniqueName="FirstName" />

                <telerik:GridViewDataColumn DataMemberBinding="{Binding LastName}"

                                            Header="Last Name"

                                            UniqueName="LastName" />

                <telerik:GridViewDataColumn DataMemberBinding="{Binding Age}"

                                            Header="How Old?"

                                            UniqueName="Age" />

            </telerik:RadGridView.Columns>

        </telerik:RadGridView>

        <telerik:RadDataPager x:Name="radDataPager"

                              Source="{Binding Employees2}"

                              DisplayMode="FirstLastPreviousNext"

                              IsTotalItemCountFixed="False"

                              PageSize="3"

                              Grid.Row="1"

                              Margin="0,9,0,0"

                              PageIndexChanging="radDataPager_PageIndexChanging"

                              PageIndexChanged="radDataPager_PageIndexChanged"/>

    </Grid>

 

I only get the first page with 3 records. Can this be fixed, or am I trying to do something that these controls do not support?

 

What would be a better way to do what I am trying to do?

 

Thanks.

 

David

 

 

 

Hello.

I'm try host GridView WPF in WinForms App...

But I can't understand how refresh Grid.

When app starting Grid is clear. When I'm apply filter or sorting, data loading.

I'm try wpfGrid.Rebind(). No effect...

Our users have requested that we not perform an immediate filter when a distinct filter checkbox is clicked.  They would rather be able to select multiple checkboxes, then press the Filter button.  We call a web service to retrieve data each time filtering is performed, so this has become a performance issue.

Is there an easy way to turn off the instant filtering, or do we have to write a completely custom control?

Thanks for your help.