topic Decimal notation issue in Adobe Forms in Application Development and Automation Discussions

Decimal notation issue in Adobe Forms

Former Member — Thu, 13 Feb 2014 06:08:19 GMT

Hi All,

I'm trying to display a quantity field in adobe form. Its working fine in English (Ex. 5,000)

But when I run the same in Spanish(ES), its displaying (5.000) even the user profile decimal notation is (1,234.56).

I want to print the quantity based on user profile settings.

I have gone through the other threads in SCN, but most of them suggest to use pattern (1,234) like that - but if I change user profile settings then pattern only work.

Any one please help on this.

Thanks,

Chandra.

Re: Decimal notation issue in Adobe Forms

former_member76372 — Thu, 13 Feb 2014 09:39:26 GMT

Instead of using a QUANTITY type field, use a character field to write in your adobe forms.

1. Transfer your quantity to a string/character type field.

2. Next thing you do, you get the information of the user's Decimal point format via USR01 - Then try to format it that way. A little coding will do.

3. Before you even pass it to the interface, initialize your quantity to a your desired decimal point format and pass a character-type field. OR You can also do it inside the interface code initialization, just add global variable you can use in your form.

Re: Decimal notation issue in Adobe Forms

Former Member — Thu, 13 Feb 2014 12:23:01 GMT

Hi Chandra,

I will presume that you are trying to print the same example in both languages. One way this issue would have been replicated is that if there are two documents with two different currencies.

In the initialization part of the form write the statement

SET COUNTRY.

This would override all decimal and date formats and use the ones mentioned in the user profile.

Regards,

Prem