conditional format formulas not adjusted correctly when copy/paste

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.9.2
    • Affects Version/s: 3.9.1
    • Component/s: ZSS Formula
    • 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

            Assignee:
            henrichen
            Reporter:
            cor3000
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: