Subtotal Function in Spread returns wrong calculation on hidden columns

[kendo-bot]

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

Ticket ID: 1671335

Environment

jQuery: 3.4.1
Kendo UI version: 2024.4.1112
Browser: [all]