Comments fields not correctly open from spreadsheetML

Aspose.Cells Product Family
1

Hi

I’m using Aspose.Cells to convert from spreadsheetML into excel, I observe that Aspose library generate comments differently from what Excel dose. On attached print screen you can see the result. comments_issue.png

In first test scenario file test.xml (spreadsheetML) was open directly in Excel.
In second the same file (test.xml) is convert in code to xlsx file and open in Excel.

Below is covering method code, to save on return workbook object is call save method.

public Workbook Convert( string spreadsheetFilePath )
    {
        var loadOptions = new LoadOptions( LoadFormat.SpreadsheetML );
        using ( var stream = new FileStream( path, FileMode.Open, FileAccess.Read, FileShare.ReadWrite ) )
        {
            return new Workbook( stream, loadOptions);
        } 
    }

In attachment you can find spradsheetML source file (text.xml) and both output excel files.

CommentIssue.zip (17.9 KB)

Thanks fro help
Mietek

2

@acturisaspose,

Thanks for using Aspose APIs.

We were able to observe this issue as per your description and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45520 - Comment fields are not correctly opened from SpreadsheetML
3

@acturisaspose

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-45520 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

@acturisaspose

Thanks for using Aspose APIs.

Please download and try the following latest fix and let us know your feedback.

5

The issues you have found earlier (filed as CELLSNET-45520) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).

6

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan