search

saucepleez / taskt

taskt (pronounced 'tasked' and formely sharpRPA) is free and open-source robotic process automation (rpa) built in C# powered by the .NET Framework
http://www.taskt.net/
1.09k stars 351 forks source link

User Report: EU Math #177

Closed saucepleez closed 4 years ago

saucepleez commented 4 years ago

@jaribeiro73

I have also tested to disable the replace ',' by '.', because I am in European Union and here we use commas to separate euros from cents. The problem maintains. Taskt cannot do the math. The log says: 2019-12-25 14:50:25.892 +00:00 [INF] Running Line 15: Format Data [Format '{vPrice}' and Apply Result to Variable 'vOutputPrice'] 2019-12-25 14:50:26.184 +00:00 [INF] Result Code: Error 2019-12-25 14:50:26.184 +00:00 [INF] Error: System.IO.InvalidDataException: Unable to convert '(234,23 / 3)' to type 'Number' em taskt.Core.Automation.Engine.AutomationEngineInstance.ExecuteCommand(ScriptAction command) em taskt.Core.Automation.Engine.AutomationEngineInstance.ExecuteScript(String data, Boolean dataIsFile)

saucepleez commented 4 years ago

We have added support for math calculations and specifying the format of the numbers. The compute command currently only supports invariant culture so numbers at time of math execution can only be in invariant format rather than culture specific format.

For the Math Calculation command, we have enabled the users to define custom separators for performing math operations. We could enable a selection for "European" or "US" if needed.