[
https://issues.jboss.org/browse/TEIID-4995?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4995:
---------------------------------------
There needs to be some additional considerations here. The current functionality is
consistent with the data model. Making the functionality consistent with the formatting
can be more challenging. If we're not just targeting default formatting, then
there's a potential that the actual sheet formatting changes for arbitrary cell
ranges, which would be hard to capture in the metadata. Can we clarify how we expect to
capture the formatting details - a single execution flag "useDefaultFormatting",
at import (at a column level or down to cell ranges), etc.?
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....
[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)