Telerik Document Processing Feedback Portal

Completed

Last Updated: 18 Apr 2022 09:05 by ADMIN

Release R2 2022

ADMIN

SpreadProcessing: Changing the format of the first value of the first range of a chart causes NullReferenceException if the chart does not have axes

Created by: Anna

Comments: 1

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Changing the format of the first value of the first range of a chart causes NullReferenceException if the chart does not have axes

The format applied to the first value of the range of the chart determines the format of the value (vertical) axis. If the format of this value is changed, the model attempts to set a new format to the axis. If the chart does not support axes, the value of its PrimaryAxes property is null, which causes NullReferenceException.

Unplanned

Last Updated: 05 Apr 2022 09:38 by Monique

SpreadProcessing: Introduce support for the WEEKDAY function

Created by: Monique

Comments: 0

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Introduce support for the WEEKDAY function

Introduce support for the WEEKDAY function.

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.

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: 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: 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 Aug 2022 12:18 by ADMIN

Release LIB 2022.2.822 (22 Aug 2022)

Spreadsheet: The pie chart is not rendered correctly and is not converted to pdf as expected

Created by: n/a

Comments: 0

Category: SpreadProcessing

Type: Bug Report

Spreadsheet: The pie chart is not rendered correctly and is not converted to pdf as expected

The pie chart is not rendered correctly and is not converted to pdf as expected.

Completed

Last Updated: 14 Mar 2022 16:08 by ADMIN

Release R2 2022

SpreadProcessing: Conditional Formatting is exported for the active sheet only

Created by: Grace

Comments: 1

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Conditional Formatting is exported for the active sheet only

Applying conditional formatting to different worksheets and exporting the file to XLSX results in a file with conditional formatting on the active sheet only. The conditional formatting on the rest of the worksheets is lost.

Completed

Last Updated: 18 Apr 2022 14:08 by ADMIN

Release R2 2022

SpreadProcessing: DataTableFormatProvider: One should be able to set the AllowDBNull property of each column

Created by: Terry

Comments: 1

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: DataTableFormatProvider: One should be able to set the AllowDBNull property of each column

DataTableFormatProvider: One should be able to set the AllowDBNull property of each column.

Completed

Last Updated: 09 Feb 2022 14:20 by ADMIN

Release R1 2022 SP1

SpreadProcessing: IndexOutOfRangeException thrown when exporting file in Russian culture under Windows 7 and target platform is .NET Standard version

Created by: alex

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: IndexOutOfRangeException thrown when exporting file in Russian culture under Windows 7 and target platform is .NET Standard version

The error is with a message "Index and count must refer to a location within the string (Parameter 'count')" and is thrown inside the FormatHelper.FindAllOccurrences method.

Unplanned

Last Updated: 07 Feb 2022 15:55 by Divya

SpreadProcessing: Implement Spilled range operator

Created by: Divya

Comments: 0

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Implement Spilled range operator

The Spilled range operator (#) is responsible for selecting the whole range of values used after a cell reference.

Unplanned

Last Updated: 05 Apr 2022 07:08 by ADMIN

SpreadProcessing: Add support for ActiveX controls

Created by: Divya

Comments: 2

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Add support for ActiveX controls

A feature in Excel allows adding ActiveX controls in the Worksheets. You can insert the ActiveX controls from the Developer ribbon tab from the insert button. As it is a missing feature it is not imported and thus removed from the document on export.

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.

Unplanned

Last Updated: 08 Feb 2022 12:47 by ADMIN

SpreadProcessing: Indirect function cannot get named range by name as string or cell value

Created by: Ruben

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Indirect function cannot get named range by name as string or cell value

Indirect function cannot get named range by name as string or cell value.

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.

Completed

Last Updated: 16 Feb 2022 12:55 by ADMIN

Release R1 2022 SP1

SpreadProcessing: Notes are not updated after inserting or removing cells

Created by: Joseph

Comments: 0

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: Notes are not updated after inserting or removing cells

If some notes exist below the inserted/removed cells, the notes need to be moved as well along with the rest of the cells. Currently, after insert/remove, the notes are still associated with the original cell index thus are in the wrong cells.

Completed