Importer fails with valid cell names - Edge case "\" and similar characters

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 5.4.0
    • Affects Version/s: 5.3.0
    • Component/s: None
    • None
    • None

      Steps to Reproduce

      Run Keikai with attached Excel document

      Document contains a named ranged "\" targetting A1

      Current Result

      HTTP ERROR 500 io.keikai.importer.ImportException: Fail to import cell B1 in sheet Sheet1 from book 1-backslash.xlsx

      URI: /tutorial/editor.zul
      STATUS: 500
      MESSAGE: io.keikai.importer.ImportException: Fail to import cell B1 in sheet Sheet1 from book 1-backslash.xlsx
      SERVLET: DHtmlLayoutServlet
      CAUSED BY: io.keikai.importer.ImportException: Fail to import cell B1 in sheet Sheet1 from book 1-backslash.xlsx
      CAUSED BY: io.keikai.model.InvalidFormulaException: The specified formula '\' contains an error. Expects cell reference or constant literal.

      Caused by:

      io.keikai.importer.ImportException: Fail to import cell B1 in sheet Sheet1 from book 1-backslash.xlsx at io.keikai.importer.XlsxImporter.imports(XlsxImporter.java:319) at io.keikai.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:48) at io.keikai.range.impl.imexp.AbstractImporter.imports(AbstractImporter.java:57) at io.keikai.ui.Spreadsheet.getSBook(Spreadsheet.java:649) at io.keikai.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:828) at io.keikai.ui.Spreadsheet.doInvalidate(Spreadsheet.java:2546) at io.keikai.ui.Spreadsheet.invalidate(Spreadsheet.java:2403) at io.keikai.ui.Spreadsheet.setSrc(Spreadsheet.java:877)

      Expected Result

      Works in Excel

      Debug Information

      Affects also names containing backslash with other characters such as "\abc" or "\123"

      Workaround

      Do not use "\" in named ranges

       

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

              Created:
              Updated:
              Resolved: