Skip to main content
Kofax

Numerical values entered in Set Content of Cell differ between versions

Article # 3040415 - Page views: 7

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 (1313377Cannot 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

 

Article # 3040415
  • Was this article helpful?