We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formula with MERGEFIELD

Thread ID:

Created:

Updated:

Platform:

Replies:

101449 Oct 25,2011 09:42 AM UTC Nov 3,2011 12:37 PM UTC Windows Forms 4
loading
Tags: DocIO
bozhday
Asked On October 25, 2011 09:42 AM UTC

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







bozhday
Replied On 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!



Gunasekaran T [Syncfusion]
Replied On 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



bozhday
Replied On 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!




Poornima R [Syncfusion]
Replied On 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



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;