Aspose Words : Merge Field String Comparison Operator Asterisk UpdateField Issue

Aspose.Words Product Family
1

I have the following formulas within a table-row-cell that has a start and end tag in the same row. I think there is a bug somewhere in the implementation of the ExecuteWithRegions when used with a custom IMailMergeDatasource that implements the GetChildDataSource which causes the UpdateFields function to fail with this specific formula under those conditions. I can use this same formula on a different field in the header and it works correctly and in fact the nested formula will update correctly if I press F9 or right-click the merge field and choose Update Field. So the specific problem I have is that this 1 formula field merge statement is not getting updated when I call UpdateFields().

If there is a work-around, or another way to accomplish what I am trying to do with this formula then please let me know.

I have put 4 different switch statements in a cell and only 1 of them does not update with my call to UpdateFields()

Non-Updating Formula (bug), this always results in “Standard Option” until I press F9
{ IF “{ mergefield easi_optioncode }” = “*STD” “Standard Option” “{ mergefield extendedamount }” }

Formulas that work in same cell
This one always results in Yes
{ IF “EASI” = “ASI" “Yes” “No” }

This one always results in No
{ IF “EASI” = "ASI” “Yes” “No” }

This one makes the correct run-time evaluation based on the data
<span style=“font-size: 11.0pt; line-height: 107%; font-family: “Calibri”,“sans-serif”; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: Arial; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA”>{ IF { mergefield extendedamount } > 0 “{ mergefield extendedamount }” “Standard Option” }

I’ve also tried using COMPARE with a couple of different variations and none of them seem to work.

2
Hi Scott,

Thanks for your inquiry.
skinnymoore:

Non-Updating Formula (bug), this always results in "Standard Option" until I press F9
{ IF "{ mergefield easi_optioncode }" = "*STD" "Standard Option" "{ mergefield extendedamount }" }

I have managed to reproduce the same issue at my side using attached test document. If your document is different from attached document, please share it here for our reference.

We have already logged this issue as WORDSNET-8347 in our issue tracking system. I have linked this forum thread to the same issue and you will be notified via this forum thread once this issue is resolved.

We apologize for your inconvenience.

3

Can you please tell me if this issue has been resolved yet?

Thanks,
Scott

4
Hi Scott,

Thanks for your patience.

I am afraid this issue WORDSNET-8347 has now been postponed till a later date due to some other important issues and new features. We will inform you as soon as there are any further developments.

We apologize for your inconvenience.

5

The issues you have found earlier (filed as WORDSNET-8347) have been fixed in this .NET update and this Java update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.