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

Microsoft Excel Writer : "Data Validation" set in the template is reflected only in the first line of the output Excel file.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: 8.3.0.8 GA, 9.1.0 GA, 9.1.0.2 GA
    • Fix Version/s: Backlog
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      0
    • 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.
    • Steps to Reproduce:
      Hide

      Steps to reproduce

      1. Place the attached template.xlsx in C:\test.
      2. Start Spoon and create a new transformation.
      3. Create [Data grid] and [Microsoft Excel writer] steps and create hop between them.
      3. Double-click [Data grid] step and set following properties.
      [Meta] tab
      Name Type
      COL1 String
      COL2 String
      COL3 String

      [Data] tab
      COL1 COL2 COL3
      111 AAA <empty>
      222 BBB <empty>
      333 CCC <empty>

      Other properties are stay in default value.
      5. Double-click [Microsoft Excel writer] step and set following properties.
      [File&Sheet]tab
      filename : C:\test\output
      Extension : xlsx [Excel 2007 and above]
      Add filenames to result : <unchecked>
      If sheet exits in output file : write to existing sheet
      Use template when creating new files : <checked>
      Template file : C:\test\template.xlsx
      Use template when creating new sheets : <checked>
      Tenplate sheet : Sheet1
      Hide Template Sheet : <checked>

      [Content] tab
      Start writing at cell : A2
      When writing rows : overwrite existing cells
      Write Header : checked

      Fields
      Name Type Style from cell Field title
      COL1 String A2 COL1
      COL2 String B2 COL2
      COL3 String C2 COL3

      Other properties are stay in default value.
      6. Execute the transformation.
      7. Open C:\test\output.xlsx.

      Show
      Steps to reproduce 1. Place the attached template.xlsx in C:\test. 2. Start Spoon and create a new transformation. 3. Create [Data grid] and [Microsoft Excel writer] steps and create hop between them. 3. Double-click [Data grid] step and set following properties. [Meta] tab Name Type COL1 String COL2 String COL3 String [Data] tab COL1 COL2 COL3 111 AAA <empty> 222 BBB <empty> 333 CCC <empty> Other properties are stay in default value. 5. Double-click [Microsoft Excel writer] step and set following properties. [File&Sheet] tab filename : C:\test\output Extension : xlsx [Excel 2007 and above] Add filenames to result : <unchecked> If sheet exits in output file : write to existing sheet Use template when creating new files : <checked> Template file : C:\test\template.xlsx Use template when creating new sheets : <checked> Tenplate sheet : Sheet1 Hide Template Sheet : <checked> [Content] tab Start writing at cell : A2 When writing rows : overwrite existing cells Write Header : checked Fields Name Type Style from cell Field title COL1 String A2 COL1 COL2 String B2 COL2 COL3 String C2 COL3 Other properties are stay in default value. 6. Execute the transformation. 7. Open C:\test\output.xlsx.

      Description

      We have an Excel Template were Data Validations are set. When we use this template to output to an excel file using Microsoft Excel writer step, the data validations are only present in the first line. When we check data validations do not occur on the consecutive lines.

      Actual result
      "Data Validation" set in the template is reflected in the C2 cell of C:\test\output.xlsx, but "Data Validation" is not reflected after the C3 cell.

      Expected result
      "Data Validation" is reflected after C3 cell of C:\test\output.xlsx.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            nprakash Nikhil Prakash
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: