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
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
Rank 1
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?
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