Column Level Formating/DataType

4 posts, 0 answers
  1. Jim
    Jim avatar
    6 posts
    Member since:
    Feb 2013

    Posted 24 Feb Link to this post

    I am currently using the spreadsheet and a manual data entry form for users that currently have a lot of data stored in Excel spreadsheets.
    I need to take data and format the data to a date format but only in certain columns (all cells below a certain column). It would be helpful to apply some sort of ID/name or something similar to give cells a unique identifier.
  2. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 29 Feb Link to this post

    Hello Jim,

    Can you please elaborate what problem you are facing? Are users importing the excel data via the Kendo UI spreadsheet, or directly in the database via the document processing library? Do you want to format all cells in a spreadsheet range?

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Jim
    Jim avatar
    6 posts
    Member since:
    Feb 2013

    Posted 01 Mar Link to this post

    The users are just copying the data they already have in Excel into the spreadsheet control. From there I am processing it to the server and storing the data in the database.
  5. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 07 Mar Link to this post

    Hello Jim,

    Cells have a unique identifier -- their row and column (A1, B3). You can apply a format to a complete column via a range like "A:A" (in which "A" is the name of the column). See the format method of the range object.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready