Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-11341

Excel Input steps does not work with a ods file format (OpenOffice 3.4.1 )

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 4.3.0 GA (4.5.0 GA Suite Release), 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      5
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Pervach

      Description

      Excel Input file does not read the ODS file format. Attached below transformation, clicking on "Get Sheets" on the sheets tab throws a "Unable to recognise OLE stream" error , click OK on the error does not show up the sheet name.

      Re-opening the sheet tab again does not show the error, but its blank on the sheetname.

        Attachments

        1. ODSFileformat.png
          ODSFileformat.png
          11 kB
        2. sheetname.png
          sheetname.png
          11 kB
        3. test_excel.ods
          8 kB
        4. test.ktr
          12 kB

          Issue Links

            Activity

              People

              Assignee:
              ihar_chekan Ihar Chekan (Inactive)
              Reporter:
              sandeepck Sandeep Kemparaju
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: