MailMerge formatting negative/zero currency

[Carl Heavisides]

In MSWord if you use the mailmerge format:-

 /# "£#,##0.00;(£#,##0.00);"

Its supposed to put nothing when the number is zero - but it puts in 0.00 as if its formatting a positive number - its supposed to be "positive;negative;zero" -but its ignoring zero when it goes through syncfusions doc.io

Does syncfusion not support the zero part, or is there a different way to do it? Id rather not have to have long 'if statements' everywhere if possible. It would be nice if it just worked like it does in Word

Cheers,

Carl.

[Carl Heavisides]

I just got a little further on this.

Not sure if this will help you or not, but if you take out all the #'s - it correctly does not display a 0 value - the problem at this point is that you can't have comma's separating the thousands

so for example:-

\# "£,0.00;-£,0.00;''"

a value of 0 is correctly not displayed at all

a value of 1234 is displayed as £1234.00

and \# "£#,##0.00;-£#,##0.00;''"

a value of 0 is incorrectly displayed as £0.00

a value of 1234 is displayed as £1,234.00

[Manikandan Ravichandran]

Hi Carl,

Thank you for contacting Syncfusion.

We have reproduced the reported problem “Mailmerge formatting applied improperly” from our side. We will validate the reported problem and update you more details about this on 20^th January 2020.

Please let us know if you have any other questions.

Thanks and Regards, 

Manikandan Ravichandran 

[Carl Heavisides]

Hi, Will there be a patch for this?

Cheers,

Carl.

[Manikandan Ravichandran]

Hi Carl,

Thank you for your patient.

We have confirmed the reported issue “Currency format is not applied properly in Mail merge” from our side and we have logged a defect report for the same. The fix for this defect is estimated to be available on 10th February 2020.

The status of this feature task can be tracked through the below link:
https://www.syncfusion.com/feedback/11402/currency-format-is-not-applied-properly-in-mail-merge

Kindly share the assembly version used at your end to provide the patch.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran 

[Carl Heavisides]

I cant access that link, but the version I'm using is Syncfusion.DocIO.Base.dll v15.2400.0.479

[Manikandan Ravichandran]

Hi Carl,

Thank you for your update.

Now check the feedback link and let me know it can accessible of not. If it not accessible means, then share the screenshot of issue you faced while accessing the link.

Feedback Link:
https://www.syncfusion.com/feedback/11402/currency-format-is-not-applied-properly-in-mail-merge

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran 

[Manikandan Ravichandran]

Hi Carl,

Thank you for your patience.

We have fixed the mentioned formatting issue in mail merge execution. But you are using older version of assemblies in your project. We have included lots of bug fixes and features in the latest version. So, we suggest you to use our latest version assemblies which have more number of bug fixes and features. After that, we will provide the patch for the latest version.

You can download our latest version Essential Studio 2019 Volume 4 SP! Release v17.4.0.46. from the following link.
https://www.syncfusion.com/forums/151087/essential-studio-2019-volume-4-service-pack-release-v17-4-0-46-is-available-for-download

Please let us know, if you still need the patch for the older version (v15.2.0.40).

Regards,
Manikandan Ravichandran 

[Carl Heavisides]

This does not seem to have solved the issue at all?? Im definitely using 17.4400.0.46.

Also when updating, a whole raft of other issues seem to have appeared (I'm now getting "index out of bounds" errors when calling UpdateDocumentFields when I try to calculate with a figure from a bookmark -eg: { =SubTotal - VAT } where these are both bookmarks, which didn't occur before - but maybe that is for another support ticket)

The main issue is still exactly the same:

when I try to use the format \# "£,0.00;-£,0.00;''"

a value of 0 is correctly not displayed at all

a value of 1234 is displayed as £1234.00

not sure if this helps:

input

output

[Manikandan Ravichandran]

Hi Carl,

Thank you for your patience.

We have fixed the reported “Currency format is not applied properly in Mail merge” and the patch for the fix can be downloaded from the following link.

Recommended approach - exe will perform automatic configuration
Please find the patch setup from below location:
http://syncfusion.com/Installs/support/patch/17.4.0.46/649959/F150653/SyncfusionPatch_17.4.0.46_649959_2122020010326341_F150653.exe

Advanced approach – use only if you have specific needs and can directly replace existing assemblies for your build environment
Please find the patch assemblies alone from below location:
http://syncfusion.com/Installs/support/patch/17.4.0.46/649959/F150653/SyncfusionPatch_17.4.0.46_649959_2122020010326341_F150653.zip

NuGet :
http://syncfusion.com/Installs/support/patch/17.4.0.46/649959/F150653/SyncfusionNuget_17.4.0.46_649959_2122020010326341_F150653.zip

Assembly Version : 17.4.0.46

Installation Directions :
This patch should replace the files “Syncfusion.DocIO.Base.dll” under the following folder.
$system drive: \ Files\Syncfusion\Essential Studio\$Version # \precompiledassemblies\$Version#\4.0
Eg : $system drive:\Program Files\Syncfusion\Essential Studio\ 17.4.0.46\precompiledassemblies\ 17.4.0.46\4.0

To automatically run the Assembly Manager, please check the Run assembly manager checkbox option while installing the patch. If this option is unchecked, the patch will replace the assemblies in precompiled assemblies’ folder only. Then, you will have to manually copy and paste them to the preferred location or you will have to run the Syncfusion Assembly Manager application (available from the Syncfusion Dashboard, installed as a shortcut in the Application menu) to re-install assemblies.

Note:
To change how you receive bug fixes, ask your license management portal admin to change your project’s patch delivery mode.
https://www.syncfusion.com/account/license

Disclaimer:
Please note that we have created this patch for version 17.4.0.46 specifically to resolve the issue reported in the forum 150653.

If you have received other patches for the same version for other products, please apply all patches in the order received.

This fix will be included in our 2020 Volume 1 Main release which will be available in end of March 2020.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran

[Carl Heavisides]

Sweet, This patch fixed it, nice work! :)

[Manikandan Ravichandran]

Hi Carl,

Thank you for your update and confirmation.

We are glad to know that the reported issue gets resolved. Please let us know if you need further assistance in this. As always, we will be happy to assist you.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran