Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: 5.3.0
-
Fix Version/s: 5.4.0
-
Component/s: None
-
Labels:None
Description
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