Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4995

Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 10.0
    • 8.7.12.6_2, 8.12.11.6_3, 9.2.4
    • Misc. Connectors
    • None

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: