Problem with formulas

Aspose.Words Product Family
1

Hi,
I have a problem with formulas in Aspose.Words. This is the formula that I have:
{=PRODUCT({MERGEFIELD Hours * MERGEFORMAT};{MERGEFIELD CostRate * MERGEFORMAT})#0.00}

After merging the fields in the generated document I get the following:
!Syntax Error, «

When I right click on it and choose “Update field” the field gets updated and I see the correct value.

I think the problem is, because already in the template Product formula returns “Syntax error”, because instead of numbers it has mergefields in it. How can I overcome this issue?

I am using Aspose.Words 14.3.0.0

2

Hi Michal,

Thanks for your inquiry. Please upgrade to the latest version of Aspose.Words 14.7.0 from the following link:
https://releases.aspose.com/words/net

I hope, this helps.

In case the problem still remains, please attach your input Word document and code snippet here for testing. We will investigate the issue on our end and provide you more information.

Best regards,