When there is some long number value in merged cell and this cell is autofit, then in Excel the cell is visualized with "#####" because the column width is not enough.

Workaround: As a workaround in some scenarios it is possible to call Merge method after AutoFitWidth method in order get the correct column width.

To reproduce: 

CultureInfo cultureInfo = new CultureInfo("es-ES");
var currency_info = new Telerik.Windows.Documents.Spreadsheet.Formatting.FormatStrings.CurrencyInfo(cultureInfo.NumberFormat.CurrencySymbol, cultureInfo);
var format_string = AccountingFormatStringBuilder.BuildFormatString(currency_info, cultureInfo.NumberFormat.CurrencyDecimalDigits);
 

Make it possible to change the series fill color.

Importing XLSX file in Blazor Web Assembly for .NET 5.0 is very slow.

 

          <InputFile OnChange="@HandleFileSelected" />

 

async Task HandleFileSelected(InputFileChangeEventArgs e)

{

   var ms = new MemoryStream((int)e.File.Size);
        Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
        using (Stream ey = e.File.OpenReadStream(e.File.Size))
        {
            await ey.CopyToAsync(ms,(int)e.File.Size);
            ey.Close();
        }
        oWorkbook = formatProvider.Import(ms);

  }  

When the column has cells that span several rows, the auto fit of column width is not working.

Workaround: If the document is being generated with the API, autofit the contents before merging the data.

The files are not properly recognized when the base64 string representing the exported XLS file is converted using https://base64.guru/converter/decode/file.

If an XLS file produced by MS Excel is converted with the same tool, it is generated with .bin extension.

 

When printing or exporting to PDF, the left border of A1 cell is not printed/rendered.

WorksheetPageSetup.ScaleFactor is limited in the range 0.5 - 4 due to limitations in the UI implementations, but this is not needed in RadSpreadProcessing alone.

The second axis of the chart is not displayed regardless of the position.

Add support for Excel 5.0/95 Workbooks.

When exporting to PDF, the hidden sheets should not be included in the layout. Or, at least, there should be an option whether to skip them or not.

Importing a document containing [hh]:mm number format causes an ArgumentException.

Formulas referring to cells containing cell references are not recalculated if the imported document containing cached formula values.

If there are cells in the column with wrapped content, containing text with more than one word, and other cells with smaller content, the auto-fitting does not respect the width of the wrapped cell and sets the column width to the width of the other smaller cells.

The import process takes much time when the formatting of the cells needs to be resolved. 

An exception is thrown when importing a document containing custom number formats with date or time part and empty sections.

When defaultThemeVersion is missing from the file, some styles are not shown when the document is opened in MS Excel.

Exception when rounding a decimal value in a formula with a lot of precision numbers

The content of some rows which contain new lines can be clipped when a fixed-width column is wrapped.

This can be observed in the following images.

Before the export:

After the export: