About decimal separator (the "point")

[jhernancanom]

Hi, Greg and friends. I am creating an XLSX based in a cursor. The numbers are saved using the point as decimal separador and no thousand separator.

But when I open the resulting XLSX in Excel, I see that the decimal separator is comma, and thousand separator is point.

Then I cannot sum, format nor build formulas with the numbers in it.

Is there a way to (1) save the data --internally may be-- with point decimal separator, and (2) that --when Excel opens the file-- it can use the format according to Windows Control panel?

[jhernancanom]

Sorry. I have realize that I am using a DBF with all fields of character type. This way Excel will treat all as character.

Closed this issue.