Decimal Point

i tryed

          MODIFY olWrkSh Range(TARGET)::NumberFormat = "0.00".

and

          MODIFY olWrkBk @Application::DecimalSeparator IS "."

but i still get comma "," for decimals.

Γεια σου Γιώργο (Hi George)

try setting the UseSystemSeparators property of Application to False

in VBA:

Application.UseSystemSeparators = False

in Cobol it should be something like:

MODIFY olWrkBk @Application::UseSystemSeparators IS False

when i had to set the Decimal Seperator it looks like this:

[quote][/quote]

          create  @Application of @Excel handle in xls-app.

          modify  xls-app    workbooks::Add() giving  xls-book.

          modify  xls-app    @VISIBLE = 1.

          modify  xls-app    @DecimalSeparator   = ",".

          modify  xls-app    @ThousandsSeparator = ".".

There is the DECIMAL_POINT IS COMMA configuration variable - here is the excerpt from the documentation:

-----------------------------------------------------------------------------------------------------------------------------

DECIMAL_POINT

This configuration variable sets the character to be used as the program's decimal point. Follow it with the desired character. If you use this variable to set the decimal point to a comma, then the place and function of the decimal point and comma are reversed (just like the phrase DECIMAL_POINT IS COMMA). The default is to use the decimal point specified by the program's source.

Note: You do not have to change the value of DECIMAL_POINT to match the decimal point used by floating point values received from external components. The runtime automatically makes the correct adjustment.

-----------------------------------------------------------------------------------------------------------------------------

It does change what is used as the decimal point globally for the runtime during it's execution.