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

Named range parser fails if using some characters

XMLWordPrintable

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

      Steps to Reproduce

      run keikai with attached documents

      Current Result

      fails with

      HTTP ERROR 500 io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsxHTTP ERROR 500 io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsxURI: /tutorial/editor.zulSTATUS: 500MESSAGE: io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsxSERVLET: DHtmlLayoutServletCAUSED BY: io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsxCAUSED BY: io.keikai.model.InvalidModelOpException: name 'japanese?dot' is not legal: the character '?' at index 8 must be a letter, a digit, an underscore, a period, a question mark, or a backslash

       

      io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsxio.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book bugRangeNameInternational.xlsx at io.keikai.importer.XlsxImporter.imports(XlsxImporter.java:308) 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:643) at io.keikai.ui.Spreadsheet.getSelectedSSheet(Spreadsheet.java:822) at io.keikai.ui.Spreadsheet.doInvalidate(Spreadsheet.java:2513) at io.keikai.ui.Spreadsheet.invalidate(Spreadsheet.java:2370) at io.keikai.ui.Spreadsheet.setSrc(Spreadsheet.java:867)

      Expected Result

      no error

      Debug Information

      Fails with characters such as chinese dot and japanese dot

      (works in excel)

      Workaround

      change to a different name

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

              Created:
              Updated:
              Resolved: