ExcelParser does not read double < .0001 from Excel cell
--------------------------------------------------------
Key: JBRULES-3294
URL:
https://issues.jboss.org/browse/JBRULES-3294
Project: Drools
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: drools-decisiontables
Affects Versions: 5.3.0.Final
Environment: Run on Vista Eclipse Helios
Reporter: J T
Assignee: Mark Proctor
Using a minimal Excel spreadsheet as a decision table, and a simple rule that always
fires, and passing a small number into a method on the rhs, if the number is <.0001,
the value will be rounded to 0 and switched to an int. It looks like when the jxl command
"cell.getContents()" is fired in the processSheet method, the return value is
rounded for very small numbers. I believe that if the type is numeric, you should be able
to get the value from jxl like:
double num;
if (cell.getType() == CellType.NUMBER)
{
NumberCell nc = (NumberCell) cell;
num = nc.getValue();
}
Then the call could be:
newCell(listeners, i, cellNum, String.valueOf(num), DataListener.NON_MERGED );
This should keep the precision of the number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see:
http://www.atlassian.com/software/jira