ToCurrencyWords missing space proble
ToCurrencyWords missing space proble
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
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
Hello.
Please, upgrade to our latest build. There is no such issue.
Thank you.
Please, upgrade to our latest build. There is no such issue.
Thank you.
Re: ToCurrencyWords missing space proble
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,
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
Hello.
You could try to add space before Dollars like in the expression:
Thank you.
You could try to add space before Dollars like in the expression:
Code: Select all
{ToCurrencyWords(70000,true,true," Dollars/ Dollars","Cents/Cents")}
Re: ToCurrencyWords missing space proble
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
Hello,
Great! We are always glad to help you!
Great! We are always glad to help you!