Uploaded image for project: 'Elements Spreadsheet'
  1. Elements Spreadsheet
  2. SP-341

Some formula references are not detected

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 3.2.1
    • Fix Version/s: 3.2.2
    • Labels:
      None

      Description

      How to reproduce:

      In A1, type:

      =IF(B1<B2;"OK";"NOK")

      and validate. Then, stretch from A1 to A3.

      Expected:

      A1, A2, A3 should contain the given formula:

      Cell Formula
      A1 =IF(B1<B2;"OK";"NOK")
      A2 =IF(*C*1<*C*2;"OK";"NOK")
      A3 =IF(*D*1<*D*2;"OK";"NOK")

       

      Current:

      Cell Formula
      A1 =IF(B1<B2;"OK";"NOK")
      A2 =IF(*B*1<*B*2;"OK";"NOK")
      A3 =IF(*B*1<*B*2;"OK";"NOK")

       
      Explanation:

       The regular expression in charge of detecting cell-reference seems to no handle operator correctly. If you add spaces between the references and the operator, like this :

      =IF(B1 < B2;"OK";"NOK")

      Then, references are detected.

       
      Impact:

      This issue impacts features which need to update references after specific actions, like :

      • Stretch a formula across other cells
      • Copy / Past cell with formulas
      • Update references after a sort operation
      • Coloration of the cell referenced (in the table and in the StatusBar)

      However, the formula engine (third-party code) seems to detect these references correctly.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              julien.cousinie@valiantys.com Julien Cousinie
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: