[jboss-jira] [JBoss JIRA] (DROOLS-1378) Option: Force reading String from a Numeric type cell in SpreadSheet

[Mario Fusco (JIRA)]

    [ https://issues.jboss.org/browse/DROOLS-1378?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13336602#comment-13336602 ] 

Mario Fusco commented on DROOLS-1378:
-------------------------------------

[~tkobayashi] I don't understand why an user may want to put a text into a cell with Numeric type. Is there a valid use for this?

In general we should stop trying to parse any sort of garbage thrown in by users. This sort of guesses and type coercions causes many more damages than benefit on the long term and once they are in you cannot get rid of them anymore, otherwise you'll break compatibility.

> Option: Force reading String from a Numeric type cell in SpreadSheet
> --------------------------------------------------------------------
>
>                 Key: DROOLS-1378
>                 URL: https://issues.jboss.org/browse/DROOLS-1378
>             Project: Drools
>          Issue Type: Feature Request
>          Components: decision tables
>    Affects Versions: 7.0.0.Beta4
>            Reporter: Toshiya Kobayashi
>            Assignee: Mario Fusco
>
> org.drools.decisiontable.parser.xls.ExcelParser reads a double value from a Numeric type cell. But some users expect as-is String representation rather than a double value. Users may force String type by adding heading ' (apostrophe) in the cell but sometimes it could be cumbersome.
> This JIRA requests an option to force reading String from a Numeric type cell in SpreadSheet.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)