-
Bug
-
Resolution: Fixed
-
Normal
-
5.3.0
-
None
-
None
-
None
Steps to Reproduce
run keikai with attached excel file
Current Result
HTTP ERROR 500 io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book 4-international.xlsx
| URI: | /tutorial/editor.zul |
|---|---|
| STATUS: | 500 |
| MESSAGE: | io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book 4-international.xlsx |
| SERVLET: | DHtmlLayoutServlet |
| CAUSED BY: | io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book 4-international.xlsx |
| CAUSED BY: | io.keikai.model.InvalidModelOpException: name '????????' is not legal: the character '?' at index 1 must be a letter, a digit, an underscore, a period, a question mark, or a backslash |
Caused by:
io.keikai.importer.ImportException: Fail to import named range in sheet Sheet1 from book 4-international.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
File import without error
alternatively, better error message indicating the original character string causing the issue.
Debug Information
Attached case fails with Thai script, but other international character sets may also fail with other character sets.
Workaround
do not use international characters for named ranges