"No RuleTable cells in spreadsheet" ----------------------------------- Key: DROOLS-1382 URL: https://issues.jboss.org/browse/DROOLS-1382 Project: Drools Issue Type: Bug Components: decision tables Affects Versions: 6.3.0.Final, 6.5.0.Final Environment: OSX 10.12 Excel for Mac Drools 6.3.0.Final and Drools 6.5.0.Final Intellij IDEA Ultimate 2016.1 second machine Intellij IDEA CE 2016.2 Reporter: John Dunning Assignee: Mario Fusco Priority: Blocker Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final Checked out the Drools6.3.0 example code, and also example code from Mastering Drools 6 book for RuleTemplates using spreadsheets as template data. Both projects compile and work in their own environment. Replicated similar for a Government Project and KnowledgeBase compilation fails with "No Ruletable cells in Spreadsheet". This ruleset is one ruleset in a multi-ruleset project that is configured using kmodule.xml. Other rulesets include DRL and Decision Tables. The rules for this ruleset are in the same package in src/main/resources of a project that also includes all the executable code. The fact model is also included in the executable code. Created an excel spreadsheet using Excel for Mac, and created the DRT file. The rules also include a DRL file. Got the "No Ruletable cells in Spreadsheet" error when building the knowledge base. Removed the DRL file and the KnowledgeBase built. Put the DRL file back and the KnowledgeBase still built. Copied the project and the problem recurred. Created separate projects for each ruleset - each with its own kmodule.xml. Each ruleset is a Maven Module in a Maven Project. This ruleset contains only one DRT, one DRL and and XLS with data only. It also contains java code for one fact. Cannot create a KnowledgeBase from this ruleset even when dependencies for all other rulesets are commented out. None of the other rulesets use templates but they do use decision tables, DRL files and have facts specific to the ruleset. Moved the RuleSet from a Maven Module to a separate Maven Project. Problem still recurred. Separated the Fact Model (single fact) into a separate Maven Project. Problem still recurred. Wondered if it may be a issue with Excel for Mac so copied the xls and DRT files from both Drools 6.3 examples and Mastering Drools examples and neither compiles when copied and pasted into a new project - same error "No Ruletable cells in Spreadsheet". Moved Drools to 6.5.0.final and problem recurred IDE - Intellij IDEA Ultimate 2016.1 second machine Mac OSX Drools 6.3.0.Final and recreated in Drools 6.5.0.Final I can be contacted for more information and/or an example project that replicates the problem.