Duplicated
Last Updated: 30 Jan 2025 13:31 by ADMIN
Created by: Philip
Comments: 1
Category: SpreadProcessing
Type: Bug Report
0

trying to open the attached workbook with this code:

Telerik.Windows.Documents.Spreadsheet.Model.Workbook workbook;
using (Stream input = File.OpenRead("sample.xlsx"))
{
  var provider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
  // The import method enables you to also pass a byte[] with the XLSX document data
  workbook = provider.Import(input, TimeSpan.FromSeconds(30));
}

I get an unhandled exception:

An unhandled exception of type 'System.ArgumentNullException' occurred in Telerik.Documents.Spreadsheet.dll
Value cannot be null.

Any idea what's going on?

Thank you for your time,

 

Phil

Completed
Last Updated: 12 Nov 2025 11:41 by ADMIN
Release 2025.4.1104 (2025 Q4)
ConditionalFormattingRange' s Formattings collection is not correctly enumerated when there are rules with intermittent ranges.
Unplanned
Last Updated: 17 Feb 2025 15:34 by Sandy
Unplanned
Last Updated: 25 Feb 2025 14:53 by David
Chart with missing shape properties (shPr) is corrupted with black background after PDF export.
Unplanned
Last Updated: 21 Mar 2025 15:14 by Piotr
Unplanned
Last Updated: 18 Jul 2025 09:13 by Gilbert

Cached formula values are not respected for the AdditionExpression type.

GetResultValueAsString returns "#NAME?".

Unplanned
Last Updated: 03 Sep 2025 11:03 by Sandy
Add support for setting the Axis Type to Automatic.

Unplanned
Last Updated: 10 Sep 2025 12:38 by Giuseppe
Created by: Giuseppe
Comments: 0
Category: SpreadProcessing
Type: Feature Request
0
Add support for the FILTER function.
Unplanned
Last Updated: 11 Nov 2025 11:45 by Martin Ivanov
Currently, you cannot sort filtered cell ranges that contain merged cells. This is supported in Excel.
In Development
Last Updated: 30 Jan 2026 07:53 by ADMIN

LocalizableException is thrown after removing columns from a workbook with set Print Titles.

Workaround - Remove the PrintTitles before removing the columns:

WorksheetPageSetup pageSetup = workbook.ActiveWorksheet.WorksheetPageSetup;
pageSetup.PrintTitles.RepeatedRows = null;
pageSetup.PrintTitles.RepeatedColumns = null;