Table Formula exceptions:'Cannot change part of the array/table formula'

Aspose.Cells Product Family
1

Hi,

I’ve been running into an issue where whenever we need to change a formula that has a Table formula in it, the following exception occurs:

Aspose.Cells.CellsException: ‘Cannot change part of the array/table formula’

For example, if a formula were =TABLE(M20,H52), then trying to change that formula or set the formula of that cell for something else would throw the exception above.

Please advise.

2

@jasonleecanalyst,
Please share your sample file and code snippet with us for our testing. We will reproduce the problem and provide our feedback after analysis.