B4PPC and decimal comma

[Scubaticus]

Here in the Netherlands we don't use the point but comma as our digit sign.
Normally this is controlled by local setting in windows (I use an english version with local setting to dutch). In, for example excel, this is working normally. In B4PPC however it seems it only will eat the point as decimal point.

So moving a textbox1.text with 51.5 to a cNumber cell, the value will be 51.5
When using 51,5 the cell has the value 515

When the first 51.5 however is shown in the table, when I display it in a form it fomrats as 51,5.

This both on my PC and PPC.

I fixed this by change the comma into a point when the field value changes, but that seems a very strange way to me.



Scub

[Erel]

The Table control will show numbers (cNumber fields) using the device format.
This is a limitation of the Table control.

[specci48]

Is it possible to use the device format generally so that I can do something like this:

a = 16,5
b = 3
c = a / b

specci48

[Scubaticus]

Originally Posted by Erel

The Table control will show numbers (cNumber fields) using the device format.

Well, this is no limitation for me as it behaves the way it should. I want a decimal comma and see a decimal comma. But how obout the input of 51.5 versus 51,5? It seems on the input there's a limitation?

Scub

[specci48]

With the input of 51.5 the point is handled as a decimal point so the variable value is 51.5.
With the input of 51,5 the comma is handled like a thousand separator (as in 123,456.78) which is of no use when the data is stored in a numeric variable. So the variable value is 515.


specci48

[Cableguy]

With the input of 51,5 the comma is handled like a thousand separator (as in 123,456.78) which is of no use when the data is stored in a numeric variable. So the variable value is 515.

If , is the thousands shouldnt 51,5 become 51500?

[specci48]

No, because the (useless) commas were only deleted. There's no converter or formatter adding possible trailing zeroes.

[Scubaticus]

Sub Globals

End Sub

Sub App_Start
Form1.Show

table1.AddCol(cNumber,"cNumber",50)
table1.AddRow(0)

End Sub

Sub Button1_Click
table1.Cell("cNumber",0) = TextBox1.Text
End Sub

The above code, when entered 5.5 gives in the table 5,5
When entered 5,5 the table gives me 55



Scub

[specci48]

This is a "normal" behaviour!

If you enter 5.5 we have a decimal point. So the value of the tablecell with format cNumber is 5.5. As Erel said, for showing the tablecontrol the control converts the values to the default device format. This is done only for the output. The internal variables still remain in the number format with decimal point.
If you enter 5,5 the value of the tablecell gets 55 (only the comma is removed). Showing this value in the tablecontrol (there is no format conversion necessary) will result in 55.

specci48

[Scubaticus]

Originally Posted by specci48

This is a "normal" behaviour!

"It's life Jim, but not as we know it, it's life"

I just have to get used to B4PPC, but it's going fast, thanks to all your quick replies! Well, still some problems to solve......

Scub.