Bug report
Subtotal Function in Spread returns wrong calculation on hidden columns. In Excel hidden columns does not reflect the result

Reproduction of the problem

1.https://demos.telerik.com/kendo-ui/spreadsheet/index
 
2. Paste =SUBTOTAL(109, E3:E11) in cell not in E column
 
3. Hide E column 
 
4. See result becomes 0

 

Expected

Same result as in Excel

Environment

jQuery: 3.4.1

Kendo UI version: 2024.4.1112
Browser: [all]