[Solved] csv file import: wrong column format

[pharmadev]

Hi,

after using this code 

CsvFormatProvider formatProvider = new CsvFormatProvider();
            ofd.Filter = "CSV (comma delimited) (*.csv)|*.csv|All Files (*.*)|*.*";

            if (ofd.ShowDialog() == true)
            {
                try
                {
                    using (Stream input = ofd.File.OpenRead())
                    {
                        this.spreadsheet1.Workbook = formatProvider.Import(input);

One of my entries in the csvfile has a value of  001-01. In the spreadsheet, i see the value of Jan-01. The value is totally wrong and really don't know where is the problem on my side. Any idea? How can i get around this error?

Attached to this thread, you'll find a snapshot of the csv file. Look at the SCRNNUM, SUBJID columns.

[Andrew]

Hi pharmadev,

Thank you for contacting us!

We investigated the issue and it turns out to be a bug. We will do our best to fix it in some of our next releases.

Regards,
Andrew
Telerik

[pharmadev]

Hi, 

I just want to thank the Telerik team for this issue. The bug is fixed in your latest build (2013.2 724). 
RadSpreadsheet is a great control!Great work! Great support!