kendo.ooxml.Workbook does not properly calculate autoWidth of columns when several cells are merged

[veselints]

Bug report

kendo.ooxml.Workbook does not properly calculate autoWidth of columns when several cells are merged. The autoWidth setting does not take into account the fact that the merged cells could accommodate longer text. As a consequence, the width of the first column containing a merged cell is calculate to accommodate the full length of the text in the merged cells.

Related to #4089

Reproduction of the problem

Run the following Dojo. You will notice that the text on line 3 will force the column A width to accommodate its full width, even if the A3, B3 and C3 cells are merged.

Expected/desired behavior

The text on row 3 is expected to fit in the width of columns A, B and C together. If text is longer, the last column (C) should be forced wider.

Environment

• Kendo UI version: 2023.3.1114
• Browser: all

[GerryOnGithub]

I find it (autoWidth) also does not work properly when combined with colSpan, it is as if colSpan does not exist.