Drag to copy date format column

2 posts, 0 answers
  1. Su Pei
    Su Pei avatar
    11 posts
    Member since:
    Nov 2016

    Posted 29 Nov 2016 Link to this post


    When I drag the date format column in spreadsheet, it'll automatically add 1 day of the next copied column.

    I wish to copy the value of the column instead of fill the series. Is there any way to do so?

    If I set it to string format, it'll fill the series by adding 1 year to it. The date format that I used was "dd-MMM-yyyy".




    Su Pei


  2. Stefan
    Stefan avatar
    2913 posts

    Posted 01 Dec 2016 Link to this post

    Hello Su Pei,

    This is expected behaviour and it can be observed in most of the Spreadsheet editors.

    I can confirm that Excel will give the option to either fill the series or copy the values, but this feature is currently not supported.

    I can suggest submitting a feature request in our UserVoice portal and based on its popularity we may implement it in a future release:


    On the other hand, I would like to present you an offering that may be relevant and applicable to your needs - our Feature Acceleration program. It allows a customer to negotiate certain components or functionality to be implemented on demand or sooner than our roadmap implies. Feature acceleration fits well in scenarios where a feature or enhancement is important for an application's success, but it is not planned to be available at the time of the application's completion. 

    Let us know if you are interested in pursuing this option at any time and I will arrange for our Professional Services team to get in touch with you to discuss your exact requirements and possible timeframes.

    Telerik by Progress
    Kendo UI is ready for Visual Studio 2017 RC! Learn more.
Back to Top