Page 1 of 1

ToCurrencyWords missing space proble

Posted: Mon Jul 27, 2015 2:44 am
by iamyong
Hi,

I'm using the string function ToCurrencyWords in a report, the problem is that the "dollars" word is not spaced, and the "and" word has a double space.

Sample:

Value: 70,000.00
When I use ToCurrencyWords(Value) I get: Seventy thousanddollars and zero cents

Am I missing a formatting configuration somewhere?

I have also tried to use the format: ToCurrencyWords(Value,true,true,"Dollars/Dollars","Cents/Cents") but i still get the same result as mentioned above. I am using Stimulsoft Reports.Net version: 2011.1.919.

Thanks

Re: ToCurrencyWords missing space proble

Posted: Mon Jul 27, 2015 5:36 am
by HighAley
Hello.

Please, upgrade to our latest build. There is no such issue.

Thank you.

Re: ToCurrencyWords missing space proble

Posted: Mon Jul 27, 2015 5:46 am
by iamyong
Hi Alex,

Thank you for the quick reply, I forgot to mention that constrained to use only the Stimulsoft version mentioned above. Is there no fix/workaround available for the version?

Thanks,

Re: ToCurrencyWords missing space proble

Posted: Mon Jul 27, 2015 11:59 am
by HighAley
Hello.

You could try to add space before Dollars like in the expression:

Code: Select all

{ToCurrencyWords(70000,true,true," Dollars/ Dollars","Cents/Cents")}
Thank you.

Re: ToCurrencyWords missing space proble

Posted: Tue Jul 28, 2015 11:20 pm
by iamyong
Holy moly that worked like a charm! I'm so embarrassed I didn't think of that one, thank you Aleksey!

Re: ToCurrencyWords missing space proble

Posted: Wed Jul 29, 2015 5:03 am
by Andrew
Hello,

Great! We are always glad to help you!