-
Bug
-
Resolution: Fixed
-
Normal
-
3.9.1
-
Security Level: Jimmy
Steps to Reproduce
copy/paste the initial range with conditional formattings multiple times
demonstrated here https://www.screencast.com/t/CywjRnbwWjA
Actual Result
the conditional formattings are copied correctly when pasting the first time
after the first copy/paste the conditional formatting rule formulas are translated incorrectly
Expected Result
consistent adjustment of formula references
Debug Info
after exporting to xlsx the conditional formatting rules can be inpected in excel showing the incorrect references
Root Cause
when copy/pasting the conditional formattings the Pts[] formula tokens of the original range are not cloned and the original refs get translated making things worse with every copy paste operation