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

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.

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

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

When importing a document with encrypted records a NotImplementedException is thrown: System.NotImplementedException: "Implement it based on poi 4.2 in the future".

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.

Add support for Excel 5.0/95 Workbooks.

From the OOXML Specification: A comment is a rich-text note that is attached to and associated with a cell, separate from other cell content.

In Office 365 there are two types of comments:

• Comments/Notes
• Threaded Comments

This item applies to Comments/Notes only.

For Threaded Comments, please follow: SpreadProcessing: Comments (Threaded Comments)

When importing a document containing a formula with an invalid reference an exception is thrown: FormulaParseException: 'Unused input [A1] after attempting to parse the formula [#REF!A1]'

When importing a document containing a destination that does not refer to a formula an exception is thrown: System.NullReferenceException: 'Object reference not set to an instance of an object.'

Exporting sheet properties corrupts the file and it cannot be opened in Excel.

In the latest version we export: 

<sheetPr>
<pageSetUpPr fitToPage="true" />
<tabColor rgb="FF92D050" />
</sheetPr>

Excel cannot read this and tries to recover the file unsuccessfully. This works in R3 2020.

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

Provide API to set the position of the second axis (left or right).

Wrong text position in a specific file when exporting to PDF

Provide API allowing to import documents on background thread. The API should allow the passing of a CancellationToken in order to cancel the import at any time.

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.

 

The current implementation of the XlsFormatProvider supports the BIFF8 format only.

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.

At this point, XlsFormatProvider doesn't support images and they are not imported into Workbook while reading an .xls file.

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);

  }