Numerical values entered in Set Content of Cell differ between versions
Issue
Numerical values entered in Set Content of Cell differ between version.
The issue can be easily reproduced following these steps:
1. Enter the number "00404040" in the ShortText variable.
2. Input the variable into Excel with Set Content of Cell. At this time, the format is empty.
3. The entered values are different between 10.3.0.7 and 11.1.0.6.For 10.3.0.7, "00404040" will be entered. For 11.1.0.6, "404040" will be entered.
Cause
There was a bug (1313377: Cannot set formulas in Excel using variable nor expression) where the way input in Set Content of Cell was different for values than for variables and expression. After that was fixed, content was interpreted in the same way as Excel does it. That is, if a value can be interpreted as a number it would get cell type number, etc. The purpose of the Set Content of Cell was to set content in the way Excel does it. If one wanted to set a value of a specific type there is another step action: Set Value of Cell which does exactly that.
However, this is not a bug, but fixing the mentioned bug can cause some backwards compatibility problems.
Solution
Unfortunately, we haven't found any workaround still.
Level of Complexity
Easy
Applies to
| Product | Version | Build | Environment | Hardware |
|---|---|---|---|---|
| Kofax RPA | 10.3.0.7, 11.1.0.6 |
References