"Type into" action and decimal separators

[cmarius (Marius)]

Hello,

I am trying to use “Type into” in Studio X in order to input a cell value from Excel (number) into another application.

The decimal separator in Excel is a comma (,). This is true for Windows regional settings as well.

However, when attempting to type in the value, Uipath uses a decimal point (.) instead. (which returns an error message from the app)

I tried formatting the Excel cell to text, but it didn’t work. Uipath is still using a decimal point, instead of a comma when typing in the value.

Is there a way to solve this in Studio X?

[Gabriele_Camilli]

Hi @cmarius,

The easiest is probably is Replace(Var.ToString,“.”,“,”) this will create a string in the format you want

[silvia.gualdron]

Hi, I am using a Write Cell action to perform a multiplication.

What to write: Quantity sold*Price.
|Quantity Sold|Price|Total|

|74| 45.17 |7445.17 |
|77| 49.43 |7749.43 |
|50| 48.87 |50*48.87 |

The issue is that I am getting the answer in above format, It is not really multiplying, just showing both results.

Any idea how to solve it?

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @silvia.gualdron ,

The issue is due to quantity and price both are strings. We need to convert them before multiplying. The solution should be (cint(Quantity sold) * cint(price)).tostring so write cell activity would enter the correct value.