formatting numbers

Hi everybody. As a newbie I have some troubles getting started with number fields. I create a simple listform with some text fields taking values from value lists. The numbers should be formatted without any commas or dots (e.g. 1001). The dataprovider is an integer field. Now in the smart client it displays the number as 1.001. l tried to do some formatting in the preferences>Servoy>I18N, writing stuff like #### in the number format field. Doesn’t work.

I also tried to manipulate the format in the properties panel. I can try from #### to #,######.00 or 0000 everything. Doesn’t make a change. Whether in the text field nor in the value list.

Any ideas? Thanks.

changing preferences in ‘preferences>Servoy>I18N’ are applied after restarting your solution.
Mind that these are the settings for default behaviour of any integer/number fields.

To set the formatting for a specific field, use the ‘format’ property of this particular field.
I think just a ‘#’ character should do what you are trying to achieve.

Thanks for the quick answer!

mboegem:
changing preferences in ‘preferences>Servoy>I18N’ are applied after restarting your solution.

I am aware of that. Now I set the format to #, restarted. Nothing changes.

mboegem:
To set the formatting for a specific field, use the ‘format’ property of this particular field.
I think just a ‘#’ character should do what you are trying to achieve.

That would be great. But it still looks the same. See image below:
[attachment=0]Bildschirmfoto 2010-07-27 um 15.26.38.png[/attachment]

The funny part is, that the field on the left, where I didn’t format anything shows the number as I’d like it to. but in the pull down menue value list, it’s the same story. 1.001:
[attachment=1]Bildschirmfoto 2010-07-27 um 15.26.50.png[/attachment]

any chance you can post a sample solution showing this behaviour?

something is going wrong here, but it’s easier if I could take a look at it directly…

mboegem:
any chance you can post a sample solution showing this behaviour?

something is going wrong here, but it’s easier if I could take a look at it directly…

Hmmm. How do I post a solution? I never went further than trying in the smart client from the developer tool…

heidiho:
Hmmm. How do I post a solution? I never went further than trying in the smart client from the developer tool…

from Serclipse rightclick on your solution and choose ‘Export’, then follow the dialogs presented.

Most ideal would be if you could export some sample data as well (also on option in the export dialog)
Once exported just attach the file to a reply in this thread.