Spreadsheet Cell Values for DateTime returning Number values

5 posts, 0 answers
  1. Ed James
    Ed James avatar
    9 posts
    Member since:
    Sep 2008

    Posted 02 Dec 2013 Link to this post

    I have a CSV file with Dates ("MM/DD/YYYY"). I wish to parse these values within the active worksheet as string values, but they're converted to number format (i.e. "22532"). I'm unable to get these values in the original string format.

    Is it possible to ensure all cell values are in String format, representing exactly how they are in a CSV file?
  2. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 04 Dec 2013 Link to this post

    Hi Ed,

    Thank you for contacting us!

    Unfortunately, my attempts to replicate the issue you describe were not successful. Could you please try to import your file in our click-once examples and see if you reproduce the issue there?  Also, please verify Q3 2013 (2013.3 1016) is the version of RadControls for WPF you are using.

    In order to analyze the roots of the problem we would need to replicate it on our side. For this reason if the issue persists please send us your project. Once we are able to reproduce the behavior locally, we will do our best to assist you further.

    We are looking forward to hearing from you again!

    Regards,
    Svetoslav
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    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. UI for WPF is Visual Studio 2017 Ready
  4. Jiri
    Jiri avatar
    40 posts
    Member since:
    Oct 2013

    Posted 26 Sep 2014 in reply to Svetoslav Link to this post

    Hi,

    I have exactly the same problem as reported by Ed James, except in Silverlight.

    var cell = ws.Cells[row, c]; // ws is Worksheet
    var val = cell.GetValue();
    var v = val.Value.RawValue; // v is now some strange number instead of for instance: 1.1.2014 - what is a value from excel's cell

    Could you please do something with that?

    Thank you,
    Jiri
  5. Nikolay Demirev
    Admin
    Nikolay Demirev avatar
    103 posts

    Posted 29 Sep 2014 Link to this post

    Hello Jiri,

    The date values are stored in the Worksheet as number values with specific number format. This is the reason why when you get the value of the cell the result is number. If you want to get the formatted result, you could use the following code snippet:

    CellSelection cellSelection = this.workbook.ActiveWorksheet.Cells[0, 0];
    cellSelection.SetValue(22532);
    cellSelection.SetFormat(new CellValueFormat("m/d/yyyy"));
      
    ICellValue value = cellSelection.GetValue().Value;
    CellValueFormat format = cellSelection.GetFormat().Value;
    CellValueFormatResult formatResult = format.GetFormatResult(value);
    string result = formatResult.InfosText;


    Regards,
    Nikolay Demirev
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
  6. Jiri
    Jiri avatar
    40 posts
    Member since:
    Oct 2013

    Posted 29 Sep 2014 in reply to Nikolay Demirev Link to this post

    Hi Nikolay,

    Thank you, great, this works nicely!

    Cheers,
    Jiri

Back to Top
UI for WPF is Visual Studio 2017 Ready