Workbook Save Exception - after clear comment

Aspose.Cells Product Family
1

hi,
we received following message from aspose:
Index was out of range. Must be non-negative and less than the size of the collection. Parameter
AsposeSupport.zip (477.9 KB)

if you process Clear comments from attached excel … than save the workbook in different name, you can reproduce this. We believe the arrow on the attached workbook sheet is the one cause the issue.
public void ClearAllWorkbookComments()
{
foreach (var sheet in _workbook.Worksheets)
sheet.Comments.Clear();
}

Can you please let us know if you need more information.

2

@catalparue26,
I can not reproduce this issue with following code using AsposeSupport.xlsm file.

foreach (var sheet in _workbook.Worksheets)
sheet.Comments.Clear();

Please try our latest version/fix: Aspose.Cells for .NET v20.7.3:
Aspose.Cells20.7.3 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.3 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.7.3 For .NetStandard20.Zip (5.3 MB)

Let us know your feedback.

3

hi, latest version does NOT work! let me share more code…

    private Workbook _workbook;
    protected void AsposeBug1()
    {
        _spreadsheet.OpenWorkbook();
        _workbook = new Workbook("SourceFolder\\TEL2.xlsm"); 

        foreach (var sheet in _workbook.Worksheets)
            sheet.Comments.Clear();

        _workbook.Save("C:\\Temp\\target.xlsx");==> fail here! 
    }
4

@catalparue26,
We have observed this issue and logged in our database for investigation and a fix (if possible). We will notify you here once any update is available for sharing.

This issue is logged as:
CELLSNET-47525-Saving a workbook raises exception after clearing the comments

5

@catalparue26,

We are pleased to inform you that your issue has been resolved. You will soon get the fixed version in the next few days after we have done QA and included other enhancements and fixes.

6

great! let me know once the fix version is available.

7

@catalparue26,

Sure, we will share the download link to the fix once the fix is available for public usage.

8

@catalparue26,

Please try our latest version/fix: Aspose.Cells for .NET v20.7.6 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells20.7.6 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.7.6 For .Net4.0.Zip (5.4 MB)

9

hi, thank you. Can you also let us know what is the cause of the issue? is that the arrow in the excel sheet attached?

10

@catalparue26,

We will get back to you to provide you the required details soon.

11

@catalparue26,

There are some connector shapes and each connector shape contains links to other shapes. We found Aspose.Cells was not updating links when removing shapes in the previous versions.

12

hi, the version attached works! let us know when it will be in nuget.

13

@catalparue26,

We are scheduled to publish our next official release, i.e., Aspose.Cells for .NET v20.8 within the next couple of weeks. The release will be published on both Downloads section and Nuget repos. You will also be notified here once we release the version.

Keep in touch.

14

The issues you have found earlier (filed as CELLSNET-47525) have been fixed in Aspose.Cells for .NET v20.8. This message was posted using Bugs notification tool by Amjad_Sahi