The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 Forum for Origin C
 translation into float failure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Niko1

Germany
Posts

Posted - 08/08/2005 :  07:37:52 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I have some data (string) which are written in a worksheet and I want to translate them in float values thanks to atof function but it's not working.For example it translates 24,57 in 24,00. I don't know what's wrong..Is anybody able to help me??
Thanks

easwar

USA
1965 Posts

Posted - 08/08/2005 :  09:54:50 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

The atof function is assuming that the decimal separator is '.' and not ','.

So you could do one of the following:

1> get the cell values directly from worksheet cells using code such as:

double dval = wks.Cell(1,0);



which takes into account the regional setting and will place the correct value in the variable

OR

2> remove all '.' from the string and then replace ',' with '.' to convert to English decimal format and then use atof, such as:


wks.GetCell(1,0, str);
str.Remove('.');
str.Replace(',','.');
double dval2 = atof(str);



Easwar
OriginLab

Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000