Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1317

conditional format formulas not adjusted correctly when copy/paste

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.9.2
    • 3.9.1
    • 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

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

              Created:
              Updated:
              Resolved: