I'm really kind of disappointed that the spreadsheet was released in this state. The filter capability is so broken on the spreadsheet, it's basically a _danger_ to use.
The bug has been reported, for the life of me I can't see why it's only a SEV: Medium, but here it is:
Editing cells in range, when filter is applied, modifies the cells in between
https://github.com/telerik/kendo-ui-core/issues/2880
Not only does the spreadsheet delete values from cells hidden via a filter, it _pastes over them_ as well. This makes it very dangerous to use this feature in any sort of production application because your users could experience *invisible* data loss. That to me is a huge... massive... red flag.
Because of this issue I find I have to hack my way through the products operational runtime and am strongly considering a competitor's widget instead. I don't want to do this because we've invested quite a bit of time and money into Kendo.
I hope you have plans to address this very soon.
The bug has been reported, for the life of me I can't see why it's only a SEV: Medium, but here it is:
Editing cells in range, when filter is applied, modifies the cells in between
https://github.com/telerik/kendo-ui-core/issues/2880
Not only does the spreadsheet delete values from cells hidden via a filter, it _pastes over them_ as well. This makes it very dangerous to use this feature in any sort of production application because your users could experience *invisible* data loss. That to me is a huge... massive... red flag.
Because of this issue I find I have to hack my way through the products operational runtime and am strongly considering a competitor's widget instead. I don't want to do this because we've invested quite a bit of time and money into Kendo.
I hope you have plans to address this very soon.