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.06k stars 346 forks source link

Datatable and Variable do not allow leading zero(s) #285

Closed daileit closed 2 years ago

daileit commented 2 years ago

Hi saucepleez, Thank you for the cool software. It helps me a lot. But whenever I loaded a datatable from excel, all the string fields that contain number will be forced into normal number type. For example, the bill number fields which have the D8 string format (00001234,00123456 etc.) will be formatted to number and erase all the leading zero(s). Please add a way to convert numbers to numeric format strings or an option to determine the data type of Datatable in the first place.

daileit commented 2 years ago

Solved myself by setting "Set Engine Preference" to "Disable Automatic Calculations"