Style hyperlink is changed when using Format in a Set Content of Cell step

Issue

If Format is set when using [Set Content of Cell] step, the Style hyperlink of the output excel will be changed unexpectedly.

Cause

This is not a bug in DS, but a restriction of Apache POI used to manipulate Excel files. It looks like this issue was fixed in Apache POI 4.+ (in 10.7 POI 3.+ is used).

Solution

Unfortunately, the only solution is to switch to v11.1+.

Level of Complexity 

Easy

 

Applies to  

Product	Version	Build	Environment	Hardware
Kofax RPA	10.7.0.4

References

Add any references to other internal or external articles

 

Article # 3040273