Hi!
I’m probably missing something here or I’m not understanding the purpose of an option, but I’d like to know if anyone else sees this problem.
I have several fields, programmed as decimals, with a dot as decimal separator, 2 digit precision, values from -40 to 40, negative number format -1.1. The field obviously should accept negative/positive values.
The thing is that when I run the form, and for example, I want to enter 25.18, the numbers start to be filled from right to left and the decimal separator is ignored if I type it. It’s not really intuitive to fill the number this way, but it works.
Trying to find a solution to this, I tried the option “auto-complete with zeros”… I understood that I could enter my number, and in case I did not fill the decimal digits, they would be automatically filled with zeros… but it does not work that way it seems.
When the option is turned on, entering numbers on the field start filling it from left to right (voil?!)… but no decimal digits are allowed.!!!.. unless the field is only for positive numbers OR only negative numbers… but not both at the same time.
Maybe it’s a little bit awkward to explain, but this table might help: [TABLE=“border: 1, cellpadding: 1, width: 500”]
[TR]
[TD]Accept (option on form field)[/TD]
[TD]Auto-Complete with zeros (option on form field)[/TD]
[TD]field is filled from[/TD]
[TD]can enter decimal digits[/TD]
[/TR]
[TR]
[TD]only negative[/TD]
[TD]ON[/TD]
[TD]left to right[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]only negative[/TD]
[TD]OFF[/TD]
[TD]right to left[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]only positive[/TD]
[TD]ON[/TD]
[TD]left to right[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]only positive[/TD]
[TD]OFF[/TD]
[TD]right to left[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]negative/positive[/TD]
[TD]ON[/TD]
[TD]left to right[/TD]
[TD]NO (filled with zeros always)[/TD]
[/TR]
[TR]
[TD]negative/positive[/TD]
[TD]OFF[/TD]
[TD]right to left[/TD]
[TD]yes[/TD]
[/TR]
[/TABLE]
In summary, I have been unable to have the field work WITH decimal digits, and being filled from left to right, which is the most intuitive thing for me.
Help on the auto-complete with zeroes, isn’t really very helpful. One could understand that it just fills the field with decimal zeroes, but if that’s the case, I don’t really find it useful (there would be no purpose in having a decimal field, except for being displayed that way), and besides, according to my table, it does not work that way either, except for one case.
BTW…: i checked this behaviour on SC 9.3.006. I also tried creating a new form, and just adding a decimal field (to rule out other problems with my previous form). Also ruled out Regional Settings… it works the same with custom rules (custom decimal separator)
I appreciate some feedback guys!
Thx
Mariano