Formula with MERGEFIELD

Good Day.

I need help.
I create template in word 2010 with next lines:

{MERGEFIELD Column2 \* MERGEFORMAT}
{MERGEFIELD Column3 \* MERGEFORMAT}
{ ={MERGEFIELD Column2 \* MERGEFORMAT}*{MERGEFIELD Column3 \* MERGEFORMAT}}

After filling this template with DocIO component i see this:
1
2
{ =MERGEFIELD Column2 \* MERGEFORMAT*MERGEFIELD Column3 \* MERGEFORMAT1*2}

My formula not working.

Do you know any solution to add a calculated field?
Regards







4 Replies

BO bozhday October 25, 2011 10:51 AM UTC

I update DOCIO component to version 9.4.0.62 and after generate template see next:
1
2
{=1*2}

I click 'Update' on last line and see:
1
2
2

It's ок, but can i don't click 'Update' and see right result in formula?

Thanks!




GT Gunasekaran T Syncfusion Team October 28, 2011 05:10 AM UTC

Hi Bozhday,

Thank you for your interest in Syncfusion products.

Essential DocIO provides support for updating field in Word documents. You can update the fields in word document by invoking UpdateDocumentFields() method of WordDocument class. Please do find the sample code to update fields in the word document using DocIO.

Code snippet:
// Opening the word document.
WordDocument document = new WordDocument("Input.doc");

// Updates the fields present in the document.
document.UpdateDocumentFields();

// Save the document.
document.Save("Sample.doc", FormatType.Doc);

For more information regarding field update support of DocIO, please refer our UG documentation and sample from the following location.

UG Documentation link:
http://help.syncfusion.com/ug_94/Reporting/DocIO/ASP.NET/default.htm?turl=Documents%2F44127fieldsupdatingengine.htm

Online sample link:
http://asp.syncfusion.com/sfaspnetsamplebrowser/9.4.0.62/Web/DocIO.Web/samples/4.0/Product%20Showcase/Update%20Fields/CS/UpdateFields.aspx

Please let us know if you have any other questions.

Regards,
Gunasekaran




BO bozhday October 30, 2011 10:09 AM UTC

Good Day!

Excellent result! Everything works fine.

A small personal observation. If you continue to see the formula after the generation of a document, try pressing ALT+F9 - this should help!

Thanks again for your help!





PR Poornima R Syncfusion Team November 3, 2011 12:37 PM UTC

Hi bozhday,

Thank you for your update.

Please let us know if you have any other questions.

Regards,
Poornima



Loader.
Up arrow icon