Android Question invalid double : "90,12"

[Tayfur]

hello;
I open my excel file and read cells. after I add some value.
But, my code boken on data convert.
We use in my contry double format => "1.123.456,2345"
I dont have any problem when on AVD manager working at windovs.
So, Code has a problem in my tablet.
Code:

' Cell(1,2)="90,12"
New_value=cell(1,2)+0.15

I looked my tablet setting. I didint find float setting.

How can i fix it?

 

[eps]

I think you need to break down the steps in your calculation to see the values and when they are getting corrupted.

It feels like your issue is a numeric format issue.

 

[Tayfur]

I think you need to break down the steps in your calculation to see the values and when they are getting corrupted.

It feels like your issue is a numeric format issue.

how can i fix it

 

[Erel]

The decimal separator should be a dot.

You will need to do something like:

Dim cell As String =...
cell = cell.Replace(".", "").Replace(",", ".")

 

[Tayfur]

The decimal separator should be a dot.

You will need to do something like:

Dim cell As String =...
cell = cell.Replace(".", "").Replace(",", ".")

thank you Erel for your helps...