Completed
Last Updated: 15 Jul 2015 10:56 by Marcel
ADMIN
Dess | Tech Support Engineer, Sr.
Created on: 04 Feb 2014 08:31
Category: PivotGrid
Type: Bug Report
2
FIX. RadPivotGrid - the exported Excel file with decimal cells is not displayed correctly in Excel
Change the Decimal symbol/separator  to "," and run Excel export for the RadPivotGrid. Note that all "0,00" cells are displayed as "1" in Excel and all decimal values are displayed without decimal separator.

Another scenario is when you change the Format in the Regional settings to Russia. Then, when exporting data, the decimal separator for the GrandTotal column is not correct ".", instead of ",". However, for the data cells it is OK.
1 comment
Marcel
Posted on: 05 Feb 2014 10:31
With this code when the problem can be solved, at least in my case:

 private void Reemplazar_Punto_Coma_ParaExcel(string Fichero)
        {
            using (StreamWriter fileWrite = new StreamWriter(Fichero + "1"))
            {
                using (StreamReader fielRead = new StreamReader(Fichero))
                {
                    String line;
       
                    while ((line = fielRead.ReadLine()) != null)
                    {
                         if(line.Contains(","))
                         {
                             line = line.Replace(",",".");
                         }
                         fileWrite.WriteLine(line);
                    }
                }
            }

            //aqui se renombrea el archivo temporal
            File.Delete(Fichero);
            File.Move(Fichero + "1", Fichero);
        }