Calculate Update SUM Field Values in DOCX Word Document using .NET C# API

Aspose.Words Product Family
1

Hi Aspose team,

We have following problem that can be replicated with attached template:
Test.zip (9.8 KB)
Steps to replicate are - load document using Aspose.Words, run:
document.UpdateFields();
document.Save();

Open the result document - the SUM fields in last row of the table are not displayed. They appear correctly once you update the fields manually in Word.

Could you please take a look?

Thanks,
Mateusz

2

@acturisaspose,

We tested the scenario and have managed to reproduce the same problem on our end. For the sake of correction, we have logged this problem in our issue tracking system. The ID of this issue is WORDSNET-19645. We will further look into the details of this problem and will keep you updated on the status of correction. We apologize for your inconvenience.

3

Hi Awais,

thank you for logging the issue. Is there any possible workaround to get the value updated with the current version of Aspose, or there is no other way just to wait for the fix?

Thanks,
Mateusz

4

@acturisaspose,

I am afraid, you need to wait for the fix. Your issue (WORDSNET-19645) is currently ‘pending for analysis’ and is in the queue. We will inform you via this thread as soon as this issue will be resolved in future. We apologize for your inconvenience.

5

@acturisaspose,

Regarding WORDSNET-19645, it is to update you that after further investigation we have found that the SUM fields are actually updating correctly, but ,the field contains a space Run following the FieldStart node which is colored white. Aspose.Words applies white to the result of the field thus making it invisible (and it only becomes visible when field is selected). And MS Word does not.

So, in the meantime while you are waiting for a fix, please apply a color other than white to the first space character after the FieldStart node (looks as a white circle when the field is selected and hidden formatting is on):

Document.UpdateFields Calculates SUM Fields in Word Document

Or, to make things simpler, just select the whole field (or containing cell) and go to Font - Font Color then apply anything but white (Automatic would be fine).

We will inform you via this thread as soon as this issue will be resolved in future.

6

The issues you have found earlier (filed as WORDSNET-19645) have been fixed in this Aspose.Words for .NET 20.4 update and this Aspose.Words for Java 20.4 update.