[Bug][Spreadsheet] activeSheet method does not change the selected sheet

[kdikov82]

I'm submitting a...

• Bug report

Current behavior

Using the activeSheet method does not change the sheet

Expected behavior

Using the Spreadsheet activeSheet method should allow changing the selected sheet programmatically

Minimal reproduction of the problem with instructions

Clicking on the button and using the activeSheet method does not change the active sheet: https://codesandbox.io/p/sandbox/heuristic-dawn-wk7c9j?file=%2Fapp%2Fmain.jsx%3A12%2C5

Package versions: 7.4.0

Related to: https://github.com/telerik/kendo-spreadsheet-common/issues/93

[WissamProgress]

Also reported in Ticket ID: 1658738

[filipKovachev]

Reported in Ticket ID: 1689029

[filipKovachev]

Also reported in Ticket ID: 1701908