[teiid-issues] [JBoss JIRA] (TEIID-4995) Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator

[Marc Shirley (JIRA)]

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

Marc Shirley commented on TEIID-4995:
-------------------------------------

My thoughts were that this could potentially be applied with the default formatting for any string type column, as the current default behavior is essentially corrupting the data unless the user alters the data source.  The example for corruption in the current behavior is stock symbols for Asian markets where the symbol/code is an integer value.

As well, I believe DataFormatter might be formatting it in line with the formatting rules already applied towards the spreadsheet if the user has applied formatting to individual cells, so would still fall in line with what I would assume is the expectation of the average user.

> Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
> --------------------------------------------------------------------------------
>
>                 Key: TEIID-4995
>                 URL: https://issues.jboss.org/browse/TEIID-4995
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>    Affects Versions: 8.7.12.6_2, 8.12.11.6_3, 9.2.4
>         Environment: Excel translator
> Integer values in string columns
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>
> For integer values in a string column, values are displayed as a decimal value (for example, a value "5" is displayed as "5.0").  It looks like org.apache.poi.ss.usermodel.DataFormatter [1] by default attempts to format values in the same manner as Excel would display it [2], and would result in the integer value "5" being displayed as "5".  In the case of string columns, this would avoid the user needing to modify source data to compensate as indicated as workarounds in TEIID-3947.
> [1] https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataFormatter.html
> [2] The default number format will mimic the Excel General format: "#" for whole numbers and "#.##########" for decimal numbers.



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