[teiid-issues] [JBoss JIRA] (TEIID-4995) Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
Marc Shirley (JIRA)
issues at jboss.org
Mon Jul 17 16:47:00 EDT 2017
Marc Shirley created TEIID-4995:
-----------------------------------
Summary: 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: 9.2.4, 8.12.11.6_3, 8.7.12.6_2
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)
More information about the teiid-issues
mailing list