Negative currency and Mail Merge format switches issue

Aspose.Words Product Family
1

Hi,

We use the following format switches to handle different currency formats.

We found an issue (minus sign is after $) when the merge field has negative decimal value. Please, refer to the following:

912×148 4.08 KB

for Investor_Sum4= -400.45

Regards

2

@profiler You should specify number format like this

{ MERGEFIELD Investor_Sum4 \# "$#,0.0;(#,0.0)" }

Where formatting before the semicolon is formatting for positive values and after it is formatting for negative values.

3

It works, thanks!

1 Like