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

Formula in validation's formula field should follow the relative reference rule.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • None
    • None
    • None

      When define a Validation List:

      e.g

      formula1 "=A$1:B$1"

The applied region is B2:D2.
Then the real applied formula for 

B2 is =A$1:B$1
C2 is =B$1:C$1
D2 is =C$1:D$1

      Mainly, a concept of copy/paste.

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

              Created:
              Updated:
              Resolved: