This is a migrated thread and some comments may be shown as answers.
Range fillFrom method overwrites formatting and validation rules
3 Answers 10 Views
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 06 Mar 2018, 09:38 PM

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?

3 Answers, 1 is accepted

Sort by
0
Accepted
Veselin Tsvetanov
Telerik team
answered on 08 Mar 2018, 01:20 PM
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.
0
Brian
Top achievements
Rank 1
answered on 14 Mar 2018, 01:55 PM

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?

0
Veselin Tsvetanov
Telerik team
answered on 16 Mar 2018, 08:01 AM
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.
Asked by
Brian
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Brian
Top achievements
Rank 1
Share this question
or