Unplanned
Last Updated: 18 Mar 2024 08:00 by ADMIN
Jussi
Created on: 06 Mar 2024 07:51
Category: Telerik Document Processing
Type: Bug Report
2
SpreadProcessing: Exception "Sequence contains no matching element" on importing a document with a comment without an author
When importing an xlsx document with a comment that does not have an author, an exception is thrown "Sequence contains no matching element" Note that this is a different bug from the very similar SpreadProcessing: Exception "Sequence contains no matching element" thrown in files containing notes or comments (telerik.com)
2 comments
ADMIN
Yoan
Posted on: 18 Mar 2024 08:00

Hello VladimĂ­r,

Please correct me if I am wrong but from what I understand you are talking about having an Author for the actual document. This piece of metadata is supported by the library and can be obtained through the DocumentInfo property of the Workbook

Workbook workbook;
XlsxFormatProvider xlsxFormatProvider = new XlsxFormatProvider();

using (Stream input = new FileStream("inputFile.xlsx", FileMode.Open))
{
    workbook = xlsxFormatProvider.Import(input);
}

var author = workbook.DocumentInfo.Author;

...however, it does not play a role in this logged issue. This means that your document can have an author or not have an author and it will not cause any unusual results. 

Yet, this bug concerns the missing 'Author' property of Comments instead.

With that in mind, please verify whether or not the document you are using contains such comments and if so, please know that the exception you are experiencing is expected. However, if the file does not contain comments with no author, please feel free to open a separate ticket regarding your scenario so we can continue our conversation in private and try to resolve the issue you are facing there.

Regards,
Yoan
Progress Telerik

A brand new ThemeBuilder course was just added to the Virtual Classroom. The training course was designed to help you get started with ThemeBuilder for styling Telerik and Kendo UI components for your applications. You can check it out at https://learn.telerik.com
Vladimír
Posted on: 15 Mar 2024 11:19
this started happening for me after latest update, but even for files that do have author