Fail to remove macro from xlt using Aspose Cells 19.7 for NET


#1

Hi there,
I using the following code snippet to remove macro from xlt file.

 using(var inStream = new FileStream(inputXltFile, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
       {
        var opt = new LoadOptions
                            {
                                MemorySetting = MemorySetting.MemoryPreference
                            };

        var workbook = new Workbook(inStream, opt);
        try {
                 if(workbook.HasMacro)
                 {
                            workbook.RemoveMacro();
                 }
        }
        catch (Exception e)
        {
                 Console.WriteLine(e.Message);
        }
      }

With Apsose Cells 19.2, the macro can be removed successfully. But with Aspose Cells 19.7, it throw an exception with message ‘Object reference not set to an instance of an object.’.21a97c8227ac49929ca33a7ae7888dd8.zip (71.5 KB)


#2

@dunghnguyen,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46854 – Exception raised while removing macro from XLT file

#3

@dunghnguyen,
This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46854”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.


#4

@dunghnguyen,

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

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.8.6 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.8.6 For .Net4.0.Zip (4.9 MB)