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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

MailMerge formatting negative/zero currency

Thread ID:

Created:

Updated:

Platform:

Replies:

150653 Jan 14,2020 09:26 PM UTC Feb 13,2020 05:47 AM UTC ASP.NET Web Forms 11
loading
Tags: DocIO
Carl Heavisides
Asked On January 14, 2020 09:26 PM UTC

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
Replied On January 14, 2020 11:00 PM UTC

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 [Syncfusion]
Replied On January 15, 2020 05:52 PM UTC

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 20th January 2020.

Please let us know if you have any other questions.

Thanks and Regards,
 
Manikandan Ravichandran 


Carl Heavisides
Replied On January 21, 2020 10:34 AM UTC

Hi, Will there be a patch for this?

Cheers,
Carl.

Manikandan Ravichandran [Syncfusion]
Replied On January 21, 2020 12:49 PM UTC

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
Replied On January 22, 2020 04:32 PM UTC

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

Manikandan Ravichandran [Syncfusion]
Replied On January 23, 2020 07:12 AM UTC

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 [Syncfusion]
Replied On February 10, 2020 03:19 PM UTC

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
Replied On February 11, 2020 04:37 PM UTC

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 [Syncfusion]
Replied On February 12, 2020 06:42 PM UTC

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
Replied On February 12, 2020 07:55 PM UTC

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

Manikandan Ravichandran [Syncfusion]
Replied On February 13, 2020 05:47 AM UTC

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
 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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

Live Chat Icon For mobile
Live Chat Icon