Telerik Document Processing Feedback Portal

Completed

Last Updated: 08 Feb 2022 13:22 by ADMIN

Release R1 2022 SP1

SpreadProcessing: NullReferenceException when importing a document that contains vml shapes with no row and column

Created by: Tom

Comments: 1

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: NullReferenceException when importing a document that contains vml shapes with no row and column

NullReferenceException when importing a document that contains vml shapes with no row and column

Unplanned

Last Updated: 21 Jan 2022 15:30 by ADMIN

SpreadProcessing: Add support for rich text in notes

Created by: Joseph

Comments: 0

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Add support for rich text in notes

Currently, the notes can contain plain text only. Allow inserting and preserving formatted text inside the notes.

Unplanned

Last Updated: 01 Feb 2022 08:23 by ADMIN

SpreadProcessing: Allow executing macros inside a spreadsheet document

Created by: Mandip Kaila

Comments: 0

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Allow executing macros inside a spreadsheet document

Enable the users to execute the macros that are inside their files.

Completed

Last Updated: 16 Mar 2022 07:45 by ADMIN

Release R2 2022

SpreadProcessing: Handle import of documents containing unclosed <br> elements in the vmlDrawing part

Created by: Robert

Comments: 1

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Handle import of documents containing unclosed <br> elements in the vmlDrawing part

When importing a document with an unclosed <br> element in the vmlDrawing part an exception is thrown: System.Xml.XmlException: 'The 'br' start tag on line 183 position 14 does not match the end tag of 'font'. Line 184, position 7.'

Completed

Last Updated: 16 Mar 2022 13:51 by ADMIN

Release R2 2022

SpreadProcessing: Add support for CONCAT function

Created by: Nicholas

Comments: 1

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Add support for CONCAT function

In newer versions of EXCEL (2019 and later) the CONCAT function is introduced as a replacement of the old CONCATENATE function. It adds the ability to specify a range of cells when generating the resulting string in addition to its previously supported input arguments.
NOTE: In EXCEL starting from version 2019, CONCATENATE can no longer be inserted in the worksheet through the UI, it can only be used if you type it directly in the cell's contents.

Completed

Last Updated: 25 Mar 2022 13:46 by ADMIN

Release R2 2022

SpreadProcessing: The codeName attribute of sheet properties is not preserved on import/export

Created by: Gabriel

Comments: 1

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: The codeName attribute of sheet properties is not preserved on import/export

The attribute is lost when importing a document. This might lead to corrupting the macros.

Completed

Last Updated: 13 Apr 2022 14:14 by ADMIN

Release R2 2022

SpreadProcessing: ArgumentException is thrown when importing an XLSX document with a comment (Note) without author

Created by: Franz

Comments: 2

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: ArgumentException is thrown when importing an XLSX document with a comment (Note) without author

Hello,

An exception is thrown when importing an xlsx file which has a comment that does not have an author. But the author may be null.

System.ArgumentException: 'author'

This exception was originally thrown at this call stack:
    Telerik.Windows.Documents.Spreadsheet.Utilities.Guard.ThrowExceptionIfNullOrEmpty(string, string)
    Telerik.Windows.Documents.Spreadsheet.Model.NoteCollection.Add(Telerik.Windows.Documents.Spreadsheet.Model.CellIndex, Telerik.Windows.Documents.Spreadsheet.Model.CellIndex, string, string)
    Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.XlsxWorksheetImportContext.ApplyNoteInfo(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Contexts.NoteBase)
    Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Comments.CommentElement.OnAfterRead(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Import.IXlsxWorksheetImportContext)
    Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Model.Elements.Comments.CommentsElementBase.OnAfterRead(Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.Import.IXlsxWorkbookImportContext)
    Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase<TImportContext, TExportContext, TPartsManager>.OnAfterRead(Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
    Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
    Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
    Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.Read(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
    Telerik.Windows.Documents.FormatProviders.OpenXml.Model.Elements.OpenXmlElementBase.ReadChildElements(Telerik.Windows.Documents.FormatProviders.OpenXml.IOpenXmlReader, Telerik.Windows.Documents.FormatProviders.OpenXml.Import.IOpenXmlImportContext)
    ...
    [Call Stack Truncated]

This is the code that can be used to reproduce the issue, according to your documentation:

        Workbook workbook;
        XlsxFormatProvider formatProvider = new XlsxFormatProvider();

        using (Stream input = new FileStream(_path, FileMode.Open))
        {
            workbook = formatProvider.Import(input);
        }

I have attached a document that got a comment without an author.

Unplanned

Last Updated: 19 May 2022 12:32 by Rik

SpreadProcessing: Properties applied on row/column selection are not respected by used cells when exporting to XLSX

Created by: Rik

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Properties applied on row/column selection are not respected by used cells when exporting to XLSX

The values applied to the row/column should be explicitly set on each used cell as well. Otherwise, if they are applied on row/column only, the used cells don't use the desired values when opening the document.

To reproduce:

Set some content on cell A1
Create a row selection and apply a fill color to it (or any other property)
Export the document and open it in an application

Observed: All cells except A1 have the specified color.

Workaround: Use cell selection, e.g.:

sheet.Cells[0,10].SetFill(PatternFill.CreateSolidFill(Colors.Red));

Unplanned

Last Updated: 06 Jun 2022 09:31 by Patrick

SpreadProcessing: Renaming a sheet to a name with empty spaces, does not add single quotes to new name in formula references. This invalidates said formulas.

Created by: Patrick

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Renaming a sheet to a name with empty spaces, does not add single quotes to new name in formula references. This invalidates said formulas.

For example:
Renaming a sheet named "Sheet1" to "Sheet 1", should update formulas references to it to 'Sheet 1!' (notice single quotes), which it does not. The formula =SUM(Sheet1!A2:C2) changes to the invalid expression =SUM(Sheet 1!A2:C2). This breaks formulas referencing that sheet.

Workaround:
Iterate all cells with formulas in the workbook and add single quotes to the beginning and end of sheet name reference. The attached project changes the name of Sheet1 and then fixes all formula references to it by enclosing its name in single quotes.

Unplanned

Last Updated: 10 Jun 2022 10:00 by Mandip Kaila

SpreadProcessing: ArgumentException thrown when file contains format string with modificator [Color]

Created by: Mandip Kaila

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: ArgumentException thrown when file contains format string with modificator [Color]

Opening a file where there is a format string with modificator [Color11] causes an ArgumentException "Invalid modificator" This prevents the file from opening.

Unplanned

Last Updated: 15 Jun 2022 14:02 by Leigh

SpreadProcessing: Slow performance when auto fitting rows/columns in WASM

Created by: Leigh

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Slow performance when auto fitting rows/columns in WASM

Invoking AutoFitWidth/AutoFitHeight in Blazor WASM takes too long time even for small documents.

Completed

Last Updated: 28 Jun 2022 13:16 by ADMIN

Release R3 2022

SpreadProcessing: ArgumentException about the maximum column width thrown when xls file is imported

Created by: Anthony

Comments: 1

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: ArgumentException about the maximum column width thrown when xls file is imported

When an xls file with a large, but still valid column width is imported, an ArgumentException is thrown: "The maximum column width for an individual cell is 255 characters."

Completed

Last Updated: 07 Jul 2022 14:00 by ADMIN

Release R3 2022

SpreadProcessing: Expose method converting hex colors to Telerik.Documents.Media.Color

Created by: Leigh

Comments: 3

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Expose method converting hex colors to Telerik.Documents.Media.Color

Currently, similar conversions should be manually implemented by the users.

Sample method that could be used:

public static Color HexStringToColor(string hexColor)
{
    // Remove the # at the front.
    if (hexColor.StartsWith("#"))
    {
        hexColor = hexColor.Substring(1, hexColor.Length - 1);
    }

    byte a = 255;
    byte r = 255;
    byte g = 255;
    byte b = 255;

    int start = 0;

    // Handle ARGB strings (8 characters long).
    if (hexColor.Length == 8)
    {
        start = 2;
    }

    //Handle contracted RGB strings (3 characters long)
    if (hexColor.Length == 3)
    {
        hexColor = string.Format("{0}{0}{1}{1}{2}{2}", hexColor[0], hexColor[1], hexColor[2]);
    }
    else if (hexColor.Length < 6)
    {
        hexColor = hexColor.PadLeft(6, '0');
    }

    // Convert RGB characters to bytes.
    r = byte.Parse(hexColor.Substring(start, 2), NumberStyles.HexNumber);
    g = byte.Parse(hexColor.Substring(start + 2, 2), NumberStyles.HexNumber);
    b = byte.Parse(hexColor.Substring(start + 4, 2), NumberStyles.HexNumber);

    return Color.FromArgb(a, r, g, b);
}

Completed

Last Updated: 24 Jan 2023 10:29 by ADMIN

Release R3 2022 SP1

SpreadProcessing: PdfFormatProvider: Text is cut off in Net Standard with a specific document

Created by: Eddie

Comments: 8

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: PdfFormatProvider: Text is cut off in Net Standard with a specific document

Text is cut off in Net Standard with a specific document.

Unplanned

Last Updated: 21 Jul 2022 12:11 by Guilhem

SpreadProcessing: Cell size is different than expected when exporting to PDF

Created by: Guilhem

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Cell size is different than expected when exporting to PDF

Comparing PDF documents exported by MS Excel and by SpreadProcessing shows slightly different sizes of the cells.

Unplanned

Last Updated: 11 Aug 2022 10:20 by Owen

SpreadProcessing: Provide an option to set a hidden formula when protecting the worksheet.

Created by: Owen

Comments: 0

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Provide an option to set a hidden formula when protecting the worksheet.

In Excel, this is done by setting this option on the format cells dialog, the protection tab. It allows you to hide the formula when the sheet is protected.

Unplanned