csv file import: wrong column format

3 posts, 0 answers
  1. pharmadev
    pharmadev avatar
    7 posts
    Member since:
    Dec 2012

    Posted 06 Jul 2013 Link to this post

    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.
  2. Andrew
    Admin
    Andrew avatar
    140 posts

    Posted 10 Jul 2013 Link to this post

    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
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. DevCraft banner
  4. pharmadev
    pharmadev avatar
    7 posts
    Member since:
    Dec 2012

    Posted 27 Jul 2013 Link to this post

    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!


Back to Top