Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-284

Named range parsers fails with X0 type ranges names

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.4.0
    • 5.2.0
    • None
    • None

      Steps to Reproduce

      run keikai with attached documentnameRangeBug.xlsx

      This document's A1 cell has received a named range named "A0"

       

      Current Result

      io.keikai.model.InvalidModelOpException: name 'A0' is not legal: cannot be a cell reference

      Expected Result

      no error

      Debug Information

      A0 is technically a legal named range in Excel, since there is no line 0

      Affects all names with pattern Letter0 (A0, B0, C0, ...)

      Workaround

      Change name

       

            wenninghsu wenninghsu
            MDuchemin MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: