Range fillFrom method overwrites formatting and validation rules

4 posts, 1 answers
  1. Brian
    Brian avatar
    5 posts
    Member since:
    Feb 2018

    Posted 06 Mar 2018 Link to this post

    There's already an enhancement in the works to allow copy/paste of only values to prevent overriding cell formatting and validation rules.  I've found several approaches to work around this limitation, but I have not found any way to do the same thing when using the Range fillFrom method.

    If I specify column-level formatting and validation, the default fillFrom works when filling vertically, but it overwrites other column rules when filling horizontally. Are there any similar workarounds for fillFrom like there are for copy/paste?

  2. Answer
    Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 08 Mar 2018 Link to this post

    Hello Brian,

    There is a workaround, that would allow you to avoid the formatting change when using the Range.fillFrom() method. Nevertheless, it would require the override of virtually the entire auto fill logic of the Range.

    Here you could find a Dojo sample demonstrating how the above could be achieved. Note, that the suggested workaround has not been extensively tested and some issues may arise from its use.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Brian
    Brian avatar
    5 posts
    Member since:
    Feb 2018

    Posted 14 Mar 2018 in reply to Veselin Tsvetanov Link to this post

    This is helpful, thanks.  However, since this is essentially a complete override of Range.fillFrom() without support, I won't be using it unless it becomes essential for my use case. Based on my initial testing though, it seems to work pretty well.

    Is there any plan to incorporate this into the main code base, even if it's just a customization option?

  4. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 16 Mar 2018 Link to this post

    Hello Brian,

    We do not have immediate plans to include the discussed as a feature in the Spreadsheet widget. Nevertheless, I have created the following enhancement issue in GitHub, where you could track the status of the task. Note, that the implementation of the above will depend on the priority queue of our backlog. Therefore, I won't be able to give you an estimate of when it will be available.

    Regards,
    Veselin Tsvetanov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top