Unplanned
Last Updated: 24 Apr 2024 12:37 by Jean-Pierre
PdfFormatProvider: NetStandard: Converting multiple XLSX copies to PDF with separate SpreadFixedTextMeasurers generates a different first document. 
Unplanned
Last Updated: 24 Apr 2024 08:05 by Sudhakar

Incorrectly resolved fill between local formatting and cell style.

A fill (fillId) of a cell style (cellStyleXfs) is respected instead of the fill (fillId) of the local formatting (cellXfs).

In Development
Last Updated: 24 Apr 2024 09:24 by ADMIN
Sometimes when an XLSX file has a combo chart, you can get an error on import "The axes are incorrectly paired.". This happens when a combo chart has secondary axes and the file has likely been produced by an application other than Excel.
In Development
Last Updated: 16 Apr 2024 11:12 by ADMIN
ArgumentNullException when importing documents containing comments with no DateTime.
Unplanned
Last Updated: 20 Mar 2024 12:49 by Göran

Use the below code snippet to generate XLSX document and export it. You will notice that the export operation is extremely slow:

Stopwatch sw = new Stopwatch();
sw.Start();
IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();
Worksheet worksheet2 = workbook.Worksheets.Add();
worksheet2.Name ="Days";
List<string> weekdays = new List<string>() { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"};
for (int i = 0; i < 7; i++)
{
    worksheet2.Cells[0, i].SetValue(weekdays[i]);
}

for (int i = 0; i < 200; i++)
{
    for (int j = 0; j < 10; j++)
    {

        CellIndex cellIndex = new CellIndex(i, j);
        CellSelection selection = worksheet.Cells[cellIndex];
        selection.SetValue("Wednesday");

        var context = new ListDataValidationRuleContext(worksheet, cellIndex)
        {
            InputMessageTitle = "InputMessageTitle",
            InputMessageContent = "InputMessageTitle"
        };

        context.ErrorStyle = ErrorStyle.Stop;
        context.ErrorAlertTitle = "ErrorAlertTitle";
        context.ErrorAlertContent = "ErrorAlertContent";
        context.InCellDropdown = true;
        context.Argument1 = "=Days!A0:A6"; //"Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday";
        ListDataValidationRule rule = new(context);
        worksheet.Cells[cellIndex].SetDataValidationRule(rule);
    }
}

string outputFile = @"..\..\..\output.xlsx";
File.Delete(outputFile);

using (Stream output = new FileStream(outputFile, FileMode.Create))
{

    formatProvider.Export(workbook, output);
}
sw.Stop();
Debug.WriteLine("Export " + sw.ElapsedMilliseconds);

Unplanned
Last Updated: 11 Mar 2024 10:18 by Albert

Import an XLSX document and auto-fit the columns. Then, export the document to XLSX format.

Even though a SpreadFixedTextMeasurer is applied and a FontProvider is implemented, the columns are not wide enough to fit the content:

 

Unplanned
Last Updated: 22 Feb 2024 19:28 by Marcelo
If the conditional formatting is missing, the copy operation is executed with no errors.
Unplanned
Last Updated: 21 Feb 2024 14:19 by Fritz

Incorrect calculation of UsedCellRange when conditional formatting is applied to a large cell range.

Workaround:

var usedCellRange = workbook.ActiveWorksheet.GetUsedCellRange(
    CellPropertyDefinitions.AllPropertyDefinitions
    .Except(
        CellPropertyDefinitions.AllPropertyDefinitions.Where(p => p.Name == "DataValidationRule" || p.Name == "ConditionalFormatting")));

 

Unplanned
Last Updated: 20 Feb 2024 09:07 by Lleonard
Empty cell of an unprotected column remains protected if it has a format set to it.
Unplanned
Last Updated: 11 Jan 2024 13:59 by Dev

Use the code to import a sample txt file containing a "+" sign in a cell value:

 Workbook workbook;
 Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.TextBased.Txt.TxtFormatProvider();

 using (Stream input = new FileStream(@"sample.txt", FileMode.Open))
 {
     workbook = formatProvider.Import(input);
 }

Expected behavior: the file is imported successfully

Actual behavior: an error is thrown

 

Completed
Last Updated: 15 Jan 2024 11:02 by ADMIN
Release 2024 Q1
When a document containing charts is imported sometimes an exception is thrown: "The axes are incorrectly paired"
Completed
Last Updated: 09 Jan 2024 09:38 by ADMIN

ArgumentException  at Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.Theme.SystemColorElement.GetColor(IOpenXmlImportContext context)

The problematic value is val="windowText"

Completed
Last Updated: 30 Oct 2023 13:22 by ADMIN
Release R3 2023 SP1
InvalidOperationException is thrown in files where the Comments part is imported after the ThreadedComments part.
Completed
Last Updated: 31 Oct 2023 06:17 by ADMIN
Release R3 2023 SP1
When a sheet is protected in an asynchronous scenario an exception is thrown: System.ArgumentException: 'An item with the same key has already been added. Key: RIPEMD-160'.
Completed
Last Updated: 31 Oct 2023 07:48 by ADMIN
Release R3 2023 SP1
FormulaParseException when importing XLS document containing #REF error in formula.
Unplanned
Last Updated: 04 Oct 2023 08:14 by Cyril

Sometimes leading minus sign in a cell with text is treated as a formula.

A possible workaround is to remove the minus sign or to replace it with some other symbol.

Unplanned
Last Updated: 04 Oct 2023 08:12 by Cyril

When there are unclosed quotes (") several cells/rows are imported as one.

A possible workaround is to replace all the quote (") symbols with single quote (') symbols.

Completed
Last Updated: 27 Sep 2023 11:17 by ADMIN
An exception is thrown if a conditional formatting rule is resolved for a cell with a row index greater than the max column index.
Unplanned
Last Updated: 05 Sep 2023 11:36 by NKT
Icon sets 'ThreeTriangles', 'ThreeStars', 'FiveBoxes', and 'Custom' are set as a 'ThreeTrafficLightsUnrimmed' when setting a rule.
Unplanned
Last Updated: 01 Aug 2023 11:23 by ADMIN
Column AutoFitWidth is not calculated when the text inside a cell is on more than one line.
1 2 3 4 5 6