[ https://issues.jboss.org/browse/DROOLS-1378?page=com.atlassian.jira.plugi... ] Toshiya Kobayashi commented on DROOLS-1378: ------------------------------------------- [~mfusco] Sorry about not explaining the use case well. Please have a look at the attached NumericDisabled.xls. It contains a cell "6600" but it will result in "6600.000000000001" in a generated DRL. The cell is copied from customer's XLS which is generated by VBA macro. Users see "6600" as its String representation regardless of how Excel stores its value behind. Changing "Format Cells" has no effect. Does this make sense that users want to get "6600"? Another example is BasicWorkbook_with_low_values.xls which is tested by SpreadsheetCompilerUnitTest#testProcessSheetForExtremeLowNumbers() https://github.com/droolsjbpm/drools/blob/master/drools-decisiontables/sr... This test intentionally asserts double values (e.g. "3.0E-4"). But this option allows users to get "0.0003" which is the as-is String representation of the cell. -- This message was sent by Atlassian JIRA (v7.2.3#72005)