[Advanced Excel] Reading decimal vales from cell
Forge component by Carlos Freitas
Application Type
Traditional Web

I'm reading a cell value which is formatted as Number (with 2 decimals, with thousand separator).

When using Cell_Read action the returned cell value is converted to string according to the server regional settings. So if server settings set comma as decimal separator returned value will be, p.e., "123,456". If in your oml caller you then try to convert this text value to decimal using TextToDecimal (which according to documentation only allows dot as decimal separator) it will fail, setting result to zero.

EPPlus uses invariant culture (dot as decimal separator), so does OutSystems conversion actions. Shouldn't the man in the middle also?

Maybe something like this?


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.