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

[Toshiya Kobayashi (JIRA)]

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

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/src/test/java/org/drools/decisiontable/SpreadsheetCompilerUnitTest.java#L374-L389

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.

> 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
>         Attachments: BasicWorkbook_with_low_values.xls, NumericDisabled.xls
>
>
> 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)