Telerik Document Processing Feedback Portal

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: 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.

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: 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.

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.

Completed

Last Updated: 04 Apr 2022 07:41 by ADMIN

Release LIB 2022.1.411 (11 Apr 2022)

ADMIN

SpreadProcessing: Implement cell reference to whole columns and rows, e.g. $1:$2 and A:D

Created by: Deyan

Comments: 9

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Implement cell reference to whole columns and rows, e.g. $1:$2 and A:D

Implement support for cell references to columns and rows, e.g. $1:$2, A:D, etc.

Currently, CellSelection.SetValue throws ParseException, and CellSelection.SetValueAsFormula throws InvalidOperationException.

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: 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.

Unplanned

Last Updated: 28 Feb 2022 12:53 by ADMIN

SpreadProcessing: The formula when adding a number to a date is not calculated correctly.

Created by: Robert

Comments: 2

Category: SpreadProcessing

Type: Bug Report

SpreadProcessing: The formula when adding a number to a date is not calculated correctly.

The formula when adding a number to date is not calculated correctly.

Completed

Last Updated: 17 Feb 2022 15:22 by ADMIN

Release R1 2022 SP1

SpreadProcessing: Provide API for converting cell range name to CellRange

Created by: Dan

Comments: 3

Category: SpreadProcessing

Type: Feature Request

SpreadProcessing: Provide API for converting cell range name to CellRange

Provide API for converting cell range name to CellRange.

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

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.

Completed