search

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed
46 stars 16 forks source link

About decimal separator (the "point") #62

Closed jhernancanom closed 1 year ago

jhernancanom commented 3 years ago

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 commented 3 years ago

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.