We have a Formula Field in Table cell inside a Word Document defined as below:
When the table in which the formula field is defined has less that 13 rows (e.g. 10); after UpdateFields function in Aspose is called, the Formula Field, displays the value as below:
"!B11 Is Not In Table".
The same formula is evaluated correctly (i.e. the non-existing table references (cells) are ignored) when the UpdateFields is executed using Word Automation or using F9 in Microsoft Word.
Is there an option in Aspose Words library that can be set to make Aspose behave same as Word.
NOTE: The formula needs to have non-existent references, so that the formula would work even if user manually inserts new rows in table.
We have recently switched from Word Automation to Aspose Word Library, due to which this issue has been highlighted. When using Word Automation the formula used to evaluate correctly.
UPDATE: Attached a test document. The formula field highlighted in YELLOW in the attached document has issue reported in this post.