Unplanned
Last Updated: 12 Dec 2023 09:28 by Ye
Ye
Created on: 12 Dec 2023 09:28
Category: Telerik Document Processing
Type: Bug Report
1
SpreadProcessing: Autofit fits to incorrect size when the content has word wrap set

In excel, if you set word wrap to cell content, make the column wider and then autofit the column in which it is, the content will fit to a reasonable width, as seen in the image below.

When doing the same in SpreadProcessing, the result is always a narrow column:

            CellSelection cellSelection = sheet.Cells[0, 0];
            cellSelection.SetIsWrapped(true);

            ColumnSelection columnSelection = sheet.Columns[0];
            columnSelection.SetWidth(new ColumnWidth(100, true));
            columnSelection.AutoFitWidth();

Result:

Here are the same steps performed in WPF RadSpreadsheet, which uses RadSpreadProcessing for its engine:

 

0 comments