Value is not displayed after merging formula cells in Spreadsheet

[martintabakov]

Bug report

Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.

Reproduction of the problem

1. Open this Dojo example - https://dojo.telerik.com/UwexICot/4

Current behavior

The value of the B1:B2 merged cell is not displayed.

Expected/desired behavior

The value of the B1:B2 merged cell should be displayed.

Environment

• Kendo UI version: 2022.1.119
• Browser: [all]

[mishoo]

When using the API, you should do it in a batch to trigger a recalculation, like this: https://dojo.telerik.com/UwexICot/6

This said, if you type in C1 =A1*2 and then merge C1:C2 from the toolbar, the value will also be hidden until a recalculation is triggered by changing any cell, so a little bug is still there..