XlsxFormatProvider.Import() throws when a cell is copied from Excel file

[Doug]

I'm using SpreadProcessing in conjunction with a Blazor TelerikSpreadsheet component and I've found that when I copy a cell from any Excel file and paste that into any cell in the TelerikSpreadsheet and then subsequently call XlsxFormatProvider.Import(), it throws an exception with the following message:

Not supported from value: start

I've attached a sample project to demonstrate the issue.

How can I successfully paste from Excel and then call XlsxFormatProvider.Import()?

[Dess | Tech Support Engineer, Principal]

Hello, Doug,

Indeed, the provided sample project leads to the described behavior after following the mentioned steps. It seems to be related to the exported content of the Blazor Spreadsheet component and the import functionality of SpreadProcessing. After copying data from Excel and pasting this into the Blazor Spreadsheet control, I saved the content to an Excel file. This file is expected to be imported in the XlsxFormatProvider, but it leads to the error. That is why I have logged it in our feedback portal by creating a public thread on your behalf. You can cast your vote for the item, track its progress, subscribe for status changes, and add your comments on the following link: 

SpreadProcessing: XlsxFormatProvider: InvalidOperationException: 'Not supported from value: start' when importing

I have also updated your Telerik points.  

Due to the specificity of the issue I am unable to suggest a stable solution. Make sure that you click the Follow button to get notified for any status changes.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

[Doug]

Dess,

Thank you for that. It's disappointing though because this blows up my project so now I'm going to have to go back to the drawing board. The only workaround I've found is to copy rows/cells from Excel, paste it into a text editor, copy the text and paste that into the TelerikSpreadsheet. Then everything works but I can't really expect my users to do that intermediate step.

[Dess | Tech Support Engineer, Principal]

Hello, Doug,

Indeed, the observed behavior is not a proper user experience. After discussing the case with the Blazor team who is responsible for the functionality of the Spreadsheet component, it seems that the exported document contains invalid horizontal alignment for the cell according the specification:

The horizontal alignment in the specification of the document format is defined as:

So "start" value for horizontal alignment is not a valid value. Since the SpreadProcessing library follows the Open XML standard, we can consider this case as importing an invalid document. Hence, I logged a separate public item for the Blazor Spreadsheet component and referred the previous SpreadProcessing item to item for better clarity and understanding. Make sure that you cast your vote for the item in order to increase its priority:

Spreadsheet: Invalid horizontal alignment value in exported Excel file

I believe that the Blazor team would do their best to introduce a proper fix accordingly. Should you have further questions related to the Document Processing Libraries please let me know.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik