Incorrect sheet type for International Macro Sheet

Aspose.Cells Product Family
1
  • Create a new workbook in Excel.
  • Right click on worksheets » Insert… » International Macro Sheet
  • A new sheet Macro1 is inserted

Then the following code:

var workbook = new Workbook("InternationalMacroSheet.xlsm");
var sheetType = workbook.Worksheets[0].Type;

Results in an incorrect sheet type: “Worksheet”. In the docs, there are two types related to macros (VB and BIFF4Macro). Maybe one of them is expected, or a new sheet type “IntlMacro”.

Download the sample file here: InternationalMacroSheet.zip (6.6 KB)

2

@infotron,

Please notice, after an initial test, we reproduced the issue as you mentioned by using your sample code with your template file. We found an incorrect sheet type returned for International Macro Sheet. We have logged a ticket with an id “CELLSNET-47410” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

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

4

@infotron,
Please try our latest version/fix: Aspose.Cells for .NET v20.6.1:
Aspose.Cells20.6.1 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.6.1 For .Net4.0.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

This issue is fixed in Aspose.Cells v20.6.2. Thank you!

6

@infotron,

Good to know that your issue is fixed with the latest fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

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