CalculateFormula is throwing an object reference not set to an instance of an object error

Aspose.Cells Product Family
1

I am using the latest release version of the component.
PFA template !Next Gen Template.zip

Sample code:

        public class CellUDFMager : AbstractCalculationEngine
        {
            public override void Calculate(CalculationData data)
            {
                return;
            }
        }

var workbook = new Workbook(@"!Next Gen Template.xlsx");
workbook.Settings.FormulaSettings.CalculationMode = CalcModeType.Automatic;
workbook.Settings.FormulaSettings.EnableCalculationChain = true;

var manager = new CellUDFMager();
var options = new CalculationOptions
{
	CustomEngine = manager,
	IgnoreError = true,
	PrecisionStrategy = CalculationPrecisionStrategy.Decimal
};


//Either of these two combinations will throw an error
workbook.CalculateFormula();
workbook.CalculateFormula(options);

//workbook.CalculateFormula(options);
//workbook.CalculateFormula();

Exception Details
System.NullReferenceException
HResult=0x80004003
Message=Object reference not set to an instance of an object.
Source=Aspose.Cells
StackTrace:
at .(CellArea , , )
at .(CellArea

2

@Moonglum,

Thanks for the template file and details.

Please notice, I am able to reproduce the issue as you mentioned by using your template file and sample code. I found Workbook.CalculateFormula when using in combination is throwing an exception “Object reference not set to an instance of an object”. I have logged a ticket with an id “CELLSNET-51986” for your issue. We will look into it soon.

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

3

Is there a way you could ask management if customers can have early access to fixes like we used to?

I know we can get the fixes early with paid support, but this plan is prohibitively expensive just to have access to early versions.
Is there a lower-cost cost third option so customers could have where we just get early access to fixes only?

We need this, and I’m sure other customers will need it.
It would probably generate more revenue.

Thanks,
Dean

1 Like
4

@Moonglum,

We are sorry but there is no third option. Either you may wait for the supported (official) version to be released or avail paid support. We got to follow the policy across the board, the policy refers to fixes are posted in paid support desk only. In normal support forums, we can only share the results tested by our internal fix once we fix the issue.

5

@Moonglum,

This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v22.10) which is scheduled in the first/second week of October 2022. You will also be notified when the next version is released.

6

The issues you have found earlier (filed as CELLSNET-51986) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi