Updating fields in a table

[stevenheggie]

Hi,

I have a formula in my table, however when i produce my document the formula does not update what code would do this.

Currently I am trying to convert the following code in to spire

For i = 1 To ActiveDocument.Fields.Count
ActiveDocument.Fields(i).Update()
Next

The ActiveDocument is the current word document that is being merged.

I have tried ActivedDocument.IsUpdateFields = True

But in my document i get !Undefined Bookmark, ABOVE

[amy.zhao]

Hi,

Thanks for your inquiry.
To help us recreate and resolve your issue, please provide us with your document.
Thanks.

Best Regards,
Amy
E-iceblue support team

[stevenheggie]

Hi,

i have attached the document.

[amy.zhao]

Hi,

Thanks for providing.
Sorry that our Spire.Doc doesn't support to calculate the formula field at present. We have added it as new feature into our schedule. We will inform you when it is supported.

Best Regards,
Amy
E-iceblue support team

[stevenheggie]

Ok thanks amy, do you have an approx time scale of when this will be added to spire?

[Gary.zhang]

Hello,

I am afraid now I can't provide you the time, once there is some update, we will let you know ASAP.

Thanks,
Gary
E-iceblue support team

[stevenheggie]

Ok thank you

[amy.zhao]

Hi,

Thanks for your waiting.
The feature has been supported. Welcome to download and test Spire.Office Platinum (Hot Fix) Version:2.12.8.

Best Regards,
Amy
E-iceblue support team

[stevenheggie]

Hi,

Thank you for the fix.

I have added in the new spire doc dll version 5.5.216.4041 and the new license dll. but when merging the document the formula doesn't update.

The code I am using is ActiveDocument.IsUpdateFields = True, is the correct line of code? (ActiveDocument being the document i have created.)

I am calling this code before I save the document.

[amy.zhao]

Hi,

Thanks for your feedback.
I tested your document(School.docx) with some simple data, and the formula({ =SUM(ABOVE) \# "0%" } ) worked fine on my side.
Would you please share all your code and used data for investigation?
Thank you.

Best Regards,
Amy
E-iceblue support team

[stevenheggie]

hi,

I wont be able to share my code as there is so much of it! can you share the example you used.

Overview of my code is that i have merge fields that are then used to find data for the matching merge field, then i am formating the document if any is needed, this is then saved. and before the document is saved is where i am using IsUpdateFields = True.

[amy.zhao]

Hi,

I am using the following code, and attached result file.

Code: Select all

  Document doc = new Document();
            doc.LoadFromFile("..\\..\\School.docx");
            doc.Replace("[Progress Score Descending.decGrade/1/3]", "10", true, true);
            doc.Replace("[Progress Score Descending.decGrade/1/4]", "11", true, true);
            doc.Replace("[Progress Score Descending.decGrade/1/5]", "12", true, true);
            doc.Replace("[Progress Score Descending.decGrade/1/6]", "13", true, true);
            doc.Replace("[Progress Score Descending.decGrade/1/7]", "14", true, true);
            doc.IsUpdateFields = true;
            doc.SaveToFile("result.docx",FileFormat.Docx2010);

Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hi,

Did your issue still exist?
If so, please share all your code for investigation. Thank you.

Best Regards,
Amy
E-iceblue support team

[stevenheggie]

Hi amy,

i havent had a a chance to look at this as yet, once i have i will let you know the outcome

[stevenheggie]

hi amy,

i have got it working, issue was with blank field i was bringing in on the word merge.

many thanks for your help