Description of problem: If my XLS decision tables has even one cell blank in any column then the conversion to the guided decision table does not happen. The error log and xls dt is attached. (Logs_EmptySpreadsheetCells.txt and EmptySpreadsheetCells.xls) Version-Release number of selected component (if applicable): BRMS 6.1.2 How reproducible: always Steps to Reproduce: 1. Upload XLS including blank cells into the business-central 2. Try to convert it to Guided Decision Table 3. The conversion fails Actual results: The conversion of XLS decision table to GDT fails, if the XLS includes blank cells. Expected results: The conversion of XLS decision table to GDT succeeds, even if the XLS includes blank cells. Additional info: The xls table is valid, the project can be built successfully, the empty cells should not be simply included in the generated GDT.
Created attachment 1066745 [details] EmptySpreadsheetCells.xls
Created attachment 1066746 [details] Log_EmptySpreadsheetCells
Created attachment 1066747 [details] Model.jar
I wrote a test using the attached XLS file and, given the referenced fix for GUVNOR-2188, it passed without problem. I suspect the "empty" cells correspond to the subject of the referenced JIRA i.e. "Converting XLS Decision Tables fails a row doesn't contain all necessary cells".
I followed the steps above and I was able to convert the XLS table with blank cells to a GDT without problems. I used BRMS 6.2.0.ER4.