We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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

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.

@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.