Very large numbers get imported as ​4.35e+08

[farling42]

See http://forums.wolflair.com/showpost.php?p=276758&postcount=477

"I had one cell formatted like this: 999.999.999,99 -> it is a price column and excel showed the numbers in a convinient way. Very high prices were also imported as ​4.35e+08​ for example."

[farling42]

A simple test using UK command and decimal point showed 999999999.99 appearing in Realm Works.

The user's native language is German, so uses "," as the decimal point. This import as "99999999999."

[farling42]

The XML format for numbers does not allow any characters to separate multiples (e.g. thousands), and expects "." to be used as the decimal point.

[farling42]

When converting to a value for a Numeric field, use the QLocale::system().toDouble(str, &ok) to perform the correct conversion, rather than just QString::toDouble()

If QLocale() fails, then try QLocale::c().toDouble()

If that also fails, then report a problem.

[farling42]

CSV2RW is in maintenance mode now.