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'


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.

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