Unsupported formula error when getting named ranges

Aspose.Cells Product Family
1

Hello!


I get an exception running the code below (the sample Excel file attached):
            var options = new AC.LoadOptions()

{

ParsingFormulaOnOpen = false,

};

        <span style="color:blue;">using</span> (System.IO.<span style="color:#2b91af;">FileStream</span> fstream = <span style="color:blue;">new</span> System.IO.<span style="color:#2b91af;">FileStream</span>(<span style="color:#a31515;">@"C:\Users\Leonid_Veriga\Desktop\DataIngestion\Files\21696\21696_Simple.xlsx"</span>, System.IO.<span style="color:#2b91af;">FileMode</span>.Open))
        {
            <span style="color:blue;">var</span> workbook = Aspose.Utility.<span style="color:#2b91af;">AsposeCellsHelper</span>.Instance.Open(fstream, options);
            <span style="color:blue;">var</span> namedRanges = workbook.Worksheets.GetNamedRanges();
        }</pre></div><div>Thanks,</div><div>Leo</div>
2

Hi Leo,

Thanks for your posting and using Aspose.Cells.

Please download and use the latest version: Aspose.Cells
for .NET v8.2.0.2 it works fine and does not exhibit any such issue.

We have tested it with the following code and it did not throw any exception.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\21696_Simple.xlsx”;


var options = new LoadOptions()

{

ParsingFormulaOnOpen = false,

};


var workbook = new Workbook(filePath, options);

var namedRanges = workbook.Worksheets.GetNamedRanges();

3

Yes, works in 8.2.0.2. Thanks!

4

Hi Leo,

Thanks for your feedback and using Aspose.Cells.

It is good to know that latest version has fixed your issue. Let us know if you encounter any other issue, we will be glad to look into it and help you further.